[BUG] Search does not find with absolute title

[neo42JBR]

First Check

• This is not a feature request.
• I added a very descriptive title to this issue (title field is above this).
• I used the GitHub search to find a similar issue and didn't find it.
• I searched the Mealie documentation, with the integrated search.
• I already read the docs and didn't find an answer.
• This issue can be replicated on the demo site (https://demo.mealie.io/).

What is the issue you are experiencing?

When using recipe search with a long title the recipes will not be matched.

I'd expect a 100% match on title to always result in the matching recipe to be the first result.

I was looking for

Vegan Carnitas! Hot Pulled Mushroom Tacos mit Limetten-Mayonnaise und Avocado
and the first result was
Steinpilz-Risotto mit Kürbis

with the search recipe not even appearing on the list

Steps to Reproduce

1. Choose a recipe with a long name
2. Copy the recipe title
3. Use search

Please provide relevant logs

I am not aware of which error logs would be relevant

Mealie Version

v1.12.0

Deployment

Unraid

Additional Deployment Details

No response

[michael-genson]

I can't reproduce this. Which backend are you using, sqlite or postgres? Can you share a few titles that don't work?

[ProjectOrangeJuice]

I have an issue with having - in the search, which looks like it might be the issue here instead of long titles?

For me, the tile is "Chicken katsu with extra-veg sauce" does not work. If i edit the title and remove the - it works fine, extra - veg still does not.

I'm using sqlite

Here looks to be a similar issue #4208

[michael-genson]

This is probably an issue with sqlite, as it doesn't support searching as well as postgres does. While differences in functionality between the two are minimal in Mealie, search is one of the main differences

[neo42JBR]

Yes I was using SQLite because it came packaged with the container. Guess I will just live with it