Determining the Similarity of Strings : SOUNDEX « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. SOUNDEX
3>
4> SELECT SOUNDEX('Fleas'),
5> SOUNDEX('Fleece'),
6> SOUNDEX('Peace'),
7> SOUNDEX('Peas')
8> GO

----- ----- ----- -----
F100  F120  P200  P000

(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