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

383 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
lodes6643691(None) 
bodes84935101bodes
codes86247291codes
lades65141271lades
lobes75331001lobes
lode56240111lode_
loden66621141loden
lodens74315061lodens
lodges86820151lodges
loges66534201loges
lopes76437341lopes
lores55045401lores
loses56742011loses
loves85332011loves
lowes85732461lowes
loxes125227471loxes
ludes65728851ludes
modes85537411modes
nodes64633491nodes
odes57243241_odes
rodes614039081rodes
abodes94417512abodes
aedes64625152aedes
aides65336602aides
aloes54933672alo_es
anodes74418762anodes
bides85536772bides
blades95221252blades
blokes123813882blokes
blondes104213162blondes
bode75838752bode_
boded95124962boded
bodies94524142bodies
bods76244712bod_s
boles75448602boles
bones76446532bones
bores76448252bores
boxes145625072boxes
cades85440732cades
cedes84927332cedes
clades94920462clades
clods85320862clod_s
clones84526562clones
closes85425592closes
cloves114918822cloves
clozes174915562clozes
codas84724242codas
code77347732code_
codec107120342codec
codecs115112932codecs
coded95433182coded
coden86128542coden
codens94821012codens
coder86134222coder
coders95426982coders
codex155817582codex
cods76848102cod_s
coeds85920162coeds
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
diodes83915782diodes
dodges96119082dodges
dodoes85716102dodoes
dodos75819392dodos
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dudes75424372dudes
elides74420692elides
elodea738672elodea
elodeas836962elodeas
elopes85918162elopes
eludes75417682eludes
epodes94315562epodes
erodes74819882erodes
fades94932862fades
floes85528142flo_es
foes76543442fo_es
fores85847102fores
foxes156321092foxes
geodes8412152geodes
glades84820342glades
gledes84915132gledes
glides84518862glides
globes94314542globes
gloves104115182gloves
glozes164313352glozes
godet7530042godet
godets8410932godets
gods65438042god_s
goes55644092go_es
gores65740372gores
goxes135018262goxes
gudes74520812gudes
hades96035112hades
hides95129422hides
hods87239862hod_s
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hordes104921632hordes
hoses85443172hoses
howes114730262howes
ides57734232_ides
jades135222112jades
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
laces76141762laces
lade56345982lade_
laded74232612laded
laden65022192laden
ladens74516232ladens
lader65633722lader
laders74927762laders
ladies75124882ladies
ladles74619542ladles
lads56549132lad_s
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
ledges84918012ledges
lees45455882l_ees
leges64427292leges
lenes54738522lenes
leones64417722leones
les35663072l__es
leses54930812leses
leudes75314092leudes
lexes127225262lexes
lidos65219882lidos
lids56336462lid_s
lies46454192l_ies
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
loaded84616872loaded
loader74316312loader
loaders83413432loaders
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loaves94813852loaves
lobe65535362lobe_
lobed86022132lobed
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lodge76520092lodge
lodged913815712lodged
lodger86517692lodger
lodgers95113832lodgers
loess55714702loess
lofts85518362lofts
loge56837192loge_
logos67225332logos
logs57343112lo_gs
loided83414022loided
loids66220702loids
loins56728422loins
lolls512121732lolls
lone45849132lone_
loner55431042loner
loners64225812loners
longes75925572longes
longs65527062longs
looed64626132looed
looey84822912looey
looeys95110122looeys
loofs85623782loofs
looies65025832looies
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loose56627682loose
looses67328242looses
loots55431422loots
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lo_ps
lorded84916732lorded
lords64923502lords
lore45850352lore_
lories64933042lories
loris55329152loris
lose45144582lose_
losel54419422losel
losels64714582losels
loser54728672loser
losers65123582losers
loss45337962lo_ss
losses65925232losses
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lottes65322752lottes
lotus55718062lotus
louden73711792louden
loudens8368052loudens
louder74414602louder
loudest839932loudest
louies64525102louies
louis57322322louis
loupes84918052loupes
loups75319622loups
lours55125292lours
louse56131012louse
louses66230282louses
louts56330272louts
love75234762love_
loved95021362loved
lover85526452lover
lovers94223432lovers
lowe75435312lowe_
lowed95233902lowed
lower85830412lower
lowers94624922lowers
lowest93915592lowest
lows75843012lo_ws
lowse87219902lowse
loxed135017052loxed
lubes74727992lubes
luces75528432luces
lude55331642lude_
lues45943552l_ues
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
mode75840302mode_
model84521692model
models94216352models
modem103717142modem
modems114610762modems
modest93818452modest
mods77945052mod_s
modus85417202modus
mokes114631032mokes
moles74747922moles
momes95134472momes
mondes94322352mondes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
nides65229132nides
node513036882node_
nods55838222nod_s
nodus66315992nodus
noes45845392no_es
nomes74933122nomes
nones55639132nones
noses55435642noses
notes55034582notes
nudes64723292nudes
obes66036832_obes
odas57230262_odas
odds68919922_odds
ode47446582_ode_
odea56224572_odea
ods47546212_od_s
oes35866192_o_es
okes84936342_okes
olden65114852olden
older65121172older
oldest72114092oldest
oldies7314422oldies
olds55926572old_s
oles46453472_oles
ones46146532_ones
oodles73517182oodles
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pedes85327292pedes
plods85719292plod_s
pods76540152pod_s
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
redes65139132redes
rides66140812rides
robes75133302robes
rode55844302rode_
rodeo65921092rodeo
rodeos75314502rodeos
rods56442062rod_s
roes45954142ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
sades65239892sades
sides65838362sides
slides73922182slides
sloes54728872slo_es
slopes84820452slopes
sodas64123542sodas
sods54940212sod_s
sokes95031422sokes
soles55547922soles
sondes74922872sondes
sones55444142sones
sores55454282sores
spodes94817432spodes
tides64830152tides
todies74223552todies
tods56141842tod_s
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wades95634142wades
wides94832822wides
wodges117413682wodges
woes76440662wo_es
yodel94714082yodel
yodels104610072yodels
yodhs12669012yodhs
yodles103714332yodles
yods86531182yod_s
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

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 Filter178691538000.296603685.8
2DLD Change Limit538003831.62633087.3
3Display Results3833830.1103481.8
 (SQL Overall)1786913832.03287938.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.