Fuzzy match in Powerquery, does it check for an exact match first?

[jac76248]

I want to create a merge between 2 tables, I want to use fuzzy match wherever exact match is not possible.
Do I have to do this in 2 different steps? or does the fuzzy match itself, check for an exact match before making it fuzzy?

[AliGW]

It uses a similarity threshold: https://support.microsoft.com/en-us/...4-bd3962b90649

If it's looking for similarity, then assuming you haven't given it too broad a brush with too low a setting, it will find exact matches fine. What's the purpose for it?

[jac76248]

Hi, Thank you for your answer

My Use case is:
I want to do a normal match first. and use fuzzy match only in cases where I do not have an exact match.

So, can this be accomplished by doing the fuzzy match directly?
(Does fuzzy match select the match with the highest similarity index first? or the first one which is above the threshold?)

Or should I first do an exact match and then a fuzzy match and then merge these 2 results