Using the Semantic Search :: SQL Server 2012

You need to analyze some Microsoft Word documents to find the documents that are semantically similar to a document that you get from your manager. You need to provide a quick and simple solution for this problem.
  1. Would you create a Microsoft .NET application or use T-SQL queries for this problem?

  2. If you decide to use a T-SQL solution, which T-SQL function would you use?
  1. A T-SQL solution is simpler in this scenario because the SQL Server Full-Text Search and Semantic Search features support the functionality you need out of the box.

  2. You should use the SEMANTICSIMILARITYTABLE function.