In Power Query there is a fuzzy match option and, as I discovered, a similarity score too, although on mine, it was only available through editing the M-code (at least I couldn't find anything in the user-interface).
Originally the M-code was:
= Table.FuzzyNestedJoin(Table1, {"PDC_DESC"}, Table2, {"LONG_DESCRIPTION"}, "Table2", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true, Threshold=0.6])
and needed editing to:
= Table.FuzzyNestedJoin(Table1, {"PDC_DESC"}, Table2, {"LONG_DESCRIPTION"}, "Table2", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true, Threshold=0.6, SimilarityColumnName="Similarity score"])
and then expanded the new column. (Edit the settings in the user interface and you'll lose your manual additions)
and got:
2021-04-06_203953.jpg
See also:
Fuzzy Matching - Scores
https://social.technet.microsoft.com...atching-scores
(see the last msg on the page)
Table.FuzzyJoin - PowerQuery M | Microsoft Docs
https://docs.microsoft.com/en-us/pow...able-fuzzyjoin
The time it takes may depend on the similarity threshold you choose.