title: Is full text search suitable for searching people's names?
body: <p>I have a user table with a single column for a person's name:</p>
  
  <pre><code>CREATE TABLE [dbo].[Users]
  (
      Id bigint NOT NULL,
      Name nvarchar(80) NOT NULL,
      PRIMARY KEY CLUSTERED (Id ASC)
  )
  </code></pre>
  
  <p>The <code>Name</code> column can contain either a full name or just the first name or anything really (separated by spaces). In order to implement a search on <code>Name</code>, I would like to utilize SQL's full-text search, but not sure if it's suitable for searching names/nicknames and not actual words. Also the question is - which language do I choose when creating the FT index on <code>Name</code>?</p>
  
  <p>Any other considerations?</p>
  
  <p>Thank you.</p>