A full text search always starts with a Contains in FTS operator, but that still leaves open a variety of options for forming a query for the full text search engine. These options include a number of full text query operators, connectors and modifiers that vary depending on whether or not the boolean option is checked or not or the search type is “Raw query”.
Contains in DB works with the database and not the full text search index. The options for this operator are different than for Contains in FTS.
