Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the difference in the SOUNDEX values between the two string expressions.
DIFFERENCE ( string-expression-1, string-expression-2 )
The first SOUNDEX argument.
The second SOUNDEX argument.
The DIFFERENCE function compares the SOUNDEX values of two strings and evaluates the similarity between them, returning a
value from 0 through 4, where 4 is the best match.
This function always returns some value. The result is NULL only if one of the arguments are NULL.
The following statement returns similarity between the words test and chest:
SELECT DIFFERENCE( 'test', 'chest' );