I'm using CONTAINS to search for a string or word. If I search for Hobby is it possible to make it search for Hobbies also, which is the plural of Hobby? FREETEXT seems to be doing this but I want to do it with CONTAINS because it will make me search with an AND clause. FREETEXT using OR clause which I don't need.
For example if I do below search for 'John AND Hobby', I would like to get strings that have both John and Hobby / Hobbies
WHERE contains (*, 'John AND Hobby' )