I am using Fuzzy Lookup to find similar records, I am comparing two tables (150K vs 350K). Since it's very time consuming (almost whole day) on normal mode, I decided to enable advanced features in Global Settings.
-I set "UseApproximateIndexing=True", this method is very fast but I am getting wrong score, everything over 100% (It must be between 0-100$). I get 450%, 5005 ,700% etc. I am not sure if this is a bug or what is the problem, it's Microsoft's Fuzzy Lookup, so it a robust tool in theory. I am using Office 365
Could you test and tell me why am I getting score over 100%? I am attaching the file and example for clarification.
2023-12-23_01h10_27.png
FuzzyLookup2.xlsx
Bookmarks