SOUNDEX('Knight') : SOUNDEX « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. SOUNDEX
5> SELECT
6> "SX_KNIGHT"=SOUNDEX('Knight'),
7> "SX_NITE"=SOUNDEX('Nite'),
8> "DIFFERENCE"=DIFFERENCE('Nite', 'Knight')
9> GO
SX_KNIGHT SX_NITE DIFFERENCE
--------- ------- -----------
K523      N300              1

(1 rows affected)
1>








12.18.SOUNDEX
12.18.1.SOUNDEX checks how similarly sounding two tested strings can be.
12.18.2.Sound difference
12.18.3.SOUNDEX('Knight')
12.18.4.Determining the Similarity of Strings