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 “coolie” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
coolie8382160(None) 
collie83621991collie
cookie123716041cookie
coolies93824961coolies
cootie84223071cootie
doolie73916831doolie
hoolie93217771hoolie
woolie93514481woolie
boobie104015292boobie
boogie93515992boogie
bookie123516002bookie
bootie85421152bootie
choline122915382choline
coalier93416172coalier
coble94823172cobl_e
codlin94516432codlin
cole66956112c_ol_e
colic95726172c_olic
colies84837052c_olies
colin76231692c_olin
collide103214782collide
collied103316672collied
collier93618152collier
collies94326582collies
colone85425002colone
commie124215522commie
cooee74531022coo_ee
cookies133719272cookies
cool66940492cool__
cooled95224582cooled
cooler84824712cooler
cooling103422572cooling
coolish12312522coolish
coolly114811392coolly
cools75632632cool_s
coolth1139512coolth
cooly105525422cool_y
coombe124110092coombe
coontie9311412coontie
cooties93725732cooties
corbie103618202corbie
corrie83621212corrie
cosie74728262c_osie
coulee8323502coulee
coulis84018752coulis
cowpie133511512cowpie
cowrie113814272cowrie
cozie163519122c_ozie
doobie94712682doobie
doolee73018952doolee
doolies83920712doolies
doozie163910642doozie
foodie104413842foodie
footie94718132footie
goalie7413152goalie
goodie83613992goodie
goonie73615562goonie
hoodie105116132hoodie
kookie9389832kookie
looie55624242loo_ie
loonie64216452loonie
mollie83517102mollie
noogie73612312noogie
nookie103712432nookie
oolite63319602_oolite
oorie53026362_oorie
roofie93411172roofie
rookie103613262rookie
roomie83013872roomie
stoolie739712stoolie
toonie63617992toonie
woodie103513612woodie
woolier103612352woolier
woolies104117362woolies

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551742.73330205.3
3Display Results74740.0332242.4
 (SQL Overall)178691742.87662131.8
 
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.