Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.
Enterprise only

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

Value A
Value B
Match?

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

Address, catalog, or brand fields at production scale

Any field where you would use ONLY_ALPHABETS_FUZZY - street addresses, product catalogs, store/branch names - once your dataset is large enough that performance matters.

When not to use ONLY_ALPHABETS_FUZZY_OPTIMISED

When the number is what makes the records different

ONLY_ALPHABETS_FUZZY_OPTIMISED carries the same blind spot as ONLY_ALPHABETS_FUZZY: identifiers (patent, invoice, flight numbers) and safety- or spec-critical values (dosage, material grade, size) all lose the one value that distinguishes them once the numbers are stripped. Use EXACT or ONLY_ALPHABETS_EXACT instead.

ONLY_ALPHABETS_FUZZY_OPTIMISED is Enterprise only. The Community (open source) edition does not support this match type. Available in Enterprise Lite and above.

Last updated

Was this helpful?