DIFFERENCE function in SQL Server

The DIFFERENCE() function returns an integer after comparing two SOUNDEX values. The integer number, ranging from 0 to 4, indicates the match between the two SOUNDEX values.

0 means that the SOUNDEX values have little or no similarity. 4 implies that the SOUNDEX values are very comparable or same.

Examples:
SELECT DIFFERENCE(‘Not’, ‘Knot’);
Returns- 2

SELECT DIFFERENCE(‘Will’, ‘Bill’);
Returns- 3

SELECT DIFFERENCE(‘Sea’, ‘See’);
Returns- 4

SELECT DIFFERENCE(‘Warn’, ‘Worn’);
Returns- 4

Hope you find this article helpful.

Please subscribe for more interesting updates.