Word Variants

[Benjamin Stookey]

I've been looking all over the web for a way to work the full text search on mysql to get inflectional variations of words.

Say I search for

MATCH (description) AGAINST ('test')

I only get results containing "test", not "testing". I don't particularly want to use

MATCH (description) AGAINST ('test*')

because people may search with words where that wouldn't make sense such as "wind" and "windlass". A windlass doesn't have much to do with the wind.

Is this possible without a whole bunch of operations that could end up slowing the search down?

Thanks,
-Ben