• I haven't worked with full text search much, but as I recall it doesn't support that sort of suffix search. It supports a prefix search, like you're already doing, but it cannot easily (or at all?) duplicate a LIKE '%term%' search.

    Here's a CONNECT item that's relevant: https://connect.microsoft.com/SQLServer/feedback/details/758588/full-text-leading-wildcard-suffix-search. For pure suffix searches there are some workarounds with reversing the string and using a prefix search on that, but that doesn't cover all the same situations as a leading wildcard with LIKE.

    My memory's a bit fuzzy on all this since I so rarely work with it, so I could be quite wrong, but based on some quick googling I don't think there's a good full-text alternative for LIKE '%term%'.

    Cheers!