This should give you an idea

SELECT TicketID

FROM Ticket

WHERE CONTAINS(Description,'Hello World')

I fixed a performance issue I had with description. It was text and had a regular NCI on it. That attribute is used by a ticketing system and the values are very long inputs made by users. Once I deployed a FT on that column and eliminated the previous NCI, the logical reads went down from 3k to about 6 reads average.