Fulltext searches, synonyms, and alternate spellings... I was wondering if there was any way to somehow modify a fulltext
search to be able to match on full synonyms and (perhaps more
importantly) alternative spellings.
For instance,
INSERT
INTO some_table (words_text)
VALUES ('He parked the automobile with its tyres against the kerb.')
SELECT *
FROM some_table
WHERE MATCH (words_text)
AGAINST ('car tires curb')
....won't match at all, when any English-speaking human can see it
should.
Hoping for any recommendations on how to deal with this,
--
Dodger |