search with misspellings
Posted: Wed Sep 27, 2006 2:43 am
can anyone help to implement the search with misspellins:
There are three instances of people misspelling items. Here is how we should deal with them:
a) One letter anywhere in the word is missing. (in each word, not the whole sentence)
Proper Keyword: "alabama math"
User searches for: "alabam math", "albama math".
In this case a screen will appear where user can click on words "alabama math" he will be taken to the proper search results
Proper Keyword: "french new york"
User searches for: "frnch new york", "frenc new york"
Same logic as "(a)"
b.) There is one or two extra letters. (in each word, not the whole sentence)
Proper keyword: "california guitar"
User searches for: "califroniaa guitar" or "california guittar" of "caalifronia guitarr"
Same logic as "(b)"
c.) One letter word does not match (in each word, not the whole sentence)
Proper keyword: "texas spanish"
User searches for "texis spanish" or "texas spanisj" orf "kexas jpanish"
the table structure is:
tutor_id(primary key)
discipline_option_id(foreing key)
city
state(foreign key)
country(foreign key)
There are three instances of people misspelling items. Here is how we should deal with them:
a) One letter anywhere in the word is missing. (in each word, not the whole sentence)
Proper Keyword: "alabama math"
User searches for: "alabam math", "albama math".
In this case a screen will appear where user can click on words "alabama math" he will be taken to the proper search results
Proper Keyword: "french new york"
User searches for: "frnch new york", "frenc new york"
Same logic as "(a)"
b.) There is one or two extra letters. (in each word, not the whole sentence)
Proper keyword: "california guitar"
User searches for: "califroniaa guitar" or "california guittar" of "caalifronia guitarr"
Same logic as "(b)"
c.) One letter word does not match (in each word, not the whole sentence)
Proper keyword: "texas spanish"
User searches for "texis spanish" or "texas spanisj" orf "kexas jpanish"
the table structure is:
tutor_id(primary key)
discipline_option_id(foreing key)
city
state(foreign key)
country(foreign key)