where @searchPhraseis currently an NVARCHAR(1000) and holds the result of a function call that puts together the full search phrase. This all works fine as is but a long search string will increase ...
Looking into an existing full text search that creates a ranked search expression using ISABOUT/WEIGHT etc. using a function that is called and included in a CONTAINSTABLE({table}, {column}, ...