# CompareFuzzy

{% hint style="info" %}
The **`CompareFuzzy()`** function compares two <mark style="color:blue;">texts</mark> 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](https://docs.wem.io/platform/~/changes/y5gAfiyi2fILzrLzUUHj/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
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 <mark style="color:red;">**`Invalid expression`**</mark>if one of the parameter values is unknown.
{% endhint %}

### Syntax

<details>

<summary><code>CompareFuzzy(</code><mark style="color:blue;"><code>text1</code></mark><code>, </code><mark style="color:blue;"><code>text2</code></mark><code>)</code></summary>

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

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

</details>

### Parameters

<table><thead><tr><th width="150">Name</th><th width="150">Type</th><th width="150" align="center">Required</th><th width="248.15953250810662">Description</th><th data-hidden>Required?</th></tr></thead><tbody><tr><td><mark style="color:blue;"><code>text1</code></mark></td><td>text</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>the first text to compare.</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>text2</code></mark></td><td>text</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>the second text to compare.</td><td>yes</td></tr></tbody></table>