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

265 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
leges6442729(None) 
ledges84918011ledges
lees45455881le_es
leger65721511leger
legers74518311legers
legs56133691leg_s
lenes54738521lenes
leses54930811leses
lexes127225261lexes
lieges74113441lieges
loges66534201loges
luges65928751luges
reges65628791reges
veges94118871veges
aedes64625152aedes
aegis6316782aegis
ages55844592_ages
alleges84212572alleges
bees65453382be_es
beget85632562beget
begets96215522begets
begs75733832beg_s
beiges91014412beiges
benes75536232benes
beses75830722beses
cages85936012cages
cedes84927332cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
clepes104214622clepes
dees56356632de_es
degas75119162degas
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
doges75630162doges
edges75718742edges
eger55923572_eger
egers65120372_egers
egest65222342_egest
eggs66516152_eggs
egis56520652_egis
egos55821652_egos
ekes86726602_ekes
elegies81312902elegies
elves85118742elves
emes65434662_emes
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fledges12409392fledges
flees85828752fle_es
flexes164512952flexes
gages74529972gages
gees55647882ge_es
genes65133092genes
glebes95512242glebes
gledes84915132gledes
glees65027592gle_es
hebes105521672hebes
hedges115016262hedges
hemes105031082hemes
henges104516462henges
heres86245902heres
hexes155123042hexes
ilexes134510252ilexes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
kedges124812982kedges
kegs95824022keg_s
kexes166216822kexes
kluges11389572kluges
laces76141762laces
lades65141272lades
lager65132862lager
lagers74826142lagers
lags56546222lag_s
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
larges74824232larges
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
leads66028492leads
leafs85721182leafs
leagues837942leagues
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182le_as
lease55230262lease
leases65428112leases
leaves94222382leaves
leben7314852leben
lebens8310092lebens
leches115421312leches
ledge76519492ledge_
ledger85914392ledger
ledgers94912182ledgers
lee36068142le_e_
leek85331732le_ek
leeks95318892leeks
leer46239352le_er
leers54828982leers
leet45957902le_et
leets54927122leets
lefts86517812lefts
leg46446112leg__
legal65715942legal
legals73412732legals
legates82917682legates
legend837692legend
legends936072legends
legged95713092legged
leggy105210242leggy
legist71315252legist
legit61323502legit
legits71313002legits
legless838012legless
legmen939342legmen
legumes1036632legumes
lehrs86111132lehrs
leis45739602le_is
leke85527402leke_
leks85427602le_ks
lends65326252lends
lenis56326862lenis
lenos56024862lenos
lens46146492le_ns
lense54523432lense
lenses64620892lenses
leones64417722leones
leper74820742leper
lepers84817322lepers
les35663072l__es
less45635102le_ss
lethes94818082lethes
lets47147942le_ts
leudes75314092leudes
leuds66214812leuds
levee84023812levee
levees93714522levees
level84116552level
levels94113282levels
lever85125162lever
levers94621322levers
levies93919862levies
levis85818552levis
lewis85315842lewis
lexis125916032lexis
leys76430182le_ys
lezzes14387832lezzes
liege65314432liege_
lies46454192l_ies
liger65024472liger
ligers75022042ligers
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
lobes75331002lobes
lodes66436912lodes
lodges86820152lodges
loge56837192loge_
logos67225332logos
logs57343112log_s
longes75925572longes
lopes76437342lopes
lores55045402lores
loses56742012loses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552l_ues
luge55531642luge_
luged74019092luged
luger65322082luger
lugers74617022lugers
lugs55233522lug_s
lunes55337772lunes
lunges76123422lunges
lures56138532lures
lutes55836662lutes
luxes124921502luxes
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
mages85036022mages
megs75530632meg_s
memes94927702memes
meres75143572meres
merges94122492merges
metes74736212metes
mezes167719262mezes
negs55727362neg_s
negus64513562negus
nenes55329672nenes
neves87021872neves
ogees65119142ogees
pages85235072pages
peages94321852peages
pedes85327292pedes
pees65257372pe_es
pegs75531762peg_s
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
plages94520152plages
plebes104313622plebes
pledges113811582pledges
plexes155313542plexes
rages64539442rages
redes65139132redes
rees45364192re_es
regs55436572reg_s
rexes124526952rexes
sages65339062sages
sedges83817812sedges
sees45361052se_es
segos64919482segos
segs54933882seg_s
segues7412072segues
semes75731582semes
seres55448892seres
serges74225972serges
sexes126126222sexes
sieges73816832sieges
sledges94511572sledges
tees45353582te_es
teggs74710742teggs
tegs56031492teg_s
teles54536002teles
urges64619912urges
vees75439432ve_es
vegies104314272vegies
venges104015152venges
verges104320182verges
vexes155719122vexes
wages95330932wages
wedges114614582wedges
wees76249122we_es
yeggs10608162yeggs
yeses85119322yeses
zees136331892ze_es

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 Limit538002651.76630464.3
3Display Results2652650.0604416.7
 (SQL Overall)1786912652.12284208.8
 
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.