Edit

Share via

JARO_WINKLER_DISTANCE (Transact-SQL)

  • Article

Applies to: Azure SQL Database SQL database in Microsoft Fabric

Note

As a preview feature, the technology presented in this article is subject to Supplemental Terms of Use for Microsoft Azure Previews.

Calculates the edit distance between two strings giving preference to strings that match from the beginning for a set prefix length.

JARO_WINKLER_DISTANCE (
    character_expression,
    character_expression
) 

Arguments

character_expression

An alphanumeric expression of character data. character_expression can be a constant, variable, or column. The character expression cannot be of type varchar(max) or nvarchar(max).

Return value

real

Remarks

This function implements the Jaro-Winkler edit distance algorithm.

Example

The following example compares two words and returns the JARO_WINKLER_DISTANCE value as a column, named Distance.

SELECT 'Colour' AS WordUK, 
       'Color' AS WordUS, 
       JARO_WINKLER_DISTANCE('Colour', 'Color') AS Distance;

Returns:

WordUK WordUS Distance
------ ------ -------------
Colour Color  0.03333336

For additional examples, see Example JARO_WINKLER_DISTANCE.

Related content