How to find common sounding words in database?

Question

How to find common sounding words in database?

@nks

Mr or Mrs. 500

Points: 500
More actions
November 15, 2008 at 2:49 am

#201438

hi,
I want to find common sounding similarity words in database.
ex. I want to find "Limited" word in database.
the following words are allready present in database-
Ltd., Limited, Leemited, Limeeted, Limitted ect
SO, These words are common sounding like Limited.
When i execute the querry i want all these words.
So how can I find it without using " like " ?
Thanks & Regards.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

May I suggest that you read the topics in Books On Line (BOL) titled Full-Text Search... be prepared there is a lot to read, but you should be able to answer your question. In addition search SQL ServerCentral for example here is a good starting article:

http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Bevan Keighley SSCommitted Points: 1825 More actions · Answer 2

Hi,

I would suggest using functions like soundex and difference.

Here is an example:

create table #temporaryNames ( names varchar(128) null)

insert #temporaryNames

select 'Ltd.'

union select 'Limited'

union select 'Leemited'

union select 'Limeeted'

union select 'Limitted'

union select 'Lighthouse'

union select 'Lift'

union select 'Likelihood'

select names from #temporaryNames where difference(names, 'limited')=4

In this example, 4 is the lowest possible difference. You could lower the threshold (E.g. >=3) if required.

B

patriwala Old Hand Points: 303 More actions · Answer 3

hi,

use the full-text functionality of the sqlserver 2005. check this link

http://amitpatriwala.wordpress.com/2008/08/11/fulltext-search-in-sqlserver-2005/[/url]

might be useful to you.

thnx

Carlton Leach SSCarpal Tunnel Points: 4202 More actions · Answer 4

Full text is probably the way to go, but a soundex (in-built function) my be of some use to you.

Carlton..

Andrew..Peterson SSCertifiable Points: 6838 More actions · Answer 5

agree, take a look at soundex and full text search. Both have some value and may match your needs.

The more you are prepared, the less you need it.