...
SQL Server treats the hyphen (“-”) as a word breaker.
Example: It doesn’t treat “DCR-08474” as a single string, but rather as two separate words: “DCR” and “08474”.
SQL Server ignores quotes.
SQL Server ignores simple letters and numbers as well as “noise” words like like "the", "an", and “and.”
SQL Server will match matches each search word to the beginning of an indexed word.
Example: Searching for “part” will match “part”, “parts” and “particular”, but will not match “apart” or “apartment”.
SQL Server will only match matches a search phrase with multiple words to an indexed phrase with matching words in the same order uninterrupted.
Example: Searching for “qual manu” will match “quality manual” but not ”quality process manual”.
SQL Server will ignore ignores leading zeroes when matching a number.
Example: Searching for “000847” will match “08474” and “847”.
...