Returns an integer (
int) value that indicates the difference between the soundex values of two character expressions.
Both parameters are alphanumeric expressions of character data.
The integer returned is the number of chars in the soundex values of the parameters that are the same, so 4 means that the expressions are very similar and 0 means that they are very different.
SELECT SOUNDEX('Green'), -- G650 SOUNDEX('Greene'), -- G650 DIFFERENCE('Green','Greene') -- Returns 4 SELECT SOUNDEX('Blotchet-Halls'), -- B432 SOUNDEX('Greene'), -- G650 DIFFERENCE('Blotchet-Halls', 'Greene') -- Returns 0