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 expression
if one of the parameter values is unknown.
Syntax
Parameters
Name | Type | Required | Description |
---|---|---|---|
| text | the first text to compare. | |
| text | the second text to compare. |
Last updated