DIFFERENCE

SQL Server

Example

SELECT DIFFERENCE('test', 'tost')

Output

2

Explanation

The DIFFERENCE function returns an integer that represents the difference between the SOUNDEX values of two strings. In the example, the difference between ‘test’ and ‘tost’ is 2, indicating a moderate match according to the SOUNDEX system. This function is useful for comparing the similarity of words based on their phonetic sounds.