Best way to get text similar to the given context

An example would be a search function on a website. Though, this is quite similar and I'm using Sqlite. So should I just use the sql claus开发者_如何学运维e "LIKE" or is there a better way to do this? (well, not mainly performance wise but returns better search results)

---

You might search for fuzzy mathing algorithms, notably Soundex and Levenshtein.

A notable Java library for this is Lucene.