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

270 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
xeroxes1324644(None) 
xeroses143612831xeroses
xeroxed14244531xeroxed
aerobes9311492aerobes
detoxes1538802detoxes
erodes74819882_erodes
eroses65327062_eroses
heroes94923822hero_es
redoxes15310882redoxes
xerosis14249672xerosis
xerox1138622xerox__
xeruses143010752xeruses
zeroes154314342zero_es
aerates74627493aerates
aeries64737783aer_ies
aerobe8412403aerobe_
aerogel836523aerogel
aerogels945593aerogels
areoles71016953areoles
becomes132911963becomes
behoves15177353behoves
bemixes18338653bemixes
berakes134815773berakes
berates94126873berates
berimes115216643berimes
bermes106023003ber_mes
berobed1238243berobed
berries94423553berries
boraxes163511633boraxes
boxes145625073__boxes
bromes104719763_bromes
broses86524403_broses
bruxes154811023_bruxes
cenotes92814543cenotes
cerates95428253cerates
ceres75540013cer__es
cerises94722253cerises
cerites94823433cerites
ceros74726073cero__s
cerous85821203cero_us
certes84623083cer_tes
ceruses93716233ceruses
cervixes2054603cervixes
chromes142914933chromes
coxes145430863__coxes
creoles9913323creoles
crones84729243_crones
crores86121163_crores
crozes174417663_crozes
cruxes154911563_cruxes
debones103315113debones
decodes113914983decodes
demoses103815833demoses
demotes104717673demotes
denotes83817003denotes
depones103717093depones
deposes103117213deposes
derates84028893derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
desexes1537833desexes
detoxed1636103detoxed
devotes113713753devotes
dewaxes18297843dewaxes
dexes135224513de__xes
drones75023433_drones
droves105116673_droves
elopes85918163_elopes
emotes84620283_emotes
enrobes92211113enrobes
epodes94315563_epodes
eposes84418783_eposes
epoxies1637753_epoxies
erases64425403_erases
ernes55224813_er_nes
erode64520993_erode_
eroded84313593_eroded
eros45238453_ero__s
erose55727283_erose_
erses55826803_er_ses
evokes13459683_evokes
exergues1644123exergues
exes116530813_e__xes
exposes1639963exposes
fedexes1835473fedexes
feres86038183fer__es
ferlies103216693ferlies
ferries103521083ferries
ferules103112723ferules
foxes156321093__foxes
froes86126693_fro_es
furores10310033furores
garotes8614563garotes
gearboxes1942933gearboxes
gemotes103712143gemotes
genomes103611703genomes
geodes8412153ge_odes
goxes135018263__goxes
gropes95220403_gropes
groves104318103_groves
helixes1739133helixes
heredes11313133heredes
heres86245903her__es
heroics122912003heroics
heroines112916573heroines
heroins103518013heroins
heroizes202610983heroizes
herons94820543hero_ns
heros84930863hero__s
herpes115517323her_pes
herries104025073herries
hertzes1938303hertzes
hexes155123043he__xes
hexones17299143hexones
hexoses17228893hexoses
hyraxes2045703hyraxes
iceboxes1943533iceboxes
irones64724013_irones
jerkies183411583jerkies
jerries143817513jerries
kermes124616133ker_mes
kernes104717533ker_nes
kerogen1236093kerogen
kerogens1345763kerogens
kerries113317913kerries
ketones115014503ketones
ketoses114912873ketoses
kexes166216823ke__xes
leones64417723le_ones
lexes127225263le__xes
loxes125227473__loxes
lurexes1436073lurexes
meioses9310833meioses
merces105720743mer_ces
merches144013763merches
mercies113817563mercies
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
merges94122493mer_ges
merises93421423merises
merles85322763mer_les
metopes11311363metopes
mirexes1636993mirexes
murexes1636973murexes
necroses10310573necroses
nerolis71012783nerolis
nerols6914893nero_ls
nerves94216193ner_ves
neurones839683neurones
neuroses8310163neuroses
oryxes1674523_oryxes
oxes116530723___oxes
paroles95025883paroles
pegboxes2043143pegboxes
pekoes124410423peko_es
peones83821043pe_ones
perches143717953perches
perdues103511333perdues
peres76246643per__es
peroxid17310283peroxid
peroxides1947493peroxides
peroxids1837453peroxids
peroxy1838253perox_y
perries93226603perries
perses85428063per_ses
perukes133210113perukes
peruses94018163peruses
peyotes1238483peyotes
phloxes1935513phloxes
poxes145325723__poxes
praxes156215183_praxes
prexes154915953_prexes
probes104119453_probes
proles84627203_proles
proses84733473_proses
proves114322253_proves
proxies163014933_proxies
pyrexes19305843pyrexes
pyrones123113303pyrones
pyropes142210193pyropes
raxes124729393__raxes
rebores95319163rebores
recodes102918633recodes
redoes74623773redo_es
refixes174813173refixes
relaxes143215323relaxes
remixes164313873remixes
remotes94521613remotes
removes124514713removes
reposes94021263reposes
reprobes121910293reprobes
reproves132011473reproves
rerises73525883rerises
rerolls739943rerolls
reroofs1037943reroofs
rerose63320853rerose_
reroutes8312223reroutes
resoles73823653resoles
retaxes143615093retaxes
revokes144212503revokes
revotes104716393revotes
rewaxes173911333rewaxes
rexes124526953__rexes
rezones163213943rezones
robes75133303__robes
rodes614039083__rodes
roes45954143__ro_es
roles56747983__roles
ropes75940063__ropes
roses56445773__roses
rotes56143903__rotes
roues56039353__roues
roves84834483__roves
sarodes84216143sarodes
saroses73619333saroses
senores73218113senores
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serges74225973ser_ges
series64540973ser_ies
serines74229543serines
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
serries73925353serries
serves94423653ser_ves
sexes126126223se__xes
soroses73117493soroses
strobes93813263strobes
strokes114316323strokes
teaboxes1745063teaboxes
telexes1438353telexes
telomes9310533telomes
terces83921413ter_ces
ternes65422903ter_nes
terries73425633terries
tetrodes939093tetrodes
throes97518673thro_es
thrones105715843thrones
trokes104019263_trokes
trones65629283_trones
tropes84824353_tropes
troves94719113_troves
unboxes16208303unboxes
unrobes9269733unrobes
verges104320183ver_ges
verites103822263verites
vermes115019143ver_mes
vernixes1836053vernixes
verses94223763ver_ses
verstes104014283verstes
vertexes18105633vertexes
verves124617883ver_ves
vetoes92914083veto_es
vexes155719123ve__xes
viroses10310533viroses
xenons132710483xeno_ns
xenopus1642983xenopus
xerosere1544733xerosere
xeroseres1644683xeroseres
xerotic16410863xerotic
xeroxing1534513xeroxing
xerus12313333xer__us
xyloses1746843xyloses
zeroed16409423zero_ed
zeros144918113zero__s

Search took 7 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.390458182.1
2DLD Change Limit1340272705.98322401.3
3Display Results2702700.1102454.5
 (SQL Overall)1786912706.48327563.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.