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
| Difference |
|---|
| 4 |
Note: A 4 indicates that the words sound similar or identical.
Syntax of the DIFFERENCE function.
DIFFERENCE(string1, string2)
SELECT DIFFERENCE('Query', 'Language') AS Difference
| Difference |
|---|
| 0 |
