Is there an proven solution for finding out words that are similar (related?) to the original search-term of a database?
Lets say I search for %deaht%; is there a way of getting the similar word (Death) to be listed? I don't think SOUNDEX will give reliable results specially since the search will be based on another language than English.
Svante
Intelligent search function (MySQL+PHP)
Moderator: General Moderators
Re: Intelligent search function (MySQL+PHP)
Hmm....I don't know about soundex - never used it myself.
However, you could do something similiar to google with the "Did you mean....." with the pspell library and functions.
However, you could do something similiar to google with the "Did you mean....." with the pspell library and functions.
Re: Intelligent search function (MySQL+PHP)
We had a related discussion here:
viewtopic.php?f=2&t=102560
viewtopic.php?f=2&t=102560
There are 10 types of people in this world, those who understand binary and those who don't
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Re: Intelligent search function (MySQL+PHP)
Also, I suspect that Google saves all words that the users type and, if a word is misspelled often, it automatically uses the presumed correct spelling in the search. Google also determines what word you meant to type by context as well, which I assume is also by looking at common mistakes in searches and the corrections that the users give in a subsequent search.
Basically, Google is complex.
/rant
Basically, Google is complex.
/rant
Re: Intelligent search function (MySQL+PHP)
I said like google. To be google is impossible. Their coders are like....genii 
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Re: Intelligent search function (MySQL+PHP)
Ironically, it took me a second to realize what you said.jackpf wrote:genii
/stupidity
Re: Intelligent search function (MySQL+PHP)
Sounds like a Bayesian networksuperdezign wrote:Also, I suspect that Google saves all words that the users type and, if a word is misspelled often, it automatically uses the presumed correct spelling in the search. Google also determines what word you meant to type by context as well, which I assume is also by looking at common mistakes in searches and the corrections that the users give in a subsequent search.
Basically, Google is complex.
/rant