Doing partial match on name fields in SQL Server

full-text-search, sql-server-2008

Solution

humm three options that mya help you:

- the INFLECTIONAL form (Link)

- CONTAINS with NEAR (Link)

- CONTAINS with Weighted Values (Link)

If that doesn't help, get the string 'fe ha' and add a '%' on every blank space and do a Like:

Like '%fe%ha%'

Problem

I need to enable partial matching on name search. Currently it works with `Like '%@name%'` but it's not good enough. We need to enable typing in both first name and last name and both need to be partial, so I'm assuming full text is the way to go. The problem is that I can't get it do a partial match on a name. For example searching for my name (Fedor Hajdu) will work if I type in either parts in full but not partial (It should match a search for `'fe ha'` for example. How can I achieve this? Can fulltext index be set to do something like syllable matching?

Original source