Editing Soundex (section)

{{short description|Phonetic algorithm for indexing names by sound}}
'''Soundex''' is a [[phonetic algorithm]] for [[Index (publishing)|indexing]] names by sound, as [[Pronunciation|pronounced]] in English. The goal is for [[homophone]]s to be [[Encoding|encoded]] to the same representation so that they can be matched despite minor differences in [[spelling]].<ref name="NARA_TSIS"/> The algorithm mainly encodes consonants; a vowel will not be encoded unless it is the first letter. Soundex is the most widely known of all [[phonetic algorithm]]s (in part because it is a standard feature of popular database software such as [[IBM Db2]], [[PostgreSQL]],<ref>{{cite web |title=Documentation: 9.1: fuzzystrmatch |url=http://www.postgresql.org/docs/9.1/static/fuzzystrmatch.html |url-status=live |archive-url=https://web.archive.org/web/20200723051204/https://www.postgresql.org/docs/9.1/fuzzystrmatch.html |archive-date=23 July 2020 |access-date=3 November 2012 |work=[[PostgreSQL]]}}</ref> [[MySQL]],<ref>{{cite web |title=MySQL 5.5 Reference Manual :: 12.5 String Functions |url=http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_soundex |url-status=live |archive-url=https://web.archive.org/web/20160915100011/https://dev.mysql.com/doc/refman/8.0/en/string-functions.html |archive-date=15 September 2016 |work=MySQL |at=SOUNDEX(str)}}</ref> [[SQLite]],<ref>{{cite web |date=16 July 2022 |title=Built-In Scaler SQL Functions |url=https://www.sqlite.org/lang_corefunc.html |url-status=live |archive-url=https://web.archive.org/web/20221220094344/https://www.sqlite.org/lang_corefunc.html |archive-date=20 December 2022 |access-date=24 December 2022 |work=SQLite |at=soundex(X)}}</ref> [[Ingres (database)|Ingres]], [[Microsoft SQL Server|MS SQL Server]],<ref>{{cite web |date=10 January 2010 |title=SOUNDEX (Transact-SQL) |url=http://msdn.microsoft.com/en-us/library/ms187384(v=SQL.100).aspx |url-status=live |archive-url=https://web.archive.org/web/20221023115853/https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008/ms187384(v=sql.100)?redirectedfrom=MSDN |archive-date=23 October 2022 |access-date=3 November 2012 |work=[[Microsoft Learn]]}}</ref> [[Oracle Database|Oracle]],<ref>{{cite web |title=SOUNDEX |url=https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm |url-status=live |archive-url=https://web.archive.org/web/20171021113147/https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm |archive-date=21 October 2017 |access-date=20 October 2017 |work=Database SQL Reference}}</ref> [[ClickHouse]],<ref>{{cite web |title=SOUNDEX |url=https://clickhouse.com/docs/en/sql-reference/functions/string-functions#soundex |work=Functions for Working with Strings}}</ref> [https://docs.snowflake.com/en/sql-reference/functions/soundex.html Snowflake]<ref>{{Cite web |title=SOUNDEX — Snowflake Documentation |url=https://docs.snowflake.com/en/sql-reference/functions/soundex.html |access-date=2023-01-16 |website=docs.snowflake.com}}</ref> and [[Adaptive Server Enterprise|SAP ASE]].<ref>{{cite web |date=28 May 2014 |title=soundex |url=http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36271.1600/doc/html/san1393050492054.html |url-status=live |archive-url=https://web.archive.org/web/20221225034830/https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36271.1600/doc/html/san1393050492054.html |archive-date=25 December 2022 |access-date=24 May 2021 |work=SAP Software Solutions}}</ref>) Improvements to Soundex are the basis for many modern phonetic algorithms.<ref>{{cite web |url=http://stevemorse.org/phonetics/bmpm2.htm |title=Phonetic Matching: A Better Soundex |access-date=2012-11-03}}</ref>