FTS: Searching across multiple fields 'intelligently'

Question

Hi,

I have a SP using FTS (Full Text Search). I want searches across multiple fields, 'intelligently' ranking results based on the weights I assign.

Consider a search on a view fetching data from tables: Book, Author and Genre.

Now, I want the searcher to be able to do: "Ludlum Fiction", "Robert Ludlum Bourne", "Bourne Ludlum", etc.

Unfortunately, the only way I have been able to do that at present is this: http://pastebin.com/fdce11ff

This is pretty bad, because I am manually breaking up the search string. I know I am doing this completely the wrong way, but can't figure out the right way to search across multiple fields in FTS. Can somebody help please?

Answer 1

On your instance; how is your dictionary setup? You might want to add your authors to your dictionary which will likely solve the al pacino issue (also make sure your authors arent noise words.)

You might get better results from the deep search using a vector type search. We have pushed our users (which are internal staff) the other way toward boolean searches as google would ask for. Robert Ludlum and bourne for example.