Fuzzy search not finding this text

Mr_English

I have a table of football clubs. In a form, the user can type 2 or more characters to find matching records. The API uses fuzzy search in combination with a search index on the column - screenshots below.

The column is 'ClubName'.

The fuzzy search works fine, except when the text is 'no'.

This works:
.e2.xano.io/api:-/clubsByClubName?search_query="br:*"

This does not work:
e2.xano.io/api:-/clubsByClubName?search_query="no:*"

This does not work:
e2.xano.io/api:-/clubsByClubName?search_query="not:*"

This DOES work:
e2.xano.io/api:-/clubsByClubName?search_query="nott:*"

Screenshot below shows the text does exist.

Data table showing the data I searched for:

The search form showing 'nott' finds the data.

'not' does not find the data

'no' does not find the data

Example to show that a two character search works - 'br'

The index

Pawel Magdanski

Hmm my first though was that "no" and "not" might by some sort of a stop words, but it does not seems that way when I'm checking the docs.

Have you try this kind of search on different table?

Mr_English

Hi @Pawel Magdanski

»Have you try this kind of search on different table?

That's a good question and the answer is yes - on a table called 'places' with column 'placename' having an index. The result is the same.

The data

Form field - 'not' does not find any results. Neither does 'no'.

'nott' returns data:

A different two character search works - 'lo'

Pawel Magdanski

It seems then that these two words itself are problematic for some reason, I was able to replicate this myself.

Mr_English

@Michael Udinski tagging you in on this one.

Michael Udinski

Hi @Mr_English - no and not would be considered Stop words, which are not supported in the search query. (Stop Words -- are commonly used words such as articles, pronouns, and prepositions. For example: is, and, an, or, the. Stop words are not included in your search query.). This is why you aren't seeing the expected results for these words.

Mr_English

Thanks @Michael Udinski