CompareFuzzy

The CompareFuzzy() function compares two texts and returns a number between 0 and 1 (inclusive) that indicates the similarity between the two texts. 0 being totally different (0% match) and 1 being exactly the same (100% match).

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number that indicates the similarity of text1 and text2, where a number close to 1 means very similar and a number close to 0 means very different. Returns Invalid expressionif one of the parameter values is unknown.

Syntax

CompareFuzzy(text1, text2)

CompareFuzzy("are you good?", "are you god?") => 0.9166666667

CompareFuzzy("Geneva", "Genèva") => 1

Parameters

Name	Type	Required	Description
text1	text	☑️	the first text to compare.
text2	text	☑️	the second text to compare.