Loading lesson path
Concept visual
Start at both ends
Compares two SOUNDEX values, and return an integer:
SELECT DIFFERENCE('Juice', 'Jucy');The DIFFERENCE() function compares two SOUNDEX values, and returns an integer. The integer value indicates the match for the two SOUNDEX values, from 0 to 4. 0 indicates weak or no similarity between the SOUNDEX values. 4 indicates strong similarity or identically SOUNDEX values.
Also look at the SOUNDEX() function.
expression, expression )
Description expression, expression Required. Two expressions to be compared. Can be a constant, variable, or column
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Compares two SOUNDEX values, and return an integer:
SELECT DIFFERENCE('Juice', 'Banana');❮ SQL Server Functions