Returns the difference between two soundex values.
difference(char_expr1 | uchar_expr1), (char_expr2 | uchar_expr2)
is a character-type column name, variable, or constant expression of char, varchar, nchar or nvarchar type.
is another character-type column name, variable, or constant expression of char, varchar, nchar or nvarchar type.
is a character-type column name, variable, or constant expression of unichar type.
is another character-type column name, variable, or constant expression of unichar type.
select difference("smithers", "smothers")
--------- 4
select difference("smothers", "brothers")
--------- 2
difference, a string function, returns an integer representing the difference between two soundex values.
The difference function compares two strings and evaluates the similarity between them, returning a value from 0 to 4. The best match is 4.
The string values must be composed of a contiguous sequence of valid single- or double-byte roman letters.
If char_expr1, uchar_expr1, or char_expr2, uchar_expr2 is NULL, returns NULL.
If a varchar expression is given as one parameter and a unichar expression is given as the other, the varchar expression is implicitly converted to unichar (with possible truncation).
For general information about string functions, see “String functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute difference.
Functions soundex
