I have implemented full text search in SQL Server 2014. I need partial match implementation in full text search in SQL Server 2014.
When I type 'erik grant', the results are given below
When I type 'ran', I am expecting all the names containing 'ran' as partial match. Especially all the names with last name 'grant' should be returned in the query result. But the result is empty. Partial match is not working. I am expecting LIKE '%ran%' behaviour.
Need your suggestions and guidance in partial match implementation in FULLTEXT SEARCH.
Thanks