(Here’s the reply I gave to you on Slack.)
Partial word search can be done with the trigram regular expression index.
Full text search searches for words based on stemming and stop words and tries to understand the language enough so that, for example, a search for “runs” returns results for “run” and “running”.