Example
Evaluate the similarity of two strings, and return a four-character code:
SELECT SOUNDEX('Juice'), SOUNDEX('Jucy');
Definition and Usage
The SOUNDEX() function returns a four-character code to evaluate the similarity of two expressions.
Note: The SOUNDEX() converts the string to a four-character code based on how the string sounds when spoken.
Tip: Also look at the DIFFERENCE() function.
Syntax
SOUNDEX(expression)