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

EMAIL_OPTIMISED Match

Same matching behavior as EMAIL with faster evaluation on large datasets. The production-scale choice for email address matching in Enterprise.

What EMAIL_OPTIMISED does

EMAIL_OPTIMISED produces the same matching results as EMAIL - it splits on @, discards the domain, and scores the local part using the similarity function. It is not an exact/binary comparison; it is FUZZY.

The scoring pattern is exactly the same as EMAIL - only the computation time differs. EMAIL_OPTIMISED is substantially faster when comparing large numbers of email addresses.

What EMAIL_OPTIMISED matches and what it does not

Value A
Value B
Match?

Yes - same as EMAIL, identical local part, domain ignored

Partial - same as EMAIL, local parts differ but share "smith"; scores a graded similarity, not a hard match or non-match

Yes - identical local part, even though the organisations are unrelated

[null]

Yes - same as EMAIL, a null/blank value on either side is an automatic match; add NULL_OR_BLANK if you want nulls excluded

When to use EMAIL_OPTIMISED

Email fields on large datasets

Any use case where you would use EMAIL but your dataset is large enough that performance matters. Customer datasets, patient registries, voter files—any domain where millions of email addresses are being compared.

When not to use EMAIL_OPTIMISED

When the domain is part of the identity signal, or should factor into the score

EMAIL_OPTIMISED carries the same domain-blind scoring as EMAIL - "[email protected]" and "[email protected]" still score as an identical-local-part match even though the organisations are unrelated. If you are matching organisations rather than individuals, or the domain should count towards the score rather than be ignored, use EXACT (full email must match) or FUZZY_OPTIMISED (fuzzy-matches the whole string, domain included) instead.

EMAIL_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?