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

213 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
hexes15512304(None) 
dexes135224511dexes
exes116530811_exes
hebes105521671hebes
hemes105031081hemes
heres86245901heres
hexed165615761hexed
hexer155116681hexer
hexers165612751hexers
kexes166216821kexes
lexes127225261lexes
rexes124526951rexes
sexes126126221sexes
vexes155719121vexes
aedes64625152aedes
apexes1539132apexes
axes117337852_axes
bees65453382be_es
benes75536232benes
beses75830722beses
boxes145625072boxes
cedes84927332cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
coxes145430862coxes
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexies145018342dexies
ekes86726602_ekes
emes65434662_emes
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
gees55647882ge_es
genes65133092genes
ghees95215552ghe_es
goxes135018262goxes
hades96035112hades
haeres94017032haeres
haes77651022h_aes
hajes155420942hajes
hakes126034302hakes
hales85449842hales
hames106138702hames
hares86255542hares
hates86742572hates
haves116034872haves
hazes174928322hazes
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
heaves124120302heaves
hebe96424702hebe_
hecks145220652hecks
heder95623642heder
heders104119762heders
hedges115016262hedges
heed86437602he_ed
heeds95420422heeds
heel75034222he_el
heels85625532heels
heezes184211642heezes
hefts116218152hefts
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
helixes1739132helixes
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
helves124316062helves
heme95034412heme_
hemps126917332hemps
hems95534942he_ms
henges104516462henges
hens75642572he_ns
hents87330742hents
herbs105520502herbs
herds96424682herds
here76447102here_
heresy125011232heresy
herls85226432herls
herms105626432herms
herns84825582herns
heroes94923822heroes
heros84930862heros
herpes115517322herpes
hers75844872he_rs
hes66654202h__es
hests85829932hests
heths116317782heths
hets75547202he_ts
hewed125619432hewed
hewer115719932hewer
hewers123715272hewers
hews105631572he_ws
hex137436172hex__
hexad164910622hexad
hexades18378702hexades
hexads17468192hexads
hexanes17319462hexanes
hexones17299142hexones
hexose16267842hexose
hexoses17228882hexoses
hexyl1844462hexyl
hexyls1933432hexyls
hides95129422hides
hies74842832h_ies
hikes125426982hikes
hires86134342hires
hives116925512hives
hoaxes163611692hoaxes
hoes75755732h_oes
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hoses85443172hoses
howes114730262howes
hues75235232h_ues
hypes135818672hypes
ibexes15436162ibexes
ilexes134510252ilexes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
laxes125430092laxes
lees45455882le_es
leges64427292leges
lenes54738522lenes
leses54930812leses
lexis125916032lexis
loxes125227472loxes
luxes124921502luxes
maxes145629532maxes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mixes147224402mixes
nenes55329672nenes
neves87021872neves
nexus124710662nexus
nixes124519622nixes
oxes116530722_oxes
paxes144928422paxes
pedes85327292pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pixes144323172pixes
plexes155313542plexes
poxes145325722poxes
prexes154915952prexes
pyxes175911402pyxes
raxes124729392raxes
redes65139132redes
rees45364192re_es
reges65628792reges
rhemes115913182rhemes
saxes125229342saxes
sees45361052se_es
semes75731582semes
seres55448892seres
sexed136618542sexed
sexts125118382sexts
sixes124526362sixes
taxes124730822taxes
tees45353582te_es
teles54536002teles
texas126514932texas
texts125515042texts
thebes115914492thebes
themes115319252themes
theres96525472theres
theses96517972theses
tuxes124316042tuxes
vees75439432ve_es
veges94118872veges
vexed165713112vexed
vexer155513522vexer
vexers165210402vexers
waxes155825502waxes
wees76249122we_es
wheres125917432wheres
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.310576422.6
2DLD Change Limit538002131.58034050.6
3Display Results2132130.0464630.4
 (SQL Overall)1786912131.93692299.1
 
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.