ONLY_ALPHABETS_FUZZY_OPTIMISED Match
Same matching behavior as ONLY_ALPHABETS_FUZZY with optimised processing for production-scale address matching. Enterprise only.
What ONLY_ALPHABETS_FUZZY_OPTIMISED does
ONLY_ALPHABETS_FUZZY_OPTIMISED produces the same matching results as ONLY_ALPHABETS_FUZZY - strips numbers, then applies fuzzy matching to the alphabetic portion.
The scoring pattern is exactly the same as ONLY_ALPHABETS_FUZZY - only the computation time differs. ONLY_ALPHABETS_FUZZY_OPTIMISED runs faster on large datasets.
What ONLY_ALPHABETS_FUZZY_OPTIMISED matches and what it does not
42 Main Street
44 Main Street
Yes - same as ONLY_ALPHABETS_FUZZY, numbers stripped, "Main Street" is identical
42 Main St
44 Main Street
Yes - same as ONLY_ALPHABETS_FUZZY, "Main St" vs "Main Street" scores a high fuzzy similarity
42 Main St
42 Oak St
No - same as ONLY_ALPHABETS_FUZZY, "Main St" vs "Oak St" too different alphabetically
[null]
Main Street
Yes - same as ONLY_ALPHABETS_FUZZY, a null/blank value on either side is an automatic match; add NULL_OR_BLANK if you want nulls excluded
When to use ONLY_ALPHABETS_FUZZY_OPTIMISED
When not to use ONLY_ALPHABETS_FUZZY_OPTIMISED
Last updated
Was this helpful?