SQL Server Transact Basic to Expert - Using String Function Check Similarity of string
This blog shows how to check the similarity level of a string compared with the other strings in an expression using SQL
Example:
SELECT SOUNDEX('Pleas'), SOUNDEX('Pleece')
The expected result would be
F420 F420