Query for search keyword with similar results

mikawhat

I'd like to create a query which will return all entries containing a specific word, and some others which containing a percentage (e.g. 80%) of the characters.
For example:
Searching for 'ever' should return 'ever', 'whatever', 'never', 'fever' (this could be easily done with LIKE '%ever%'), but also some other words like 'even' (75% matched), 'over' etc...
How's that possible?

dagon

you would have to create a db or related words so when some searched for "ever" you would look that up and see it matches "over" and search for over also.

sounds painful

mikawhat

I found a function called levenshtein().... haven't tested it yet but it may be useful...
I'd like to do something like what you see in search engines... when you search for 'whatover' (with the typo)...it will return no results and also... 'did you mean whatever?'...

MattG

mikawhat;10922112 wrote:
I found a function called levenshtein().... haven't tested it yet but it may be useful...
I'd like to do something like what you see in search engines... when you search for 'whatover' (with the typo)...it will return no results and also... 'did you mean whatever?'...

This article may help with that...
http://css.dzone.com/news/google-style-did-you-mean-php

dagon

mikawhat;10922112 wrote:
I found a function called levenshtein().... haven't tested it yet but it may be useful...
I'd like to do something like what you see in search engines... when you search for 'whatover' (with the typo)...it will return no results and also... 'did you mean whatever?'...

thats different from ever -- over

you can add spell checking with pspell

mikawhat

OK here's my scenario. I'm getting two xmls, one with football matches(as events) and one with results(final scores). Most teams in two xmls are coming with different names (e.g. xml1 sends 'Liverpool', and xml2 sends 'Liverpool FC'). There's no common id so the only way matching the event with a result is by team names. What i want to achieve, is to suggest Liverpool as a possible matching for liverpool FC. levenshtein could do that?

dagon

that's a third version of this question, i give up.