Reports

NEW!!!

This article is from Februarly 2025, and apparently there's an option to do so, and I was quite pleased with the results! Please note, this is so new that SSMS puts a squigly red line under the commands. I'm using Azure Sql databases, so I have all the newest features.

The article: https://learn.microsoft.com/en-us/sql/relational-databases/fuzzy-string-match/overview?view=azuresqldb-current

The commands are: <CODE> EDIT_DISTANCE, EDIT_DISTANCE_SIMILARITY</CODE>

And

<CODE>

JARO_WINKLER_DISTANCE

JARO_WINKLER_SIMILARITY

</CODE>

Example: works like a charm BTW:

SELECT *, 
  EDIT_DISTANCE (AC.[Sold To Party Name], CC.[Name 1]) AS ED_DISTNACE
  , JARO_WINKLER_DISTANCE (AC.[Sold To Party Name], CC.[Name 1]) AS JW_DISTANCE
  , EDIT_DISTANCE_SIMILARITY (AC.[Sold To Party Name], CC.[Name 1]) AS ED_SIMILARITY
  FROM dbo.[CustomerSource1]  AC INNER JOIN dbo.CustomerSource2 CC 
    ON AC.[Address Of Customer] = CC.[Street name] AND AC.[Post Code Of Customer] = CC.[Postal code]

79537726