DIFFERENCE returns the SOUNDEX difference between two strings.
SOUNDEX refers to how a string sounds when spoken in English.
The returned values range from 0 (no similarity) to 4 (identical sounding).
This example returns the SOUNDEX difference between two words.
SELECT DIFFERENCE('Read', 'Red') AS Difference
Note: A 4 indicates that the words sound similar or identical.
Syntax of the DIFFERENCE function.
SELECT DIFFERENCE('Query', 'Language') AS Difference