SOUNDEX checks how similarly sounding two tested strings can be. : SOUNDEX « String Functions « SQL Server / T-SQL Tutorial






3> SELECT SOUNDEX("Robin Dewson"), SOUNDEX("Robyn Jewshoon")
4> GO

----- -----
R215  R210

(1 rows affected)








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