The keyword search on our company's web site is abysmal. We have a Cold Fusion front end with SQL Server. I've investigated using the Full Text Search capability and have even created a POC.

My question is whether anyone has information regarding the use of this tool to drive web site keyword searches. Additionally, if anyone is aware of any 3rd party software which adds additional intelligence or capabilities on top of the built-in functionality, I would like to know that as well.

Thanks in advance!