"Similar to" searches

[email protected] ("Ron Piggott")
Newsgroups php.db
Message-ID <db12fa6a86af5b00448e64c90f21067f.squirrel@www.theverseoftheday.info>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.