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

233 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
wormils123673(None) 
wormil1138041wormil_
cormels113813372cormels
dormins10311272dormins
formals123312892formals
formols12299412formols
formyls15235702formyls
normals92510902normals
wordily1437852wordily
wormers124012572wormers
wormier12278762wormier
wormiest13249542wormiest
worming132811242worming
wormish1537162wormish
worms105320762worm__s
worries104117132worries
worrits10258682worrits
zorils153810882zor_ils
airmails1045273airmails
argils75213623_argils
arils58732203_ar_ils
armies85123693_armies
boils75427193bo__ils
borals86721913bor_als
bordels103911973bordels
brails84621293_brails
broils84114173_broils
bromals1139743bromals
bromids12278603bromids
bromins112513783bromins
coils75030083co__ils
comics124015563co_mics
commies133718453commies
commits133812383commits
corals85325143cor_als
corbeils12358073corbeils
corbels113813593corbels
corbies113520123corbies
cordials1139633cordials
corgis9314413corgi_s
cormel103815603cormel_
cormous11312353cormous
corms95626223corm__s
cornels94716663cornels
cornily12410853cornily
corrals93713853corrals
corries94026803corries
cortins92421333cortins
corvids1337683corvids
cosmids1237633cosmids
derails84216393derails
dermis94717163dermi_s
doomily1336133doomily
dories75232363dor_ies
dormers104313923dormers
dormice1237133dormice
dormie9312623dormi_e
dormin9312313dormi_n
dorms85723843dorm__s
dorsals84110853dorsals
dorsels84412583dorsels
dossils8669773dossils
drails74716953_drails
ervils948773_ervils
fermis114313503fermi_s
foamily1546543foamily
foils85025813fo__ils
forbids13268263forbids
foremilk1744373foremilk
foremilks1842783foremilks
formal113215203formal_
formats123113573formats
formers128217953formers
formes114623713form_es
formic13310453formi_c
formica1436443formica
formicas1546003formicas
forming133615733forming
formol112910333formol_
forms105327053form__s
formula1246293formula
formulas1346303formulas
formyl14276443formyl_
forties104323863forties
fortis95418613forti_s
fossils10379013fossils
frails93716473_frails
gerbils1037303gerbils
gorals76917653gor_als
gorily10612503gor_ily
gorming112810833gorming
gorms85619593gorm__s
grails77518783_grails
harmins123716723harmins
hermits12312143hermits
homies114524733ho_mies
homily144712333ho_mily
hornily1338283hornily
horsily1338843horsily
kermis124012393kermi_s
kormas124511243korm_as
koumis1237623koumi_s
koumiss1344313koumiss
lories64933043lor_ies
loris55329153lor_i_s
lorries74518353lorries
mils66045343___mils
moils76125753mo__ils
mommies103912273mommies
morals85324643mor_als
morels84820023mor_els
morris83814733morri_s
morsels94112663morsels
mortals93914013mortals
noils55024333no__ils
norias65518203nor_ias
noris54928273nor_i_s
normal83213533normal_
norms76019313norm__s
oils46337983_o__ils
omits75018263_o_mits
ooralis7312553ooralis
orals55826483_or_als
orbits84211443_orbits
orchils1277703_orchils
orcins83313433_orcins
orgies72316093_orgies
oriels64914623_oriels
ormers84316143_ormers
ormolu845833_ormolu
ormolus934743_ormolus
ornis54616773_orni_s
orpins83614163_orpins
orris54516553_orri_s
osmics1036463_osmics
osmols8137313_osmols
perils84121853per_ils
permits11314003permits
pommels13235793pommels
pommies133712843pommies
pontils9312213pontils
porgies103017003porgies
porkies133416493porkies
portals94015563portals
rails55937403__rails
roils54826793__roils
roomies93017243roomies
roomily1237283roomily
serails73318363serails
soils55327983so__ils
sorels63921163sor_els
sorrels7310723sorrels
sorrily1039833sorrily
sorties74126403sorties
soymilk1642363soymilk
soymilks1741403soymilks
stormily1345243stormily
toils54527493to__ils
tommies113812983tommies
tonsils7310183tonsils
torics85118353tor_ics
tories65435883tor_ies
toroids8310653toroids
torpids1037373torpids
tortile7313193tortile
trails64622513_trails
turmoils1043983turmoils
vermeils1374813vermeils
vermis114214963vermi_s
vomits112610923vo_mits
wadmals1335513wadmals
wadmels1334303wadmels
wadmols1333913wadmols
wails86631483w__ails
warily122915093war_ily
warmers124514293warmers
warming133515083warming
warmish1538373warmish
warmly14228063warm_ly
warms107726853warm__s
warmths1583783warmths
warmups1433813warmups
weevils1384683weevils
wergild1234043wergild
wergilds1342653wergilds
whorls124410163whor__ls
wirily123310783wir_ily
womans114613653wo_mans
wombs125813343wo_m_bs
woodies113517153woodies
woolies104117363woolies
wools84421463wo__ols
wooralis1145803wooralis
woozily2234383woozily
wordier112511213wordier
wordiest122311543wordiest
wording123014563wording
wordings13328563wordings
words95425073wor__ds
workers144612693workers
working153813253working
workings16337503workings
works125621903wor__ks
workups1633613workups
world96915363wor__ld
worldly1433993worldly
worlds10568733wor_lds
worm96129493worm___
wormed124314303worm_ed
wormer114514913worm_er
wormhole1644663wormhole
wormholes1744613wormholes
worminess14127613worminess
wormlike1735313wormlike
wormy137514253worm__y
worried11308693worried
worrier102311683worrier
worriers11257813worriers
worrit92313313worri_t
worsens104610263worsens
worses95522953wor_ses
worsets105512843worsets
worships1647103worships
worsts96014333wor_sts
worthies14310283worthies
worthily1745253worthily
worths127812893wor_ths
worts88631183wor__ts
wries85827743w_r_ies
writs86624383w_r_its
wurzels1934083wurzels
zoril143916693zor_il_
zoris145320013zor_i_s

Search took 8 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 Filter1786911340270.420425454.8
2DLD Change Limit1340272336.51620568.9
3Display Results2332330.0932505.4
 (SQL Overall)1786912337.02925422.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.