DIFFERENCE() Function in SQL Server
Last Updated :
13 Oct, 2020
The DIFFERENCE() function compares two different SOUNDEX values, and return the value of the integer. This value measures the degree that the SOUNDEX values match, on a scale of 0 to 4. A value of 0 indicates a weak or no similarity between the SOUNDEX values; 4 indicates that the SOUNDEX values are extremely similar, or even identical.
Syntax :
DIFFERENCE(string, string)
Parameter : This method accepts two-parameters as mentioned above and described below –
- string, string –
It is an alphanumeric expression of character data. It can be a constant, variable, or column.
Returns : It returns an integer value measuring the difference between the SOUNDEX() values of two different string.
Example-1 :
Using DIFFERENCE() function with similar SOUNDEX() values.
SELECT SOUNDEX('poor') soundex_poor, SOUNDEX('pour') soundex_pour,
DIFFERENCE('poor', 'pour') similarity;
Output :
soundex_poor |
soundex_pour |
similarity |
P600 |
P600 |
4 |
Example-2 :
Returns a DIFFERENCE value of 3, the less possible difference.
SELECT SOUNDEX('GeeksForGeeks'), SOUNDEX('GeeksOfGeeks'),
DIFFERENCE('GeeksForGeeks', 'GeeksOfGeeks');
Output :
3
Example-3 :
Returns a DIFFERENCE value of 2, the medium possible difference.
SELECT SOUNDEX('GeeksForGeeks') soundex_GeeksForGeeks, SOUNDEX('GFG') soundex_GFG,
DIFFERENCE('GeeksForGeeks', 'GFG') similarity;
Output :
soundex_GeeksForGeeks |
soundex_GFG |
similarity |
G216 |
G120 |
2 |
Example-4 :
Returns a DIFFERENCE value of 0, the highest possible difference.
SELECT SOUNDEX('javascript') soundex_javascript, SOUNDEX('c#') soundex_c#,
DIFFERENCE('javascript', 'c#') similarity;
Output :
soundex_javascript |
soundex_c# |
similarity |
J126 |
C000 |
0 |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...