Fulltext search returning non-exact matches

Hello!

We are seeing an issue with fulltext search, where results that don't exactly match the search term are being returned.

I have read on these forums that the fulltext search is not in any way fuzzy, so this seems v strange.

Examples:

For context, this search queries fulltext matches in project title only, and then performs another search to query fulltext in the entire project document.

This is not great behaviour for us because it means the result with an exact match is not the first in the list...

If we're doing something wrong here, or there are other options that we can use to only match exact terms, please let me know!

Thank you,
Jarod

This is one of the limitations of the FullText search. For advanced use cases, we recommend using Algolia