Showing posts with label terms. Show all posts
Showing posts with label terms. Show all posts

Sunday, March 11, 2012

Can terms lookup take into account the US/english spelling differences ?

Is it possible for the terms lookup function to manage the differences between US and english
spelling ? For example if I search for the terms "color" and "categorization", I'd would like that the terms lookup also count the "colour" and "categorisation" occurences in the text.

Thanks
VincentTake a look at the SOUNDEX() function. It does a similar thing by converting a string to a 4 char string/number. You will get lots more hits than expected normally.

I have setup search functions which search for exactly matches and if none are found, use soundex() to find similar matches.|||Thanks ! I'll dig into that