How to find, with a full text search, all words that match the mask “ability”, for example, “suitability” and “reliability”, etc.? perhaps?
It is impossible out of the box. Apparently wildcards don't work. See here for a discussion.
I had this problem and there was nothing good around it except the chain OR WHERE x LIKE "% term%" searches in each individual field.