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 “creel” 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.

135 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
creel7512148(None) 
creed85727391creed
creek114917391creek
creels84416941creels
creep95218101creep
crenel84213061crenel
crewel114310481crewel
cruel74815901cruel
reel45240531_reel
areal55928732areal
ariel55228972ariel
artel56122742artel
bree67241262bree_
breed85526692breed
brees75632552brees
camel96822802camel
carcel105018672carcel
careen84119492careen
career85822242career
carpel105418472carpel
carrel84718632carrel
cartel85022532cartel
carvel114817572carvel
cee55952702c_ee_
cees65941592c_ees
ceil65725062c_eil
cel56040552c__el
cell65031722c_ell
cere66741472cere_
cereal8315832cereal
cered85227442cered
ceres75540012ceres
cheek145115712cheek
cheep125416502cheep
cheer105420382cheer
chiel104918972chiel
cleek115514912cleek
corbel103715972corbel
cormel103815602cormel
cornel84020052cornel
craal74117752craal
crawl104916712crawl
creak115418432creak
cream95721352cream
cred76530882cr_ed
credal9311672credal
credo84815572credo
creds85418772creds
creedal1037092creedal
creeds94714772creeds
creeks124812922creeks
creeled104012012creeled
creeps104213622creeps
creepy13418802creepy
creese84014332creese
creesh11328332creesh
creme94319322creme
cremes104517992cremes
crenels93711012crenels
creole8913732creole
crepe95520722crepe
creped114115702creped
crepes105419342crepes
crepey135110932crepey
crept95125892crept
crepy124812702crepy
cresol8310212cresol
cress75022832cress
crest74632692crest
cresyl1135132cresyl
crew96122682cr_ew
crewed125316562crewed
crewels12438492crewels
crews105917502crews
cried84624282cried
crier74724462crier
cries75438402cries
cruet74831842cruet
cupel9514302cupel
dree56638322dree_
dreed75222842dreed
drees65628522drees
eel37946842__eel
feel75233842_feel
free75940182free_
freed95223542freed
freely12310962freely
freer86021242freer
frees86131392frees
gree56641562gree_
greed75125692greed
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
gruel66014742gruel
heel75034222_heel
keel85729472_keel
kneel95012032kneel
kreep114610412kreep
oriel54920422oriel
peel65535612_peel
pree67044732pree_
preed85128122preed
preen75925052preen
prees75937172prees
real45750292_real
rebel73421292_rebel
ree37974072_ree_
reed55549622_reed
reef74938212_reef
reek85232522_reek
reels55333262_reels
rees45364192_rees
refel84920812_refel
repel74921402_repel
revel84423162_revel
riel46432382_riel
scree720031712scree_
screed95718932screed
screen85216022screen
screes85023972screes
seel45042982_seel
speel74420762speel
steel55721992steel
streel64214022streel
teel46335802_teel
tree47745812tree_
treed65626732treed
treen55622752treen
trees55835762trees
unreel63612932unreel
ureal56722682ureal
weel75834082_weel
wheel115515332wheel

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001351.43637465.2
3Display Results1351350.0334090.9
 (SQL Overall)1786911351.765101241.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.