• Full text indexing would be an option using the contains clause

    SELECT ..... FROM SomeTable

    WHERE CONTAINS(ColumnName, 'abc or def or ghi ....... ')