Hello, Does anyone have ideas for semi-efficient similar text matching in SQL queries in mysql that account for human error?
e.g. I may have a record in my database that has the word 'color' in it. Well, someone types in 'colour'....so I make a query like "select * from table where keywords like '%colour%' would get no results....but I want it to. I'm thinking along these lines...having a "dictionary/thesaurus database" of standardized-spelled words that are similar to those words with popular mis-spellings, alternate spellings, and synonyms. When a query is made via a human, the keywords in the query are compared against the large "dictionary" database, and then the query is supplemented or altered to get the best match. Or am I working too hard? This can't be the first time someone has wanted to do this with MySQL, yet I don't readily find this idea using search engines. I also want to consider ways to limit the time of the query, the extent of the query (number of branches) so I don't take an incredible performance hit on the queries because of this dynamic query re-writing. ideas? comments? Thanks Dan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php