"Similar to" searches

I am wondering if there is a way to or how you would have mySQL query for
similar words in comparison to what the user provided.

I have a table which contains only single words. It has two columns:

- `reference` int(10) NOT NULL AUTO_INCREMENT,
- `word` varchar(100)

I am wondering if there is a way to cross reference the word the user has
provided to similar words in the database (So I could offer "SEE ALSO:"
links).

An example: If the word the user has provided is: Forced
I would like the mySQL query results to find the words: Forcing, Force and
Forces to be the results of the query in the words database.

Is there any way of achieving this?

Ron

The Verse of the Day
Encouragement from God's Word
www.TheVerseOfTheDay.info


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php