Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7

[kellygreer1]

Hello group,

Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?

I'm using SQL Server 7 SP3.

Thanks,
Kelly Greer
Ke*********@nospam.com
replace nospam with yahoo

[Hilary Cotter]

Its hardcoded. I believe after 50 words the rank drops off to 0. I also
believe that after 1366 (or some large number of words like that) you will
no longer get a hit.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"kellygreer1" <ke*********@yahoo.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

Hello group,

Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?

I'm using SQL Server 7 SP3.

Thanks,
Kelly Greer
Ke*********@nospam.com
replace nospam with yahoo

[John Kane]

Kelly,
Q. Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR?
A. Within 50 non-noise words. Additionally, end-of-sentence and
end-of-paragraph also have an effect on the "nearness" of one word or phrase
to another word or phrase.

Q. Is this setting adjustable?
A. No. This is hard-coded.

Q. Is it stored in the registry? INI or config file?
A. No and No. Although, I would hope in some future SQL Server version
(post-SQL Server 2005) that this would be possible, IMHO.

Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

"kellygreer1" <ke*********@yahoo.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

Hello group,

Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?

I'm using SQL Server 7 SP3.

Thanks,
Kelly Greer
Ke*********@nospam.com
replace nospam with yahoo