DIFFERENCE

Example

Compares two SOUNDEX values and returns an integer indicating their similarity based on phonetic sounds.

SELECT DIFFERENCE(‘Juice’, ‘Jucy’);

Definition and Usage

The DIFFERENCE() function compares two SOUNDEX values and assigns an integer score from 0 to 4. A score of 0 suggests weak or no similarity, while a score of 4 indicates strong similarity or identical SOUNDEX values.

Tip: Additionally, consider using the SOUNDEX() function.

Syntax

DIFFERENCE(expression, expression)

Parameter Values

Parameter

Description

expression,

expression

Mandatory. Specifies two expressions to be compared. These can be constants, variables, or columns.

Technical Details

Works in:

SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Compares two SOUNDEX values and returns an integer indicating their similarity based on phonetic sounds.

SELECT DIFFERENCE(‘Juice’, ‘Banana’);