Interesting - using Freetexttable and NEAR

Hilary, results do change when I use NEAR between words with Freetexttable.
In fact the returned set when I limit it to top 10 is quite different. I
think I can read into your statement below and sort of understand why the
difference. I need to take more time to look at my results and then check
them against the source data.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:Op2bxxboEHA.1576@.TK2MSFTNGP12.phx.gbl...
> Nearness is reflected in rank. The closer together two words are the
higher
> the rank everything else being equal.
> Nearness is calculated on a per column basis, it cannot look across
columns.
> FreeText factors nearness into rank (everything else being equal) and can
> look across columns. FreeText ignores the near operator however, as it is
> calcuated in the rank.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Bill D" <delaneWC-nospam@.mail.slh.wisc.edu> wrote in message
> news:e2kX0QboEHA.3488@.TK2MSFTNGP12.phx.gbl...
> and
> they
>
I'm sure they do change because now you are searching on the word near and
getting all the stems of the original search term!
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Bill D" <delaneWC-nospam@.mail.slh.wisc.edu> wrote in message
news:%23EWGIzkoEHA.3564@.tk2msftngp13.phx.gbl...
> Hilary, results do change when I use NEAR between words with
Freetexttable.[vbcol=seagreen]
> In fact the returned set when I limit it to top 10 is quite different. I
> think I can read into your statement below and sort of understand why the
> difference. I need to take more time to look at my results and then check
> them against the source data.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:Op2bxxboEHA.1576@.TK2MSFTNGP12.phx.gbl...
> higher
> columns.
can[vbcol=seagreen]
is[vbcol=seagreen]
black'[vbcol=seagreen]
if
>