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

292 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
exes11653081(None) 
axes117337851axes
dexes135224511dexes
ekes86726601ekes
emes65434661emes
eses45336101eses
eves76230461eves
ewes76328701ewes
exec135313941exec
execs14539721execs
exed125420591exed
eyes75837881eyes
hexes155123041hexes
kexes166216821kexes
lexes127225261lexes
oxes116530721oxes
rexes124526951rexes
sexes126126221sexes
vexes155719121vexes
aces67645092aces
aedes64625152aedes
ages55844592ages
ales47067102ales
anes45255932anes
apes66047432apes
apexes1539132apexes
ares45871022ares
ates45047922ates
aves76142602aves
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axels126313632axels
axis116127912axis
axles125219472axles
ayes76543512ayes
bees65453382bees
benes75536232benes
bes56557432_bes
beses75830722beses
boxes145625072boxes
byes95230532byes
cedes84927332cedes
cees65941592cees
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
coxes145430862coxes
cues65438982cues
dees56356632dees
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexies145018342dexies
dies55653522dies
does56554472does
dues56045502dues
dyes85331892dyes
ears46356592ears
ease45042332ease
eases56041612eases
eats47054872eats
eaves85231992eaves
ebbs82411992ebbs
eches106322162eches
ecus65421462ecus
edges75718742edges
edhs86212102edhs
eds46638922e_ds
eek77935102e_ek
eel37946842e_el
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
eger55923572eger
egers65120372egers
egest65222342egest
eggs66516152eggs
egis56520652egis
egos55821652egos
eke75630092eke_
eked96718022eked
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
else45923082else
elves85118742elves
eme55837182eme_
emeu66723432emeu
emeus76913332emeus
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epee64628502epee
epees75219832epees
epos66723732epos
eras45441502eras
ere36352772ere_
ergs55523812ergs
ernes55224812ernes
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
erses55826802erses
es29048222__es
esnes54817362esnes
ess36030882e_ss
esses56422972esses
etas46432272etas
eths76619522eths
eve66331162eve_
even75222272even
evens84817102evens
ever77027692ever
ewe66630982ewe_
ewer77523982ewer
ewers86018822ewers
ex98835642ex__
exam132514622exam
exams14199082exams
excel1437742excel
excels1536662excels
excess1546052excess
exert124624142exert
exerts133712292exerts
exiles134816402exiles
exines135715802exines
exist124618942exist
exit114428672exit
exits125515912exits
exon117116802exon
exons125813342exons
expel1448232expel
expels1547172expels
expo1349182expo
expos1449202expos
exudes143710362exudes
eyas76427432eyas
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyers86521332eyers
eyres84921772eyres
faxes155726652faxes
feces105625362feces
fees76450602fees
femes105626222femes
feres86038182feres
fes66551672_fes
fetes85630142fetes
fezes175220022fezes
fixes154723592fixes
flexes164512952flexes
foes76543442foes
foxes156321092foxes
gaes56348032gaes
gees55647882gees
genes65133092genes
gies55641422gies
goes55644092goes
goxes135018262goxes
haes77651022haes
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hes66654202_hes
hexed165615762hexed
hexer155116682hexer
hexers165612752hexers
hies74842832hies
hoes75755732hoes
hues75235232hues
ibexes15436162ibexes
ices66129642ices
ides57734232ides
ilexes134510252ilexes
ires45639282ires
jees115938542jees
jefes155613672jefes
jetes124922842jetes
joes116635892joes
kaes85734062kaes
kues86426772kues
kyes115124932kyes
laxes125430092laxes
lees45455882lees
leges64427292leges
lenes54738522lenes
les35663072_les
leses54930812leses
lexis125916032lexis
lies46454192lies
loxes125227472loxes
lues45943552lues
luxes124921502luxes
lyes75530832lyes
maes66948402maes
maxes145629532maxes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mixes147224402mixes
nenes55329672nenes
neves87021872neves
nexus124710662nexus
nixes124519622nixes
noes45845392noes
obes66036832obes
odes57243242odes
oes35866192_oes
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owes75137102owes
oxen116218592oxen
oyes74940132oyes
paxes144928422paxes
pedes85327292pedes
pees65257372pees
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pes57259782_pes
pies66949602pies
pixes144323172pixes
plexes155313542plexes
poxes145325722poxes
prexes154915952prexes
pyes95528992pyes
pyxes175911402pyxes
raxes124729392raxes
redes65139132redes
rees45364192rees
reges65628792reges
res35565042_res
roes45954142roes
rues46044482rues
ryes75529352ryes
saxes125229342saxes
sees45361052sees
semes75731582semes
seres55448892seres
sexed136618542sexed
sexts125118382sexts
shes75734352shes
sixes124526362sixes
sues46247652sues
taxes124730822taxes
tees45353582tees
teles54536002teles
texas126514932texas
texts125515042texts
ties45248312ties
toes46956442toes
tres46542902tres
tuxes124316042tuxes
tyes76433372tyes
ukes86122812ukes
uses44931112uses
utes45930882utes
vees75439432vees
veges94118872veges
vexed165713112vexed
vexer155513522vexer
vexers165210402vexers
vies75238622vies
voes75432822voes
waes76048602waes
waxes155825502waxes
wees76249122wees
woes76440662woes
wyes105727502wyes
xis106935332_xis
yes66250612_yes
yeses85119322yeses
zaxes215113822zaxes
zees136331892zees

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 Filter178691298720.266671770.7
2DLD Change Limit298722920.84335435.3
3Display Results2922920.0604866.7
 (SQL Overall)1786912921.169152858.0
 
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.