When you issue CONTAINS statement, is it possible to get the result set without a text index on the column you specified?

How about rebuilding the indexes?