looking for word parts with full text search in sql server

Question

how do I find, with full text search all words that match 'ability' mask, like "suitability" and "dependability", etc? is that possible?

Here is how to do it: http://stackoverflow.com/questions/2962776/using-full-text-search-in-order-to-find-partial-words-sql-server-2008 — diegol, Dec 06 '12 at 12:10
Here's the answer: http://stackoverflow.com/questions/2962776/using-full-text-search-in-order-to-find-partial-words-sql-server-2008 — diegol, Dec 07 '12 at 09:31

score 2 · Accepted Answer · edited May 23 '17 at 12:26

2

It's not possible out of the box. Apparently wildcards do not work. See here for discussion.

edited May 23 '17 at 12:26

Community

answered May 09 '10 at 23:28

mdma

score 0 · Answer 2 · answered May 09 '10 at 23:43

0

I've had that problem, and there didn't seem any nice way round it but to also chain OR WHERE x LIKE "%term%" searches in each individual field.

answered May 09 '10 at 23:43

user97410

2 Answers2