Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “coolies” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
coolies9382496(None) 
colies84837051c_olies
collies94326581collies
cookies133719271cookies
coolie83821601coolie_
cooties93725731cooties
doolies83920711doolies
woolies104117361woolies
boobies113718202boobies
boodies103721442boodies
boogies103719012boogies
bookies133819402bookies
boonies93422482boonies
booties94124612booties
chilies124218302chilies
cholines132214482cholines
coalier93416172coalier
coaliest10316222coaliest
cobles104622882cobl_es
codlins104116242codlins
coles76055062c_ol_es
colics104219902c_olics
colins85229042c_olins
collides113214462collides
collie83621992collie_
collied103316672collied
collier93618152collier
colliers103613582colliers
collins93419832collins
colones96124432colones
colonies103620012colonies
commies133718442commies
complies14314522complies
conies84338592c_onies
cooches143515832cooches
cooees85621892coo_ees
cookie123716042cookie_
cooled95224582cool_ed
cooler84824712cool_er
coolers93522492coolers
coolest9318642cool_est
cooling103422572cooling
coolish12312522coolish
coolness1037742coolness
cools75632632cool__s
coolths1236012coolths
coombes133810662coombes
coonties10513792coonties
cootie84223072cootie_
copies104130302c_opies
corbies113520112corbies
corodies11313692corodies
corries94026782corries
cosies84932152c_osies
coulees9315502coulees
coulis84018752couli_s
cowpies143314282cowpies
cowries124218012cowries
cozies174521412c_ozies
cronies9622502cronies
cullies94419962cullies
dhoolies1246962dhoolies
doilies84017362doilies
dollies83620982dollies
doobies103915672doobies
doodies94218772doodies
doolees83711612doolees
doolie73916832doolie_
doozies173812722doozies
doylies114512572doylies
follies103618942follies
foodies113416752foodies
footies103721542footies
goalies8316022goalies
goodies93516992goodies
googlies1086762googlies
goonies83618332goonies
holies94630032_holies
hollies103420812hollies
hoodies113419832hoodies
hookies144017442hookies
hoolie93217772hoolie_
jollies143516272jollies
lollies73116922lollies
loobies93814102loobies
looies65025832loo_ies
loonies73919542loonies
molies84429512_molies
mollies93420232mollies
noogies82814582noogies
nookies113414962nookies
oolites72817842_oolites
polies84034582_polies
roofies103014412roofies
rookies113917102rookies
roomies93017242roomies
stoolies8311082stoolies
toonies73719882toonies
woodies113517152woodies
woolie93514482woolie_
woolier103612352woolier
wooliest113011642wooliest
woollies1147412woollies

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911076710.1261418182.5
2DLD Change Limit1076711036.07617720.7
3Display Results1031030.0801287.5
 (SQL Overall)1786911036.28228444.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.