SQL Server full text search query takes way too long to execute I've got query snippet as follows:

SELECT *
FROM CONTAINSTABLE(dbo.Analysis, *, 'FORMSOF(FREETEXT, "historic year-on-year exchange rates forecast year-on-year exchange rates")');


I'm running it on SQL Server 2014.

However it executes forever, so I just give up and cancel it.


If I remove words year-on-year it works just fine.
FTCatalog was rebuilt - didn't help.


This has been driving me crazy for a while now.
I dont't have a lot of experience with FTS searches, but this just doesn't make any sense.

Please advice how to make it work or where I should start looking at.
In place of your query, try this:

SELECT * FROM dbo.Analysis 
where FREETEXT(dbo.Analysis, 'historic year-on-year exchange rates forecast
yearon-year exchange rates');


or this:

SELECT * FROM  dbo.Analysis 
where CONTAINS(dbo.Analysis, "historic year-on-year exchange rates forecast
year-on-year exchange rates");


Also, the hyphens may be causing problems.  Try:  


  year on year


or 


  yearonyear


in place of the hyphens.

Lastly, did you build and enable a stop list?