full-text-catalog

Can a Sql Server Full Text Catalog find the following?

Hi folks, i have the following data in a field, which is being indexed by a Full Text Catalog. Pamorama City, Los Angeles, California, United States Simple. (I also have lots of others, but they are working fine). Now, if the user provides this incorrect, mispelt search word pamorma city <-- notice the middle 'a' is missi...

Guidelines for creating additional full-text catalogs

The nice wizards says If this is a large table or view, or if the chosen full-text catalog has indexed or other large tables, consider assigning this table or view its own full-text catalog "Large" is a pretty subjective term, is it 1000 records or 1,000,000 in a table? What guidelines do you follow when creating additional full-t...