FUZZYMATCH

Namespaced Aliases

FM_SIMILARITY

Collision-resistant alias for SIMILARITY.

Syntax

=FM_SIMILARITY(left, right, [method], [case_sensitive])

Parameters

Nameleft
Typetext, number, date, or range
DescriptionFirst value or range to compare.
Nameright
Typetext, number, date, or range
DescriptionSecond value or range to compare.

Returns

The same score or spilled score range as SIMILARITY.

Example

=FM_SIMILARITY("Jilian", "Jillian")

Result: 0.971429

Notes

FM_SIMILARITY accepts the same optional arguments as SIMILARITY.

Use the alias when you want formulas with a family prefix.

    xs