Query.search() limitation

I created a fulltext index for my attribute containing list of anime titles. Lets say I want to search for "Attack on Titan" .. how can i achieve this without having to type from the start. Like is there a way to perform contains() search for specific words such as titan?

TL;DR

The user is experiencing a limitation with the Query.search() function in Appwrite. They confirmed that it is an Appwrite limitation and not a problem on their side. They are discussing different approaches to handle partial matches in full text search (FTS). One suggestion is to tokenize the search query by words, while another approach is to create a list of tokens for each anime title. The user is seeking guidance on the best approach to search for specific words like "titan" without having to type the entire search query from the start. Solution: It is suggested to tokenize the search query by words and create a list of tokens for each anime

Another approach i was thinking of was to create a list of all the tokens separated by space

like 'Attack on Titan' can be 'attack', 'on', 'titan'

but is this even a good approach?

plus i have a list of titles so considering each item in list getting further divided might be bad for performance?

😲 Didn't even realise FTS index does not work for partial matches. I think tokenizing by words is your best bet. Maybe a collection of tokens related to the anime data collection