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

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

290 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
wormil113804(None) 
wormils1236731wormils
cormel103815602cormel
dormie9312622dormie
dormin9312312dormin
formal113215202formal
formic13310452formic
formol112910332formol
formyl14276442formyl
normal83213532normal
wordily1437852wordily
worm96129492worm__
wormed124314302wormed
wormer114514912wormer
wormier12278762wormier
worming132811242worming
wormish1537162wormish
worms105320762worm_s
wormy137514252worm_y
worrit92313312worrit
zoril143916692zor_il
airmail946213airmail
aortal65217513aortal
aortic8316613aortic
argil65116883_argil
aril45843023_ar_il
barmie103816393barmie
boil66335183bo__il
boral75831703bor_al
bordel94514573bordel
boreal84817213boreal
boric98024223bor_ic
brail75525553_brail
broil74918223_broil
bromal10313653bromal
bromic122412693bromic
bromid112612893bromid
bromin102615693bromin
coil66439653co__il
comal95125133co_mal
comic114721813co_mic
comix163513203co_mix
commie124215523commie
commit124016703commit
commix19407763commix
coral76033453cor_al
corbeil11859213corbeil
corbel103715973corbel
corbie103618203corbie
cordial10312943cordial
coremia11310363coremia
corgi8316083corgi_
corgis9314413corgis
coria75828323cor_ia
corm85735383corm__
cormels113813373cormels
cormoid12310403cormoid
corms95626223corm_s
cornel84020053cornel
cornily12410853cornily
corral83616253corral
corrie83621223corrie
cortin82423153cortin
corvid12310473corvid
cosmic12410343cosmic
cosmid11810643cosmid
derail74218813derail
dermal93614343dermal
dermic114511913dermic
dermis94717163dermis
domal85619203do_mal
domic104317243do_mic
doomily1336133doomily
dorm76834633dorm__
dormer94415903dormer
dormice1237133dormice
dormins10311273dormins
dorms85723843dorm_s
dormy115817473dorm_y
dorsal74613943dorsal
dorsel75315503dorsel
dossil75110903dossil
drail65020973_drail
ervil8310303_ervil
fermi103914163fermi_
fermis114313503fermis
foamily1546543foamily
foil76433913fo__il
forbid123312433forbid
fordid113512053fordid
foremilk1744373foremilk
form95836873form__
formals123312893formals
format113021353format
forme105225993form_e
formed125021173formed
formee113919943formee
former114221403former
formes114623713formes
formful1545183formful
formica1436443formica
forming133615733forming
formols12299413formols
forms105327053form_s
formula1246293formula
formyls15235703formyls
fornix1636033fornix
forrit91916623forrit
fortis95418613fortis
fossil9379353fossil
frail85220213_frail
gerbil938343gerbil
goral65125753gor_al
gorily10612503gor_ily
gorm75529393gorm__
gormed105013833gormed
gorming112810833gorming
gorms85619593gorm_s
grail64622873_grail
harmin113117393harmin
hermit11519443hermit
holmic1338783holmic
homie104622533ho_mie
homily144712333ho_mily
horal86328683hor_al
hornily1338283hornily
horrid10311563horrid
horsily1338843horsily
karmic1438113karmic
kermis124012393kermis
korai97018523korai_
korma115913073korm_a
kormas124511233kormas
koumis1237623koumis
loral55927823lor_al
loreal63814313loreal
loris55329153lor_is
mil55752113___mil
moil65534093mo__il
momi87524483mo_mi_
moral75533433mor_al
morbid112511463morbid
morel75729093mor_el
morris83814733morris
morsel85815893morsel
mortal84616853mortal
noil46133243no__il
nordic939473nordic
nori47133143nor_i_
noria55722183nor_ia
noris54928273nor_is
norm66429813norm__
normals92510903normals
normed95014543normed
norms76019313norm_s
ohmic1237833_ohmic
oil37452053_o__il
omit65337373_o_mit
oorali6311263oorali
oorie53026363oor_ie
oral47638123_or_al
orbit73622063_orbit
orchil1158653_orchil
orcin72716573_orcin
orgic8311823_orgic
oriel54920423_oriel
ormer75218373_ormer
ormolu845833_ormolu
ornis54616773_ornis
orpin73415533_orpin
orris54516553_orris
osmic939913_osmic
osmol7138573_osmol
peril75425953per_il
permit10321683permit
pommel12277453pommel
pommie123710503pommie
pontil8315463pontil
portal84218463portal
rail46147763__rail
roil46235293__roil
roomie83013873roomie
roomily1237283roomily
serail64222673serail
soil46138833so__il
sorbic10310393sorbic
sordid83411163sordid
sorel56231443sor_el
sori46039843sor_i_
sorrel6413553sorrel
sorrily1039833sorrily
sortie63621993sortie
soymilk1642363soymilk
stormily1345243stormily
toil46536283to__il
tonsil6311873tonsil
tori47542153tor_i_
toric76529313tor_ic
torii55521593tor_ii
toroid7416013toroid
torpid9310913torpid
torrid7311853torrid
torsi57423363torsi_
tortile7313193tortile
trail55126773_trail
turmoil944723turmoil
vermeil1285223vermeil
vermin113414523vermin
vermis114214963vermis
vomit102622573vo_mit
wadmal1237283wadmal
wadmel1235523wadmel
wadmol1234053wadmol
wail75238823w__ail
warily122915093war_ily
warm95935673warm__
warmed124516893warmed
warmer113816733warmer
warming133515083warming
warmish1538373warmish
warmly14228063warmly
warms107726853warm_s
warmth1477933warmth
warmup1335343warmup
weevil1295433weevil
wergild1234043wergild
whorl114612453whor__l
wimmin1336153wimmin
wirily123310783wir_ily
woeful1236363woeful
woful1158173wo_ful
woman105818003wo_man
womb117022233wo_m_b
wombs125813343wo_mbs
womby155910093wo_mby
women104619253wo_men
womyn13426363wo_myn
woodie103513613woodie
wool76427373wo__ol
woolie93514483woolie
woorali1045263woorali
woozily2234383woozily
word89832003wor__d
worded114316623worded
wordier112511213wordier
wording123014563wording
words95425073wor_ds
wordy126916163wor_dy
wore77144673wor__e
work115528843wor__k
worked145314703worked
worker134715113worker
working153813253working
workman1635613workman
workmen1635933workmen
works125621903wor_ks
workup1534323workup
world96915363wor_ld
worldly1433993worldly
worlds10568733worlds
wormers124012573wormers
wormhole1644663wormhole
wormiest13249543wormiest
wormlike1735313wormlike
worn75631753wor__n
worried11308693worried
worrier102311683worrier
worries104117133worries
worrits10258683worrits
worry116114333wor_ry
worse86525263wor_se
worsen95513873worsen
worser95117523worser
worses95522953worses
worset96726583worset
worship1547833worship
worst86330133wor_st
worsts96014333worsts
wort76654753wor__t
worth117120523wor_th
worthily1745253worthily
worths127812893worths
worthy15598803worthy
worts88631183wor_ts
writ75537913w_r_it
wurzel1834993wurzel
yomim12510083yo_mim
zori137722923zor_i_
zorils153810883zor_ils
zoris145320013zor_is

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162905.65619928.6
3Display Results2902900.0933118.3
 (SQL Overall)1786912906.13929107.5
 
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.