Abhiman Tiwari promotes a feature:
MICROSFTisn’tMICROSOFT.MARHTAisn’tMARTHA.INV-1O08isn’tINV-1008. To an equality check, each pair is simply different. To your business, each is a near miss worth catching.Today, fuzzy string matching is generally available in Microsoft SQL.
EDIT_DISTANCEtells youMICROSFTis one edit fromMICROSOFT.JARO_WINKLER_SIMILARITYscoresMARTHAandMARHTAat 96 out of 100. It all runs in T-SQL, right where your data lives, with no external libraries, models, or custom code.
As of CU11, this is now GA in SQL Server 2025.