HOW does Table.FuzzyNestedJoin work?

[ryan-gao]

I use "tm" match "tqm" ,which I think the score should be 0.666 (two hits ,one miss)   but it still matches even if the score is 0.8  why?

[Anonymous]

Its pretty new but based on other fuzzy logic systems, the score is generally more nuanced than just hits and misses.  I think there is also some weighting on distance.  TM and TQM are so close that i'm not surprised its been picked up.  In the demo it even matched Bill with William, so there must be some heuristics involved.

[ryan-gao]

You made a really good point. thanks Ross