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

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
rexes12452695(None) 
dexes135224511dexes
exes116530811_exes
hexes155123041hexes
kexes166216821kexes
lexes127225261lexes
prexes154915951prexes
raxes124729391raxes
redes65139131redes
rees45364191re_es
reges65628791reges
sexes126126221sexes
vexes155719121vexes
aedes64625152aedes
apexes1539132apexes
arenes64928392arenes
aretes64425352aretes
axes117337852_axes
bees65453382be_es
benes75536232benes
beses75830722beses
boxes145625072boxes
bredes94818472bredes
brees75632552bre_es
breves115516422breves
bruxes154811022bruxes
cedes84927332cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
coxes145430862coxes
cremes104517992cremes
crepes105419342crepes
cruxes154911562cruxes
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexies145018342dexies
drees65628522dre_es
ekes86726602_ekes
emes65434662_emes
ernes55224812ernes
erses55826802erses
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exec135313942_exec
execs14539722_execs
exed125420592_exed
eyes75837882_eyes
faxes155726652faxes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fixes154723592fixes
flexes164512952flexes
foxes156321092foxes
frees86131392fre_es
freres94716172freres
gees55647882ge_es
genes65133092genes
goxes135018262goxes
grebes93813612grebes
grees65132472gre_es
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hexed165615762hexed
hexer155116682hexer
hexers165612752hexers
ibexes15436162ibexes
ilexes134510252ilexes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
krewes1337922krewes
laxes125430092laxes
lees45455882le_es
leges64427292leges
lenes54738522lenes
leses54930812leses
lexis125916032lexis
loxes125227472loxes
lurexes1436072lurexes
luxes124921502luxes
maxes145629532maxes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mirexes1636992mirexes
mixes147224402mixes
murexes1636972murexes
nenes55329672nenes
neves87021872neves
nexus124710662nexus
nixes124519622nixes
oryxes1674522oryxes
oxes116530722_oxes
paxes144928422paxes
pedes85327292pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pixes144323172pixes
plexes155313542plexes
poxes145325722poxes
praxes156215182praxes
prees75937172pre_es
prexies163415002prexies
prezes173614692prezes
pyrexes19305842pyrexes
pyxes175911402pyxes
races74943242races
rages64539442rages
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxed135622662raxed
razes145032702razes
reads64835272reads
reales64934122reales
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
reaves94127572reaves
rebbes10313532rebbes
rebec94416542rebec
rebecs103913672rebecs
rebel73421292rebel
rebels84518132rebels
rebs65733562re_bs
rebus75721112rebus
recces10614912recces
recess8314262recess
recks115625132recks
recs65734182re_cs
redds74617832redds
rede55037672rede_
reded74829122reded
redoes74623772redoes
redos65126762redos
redoxes15310882redoxes
reds56042862re_ds
redyes104214092redyes
ree37974072re_e_
reed55549622re_ed
reeds65430902reeds
reef74938212re_ef
reefs85121662reefs
reek85232522re_ek
reeks94124032reeks
reel45240532re_el
reels55333262reels
reest54938092re_est
reeves94721492reeves
refed93921922refed
refel84920812refel
refels94618052refels
refer84822142refer
refers93921082refers
refixes174813172refixes
refs75732242re_fs
regs55436572re_gs
rehem103815352rehem
rehems113410982rehems
reifs84819092reifs
reins56234562reins
reis45343232re_is
reives95723042reives
rekey124014732rekey
rekeys13347692rekeys
relaxes143215322relaxes
relet54749822relet
relets64025672relets
relies65036422relies
remet74843722remet
remex146315792remex
remixes164313872remixes
rems66237722re_ms
rends65129952rends
renest64529712renest
renew83917512renew
renews93811752renews
rentes65431192rentes
rents55935182rents
repeg84015052repeg
repegs93311942repegs
repel74921402repel
repels84318762repels
repos74725792repos
repps95114342repps
reps65937952re_ps
res35565042r__es
resee54336332resee
resees63827482resees
reset55051862reset
resets65427612resets
resew84519502resew
resews94814172resews
reshes94124362reshes
rests54935872rests
retaxes143615092retaxes
rete44944132rete_
retem74221952retem
retems83914572retems
retest64028452retest
reties65436192reties
rets45352562re_ts
reuse56025362reuse
reuses66025522reuses
revel84423162revel
revels94220572revels
revers94529632revers
revest94623602revest
revet84938842revet
revets94022172revets
revs75027052re_vs
revues9813902revues
rewaxes173911332rewaxes
rewed95425452rewed
reweds104412302reweds
rewet85135152rewet
rewets94617212rewets
rex105740992rex__
rexines144719152rexines
rhemes115913182rhemes
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
robes75133302robes
rodes614039082rodes
roes45954142r_oes
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
rubes74928412rubes
rues46044482r_ues
rules55234252rules
runes55530222runes
ruses56136582ruses
ryes75529352r_yes
rykes125513032rykes
saxes125229342saxes
sees45361052se_es
semes75731582semes
seres55448892seres
sexed136618542sexed
sexts125118382sexts
sixes124526362sixes
taxes124730822taxes
tees45353582te_es
teles54536002teles
texas126514932texas
texts125515042texts
trees55835762tre_es
tuxes124316042tuxes
vees75439432ve_es
veges94118872veges
vexed165713112vexed
vexer155513522vexer
vexers165210402vexers
waxes155825502waxes
wees76249122we_es
yeses85119322yeses
zaxes215113822zaxes
zees136331892ze_es

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 Filter178691538000.296603685.8
2DLD Change Limit538002901.59333772.8
3Display Results2902900.0803625.0
 (SQL Overall)1786912901.96990752.2
 
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.