Example
SELECT DIFFERENCE('Juice', 'Jucy');Definition and Usage
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.
Tip
Also look at the SOUNDEX() function.
Syntax
DIFFERENCE(
expression, expression
)Parameter Values
| Parameter | Description |
|---|---|
| expression, expression | Required. Two expressions to be compared. Can be a constant, variable, or column |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|