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

356 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
hexade1743890(None) 
hexad164910621hexad_
hexades18378701hexades
hexads17468201hexads
hexane16379531hexane
decade104216162decade
evade938182_evade
exude134010292_exude
hade85440202h__ade
head87137172he_ad_
headed114020472he_aded
header104422542he_ader
heads95127112he_ads
heady125117262he_ady
heave114521812he_ave
hexadic2045412hexadic
hexanes17319462hexanes
hexed165615762hexed_
hexone16289232hexone
hexose16267842hexose
pesade9311102pesade
remade94316982remade
abrade9313053abrade
aerate64830553aerate
ahead96817053ahe_ad_
alcade91111513alcade
arcade91013643arcade
aubade939223aubade
bade75140893__bade
bead75937923be_ad_
beaded104922423be_aded
beader94623793be_ader
beadle93314683be_adle
beads85429503be_ads
beady114719923be_ady
became123213163became
begaze1838333begaze
behave14209013behave
belady12489933belady
bename103316073bename
berake124216083berake
berate84729023berate
beside95114613beside
betake124512703betake
betide95115973betide
beware11313713beware
blade85923333_blade
cade76443923__cade
cease75227653ce_ase
cede74928783ce__de
cerate84829463cerate
cetane8315283cetane
chamade15138453chamade
charade13129913charade
chelae113614613chela_e
chelate122914903chelate
clade85821013_clade
comade114415323comade
coxae146115183coxa_e
dead65434243de_ad_
deaden83714323de_aden
deader84220473de_ader
deads75726913de_ads
deave95022333de_ave
debase94014473debase
debate94419193debate
decades113615513decades
decane93818873decane
decare93919153decare
decide104116873decide
decode104414743decode
deface123113863deface
defame123212433defame
degage92711383degage
degame102713183degame
degrade10229903degrade
dekare112811563dekare
delate73827753delate
delude81910673delude
demode104013463demode
denude8169353denude
derate74531233derate
deride84420033deride
dexie134716893dex_ie
ease45042333_e_ase
eave75733583_e_ave
egad64215413_egad_
egads74610923_egads
eide55832253_e_ide
elate55335883_elate
elide64922653_elide
elude64517623_elude
emyde1136383_emyde
enate54428153_enate
epode85114093_epode
erase54925493_erase
erode64520993_erode
etape74413703_etape
etude63612303_etude
evaded1137063_evaded
evader1036813_evader
evades1039023_evades
exact143516933_exact
exalt123018533_exalt
exam132514623_exa_m
examen1538283_examen
exams14199083_exams
excide1638423_excide
exed125420593_exed_
exhale1636873_exhale
exile126117653_exile
exine125518493_exine
exuded15317683_exuded
exudes143710363_exudes
facade1238803facade
fade85736353__fade
fease84824873fe_ase
feaze175216313fe_aze
female11310553female
fixate1638733fixate
gelada837623gelada
gelate73421263gelate
geode7412593ge_ode
glade75121963_glade
grade75126093_grade
grenade938413grenade
had77658773h__ad_
haded105227623h__aded
hades96035113h__ades
hadj155818683h__adj
hae67364003h__a_e
haed86338583h__aed
hake115637843h__ake
hale76052833h__ale
halide103417993halide
hamada1239923hamada
hamate113319833hamate
hame97043133h__ame
hare76255733h__are
hate78450173h__ate
have106137073h__ave
haze164833393h__aze
headend12398363he_adend
headers113819393he_aders
headier113212953he_adier
headmen13259513he_admen
headset11312603he_adset
heal75645693he_a_l
healed105121443he_aled
healer94221803he_aler
heals85733463he_als
heap96432893he_a_p
heaped124516903he_aped
heaper114119523he_aper
heaps105223223he_aps
heapy135914983he_apy
hear76143883he_a_r
heard95222753he_ard
hearer94323653he_arer
hears86737373he_ars
hearse94114283hearse
heart85440743he_art
heat77061423he_a_t
heated104525593he_ated
heater94828303he_ater
heath115724283he_ath
heats85838403he_ats
heaume1137543heaume
heaved134717863he_aved
heaven123912603he_aven
heaver124819673he_aver
heaves124120303he_aves
heavy144814183he_avy
hebe96424703he__be
heckle153112093heckle
hectare1238473hectare
heddle114211163heddle
heder95623643he__der
hedge105317353he_dge
hedged125211813hedged
heed86437603he_ed_
heeded114215763he_eded
heeder104216043he_eder
heeds95420423he_eds
heeled104018423heeled
heeze175313483he_eze
heezed194210513heezed
hefted134911423hefted
hegari1039523hegari
heiled104415613heiled
heinie92512663heinie
heired103813043heired
hektare1435513hektare
held85330403he_ld_
helled104024703helled
helmed124513693helmed
helped124714153helped
helve115018093he_lve
helved134313703helved
hemal104419803hema_l
heme95034413he__me
hemmed144211463hemmed
hempie132410563hempie
henbane1237363henbane
hence104920053he_nce
henge94819833he_nge
hennaed1135103hennaed
hented104218753hented
heptad1237273heptad_
heptads1335873heptads
heptane1238363heptane
herald10311343herald
heralded1335443heralded
heralds1137713heralds
herbage1337013herbage
herbed123513453herbed
herd84933063he_rd_
herded114215643he_rded
herder104516463he_rder
herds96424683he_rds
here76447103he__re
heredes11313133heredes
hermae115314473hermae
hewable15177823hewable
hewed125619433hewed_
hex137436173hex___
hexagon1843823hexagon
hexamine2046873hexamine
hexapla1943353hexapla
hexapod2043653hexapod
hexapods2143403hexapods
hexapody2442313hexapody
hexer155116683hex_er
hexerei1764163hexerei
hexers165612753hexers
hexes155123043hex_es
hexing174210513hexing
hexones17299143hexones
hexoses17228893hexoses
hexyl1844463hex_yl
hexyls1933443hexyls
heyday1635143heyday
heydey1634633he_ydey
hide85134653h__ide
hoaxed17378873hoaxed
hodad10311353hodad_
hodads1147963hodads
hoecake1645203hoecake
homage121210603homage
homemade1645153homemade
horde94623053h_orde
humane112812173humane
humate113214443humate
invade10157853invade
irade65618153_irade
jade125325453__jade
jehad1637683jehad_
jehads1735833jehads
lade56345993__lade
lead56038853le_ad_
leaded84221543le_aded
leaden74515223le_aden
leader74824653le_ader
leads66028493le_ads
leady95618603le_ady
lease55230263le_ase
leave84723723le_ave
legate72917453legate
lexeme1536493lexeme
luxate1338083luxate
made75440253__made
mead75531603me_ad_
meads85425323me_ads
menace103216943menace
menad85918983menad_
menads95514383menads
menage93216543menage
merde84320123me_rde
metage93114453metage
metate82720533metate
negate72915573negate
noyade1036423noyade
oxide131210963_oxide
parade94720643parade
peace95026083pe_ace
peage84723573pe_age
pease75231113pe_ase
pedate93117763pedate
pelage9515363pelage
pervade1337023pervade
pesades10310903pesades
phenate12412203phenate
pomade113611333pomade
prebade12310283prebade
prefade1339013prefade
premade12311443premade
read55942533re_ad_
readd74617133re_add
reader73628293re_ader
reads64835273re_ads
ready94821503re_ady
reave84528023re_ave
rebate84424113rebate
recane83022873recane
recede95515533recede
recode93618713recode
redate74124683redate
rede55037683re__de
reface113616353reface
regale74821453regale
regave104713383regave
regrade92612033regrade
relace83122153relace
relate64033633relate
remake124016113remake
remate84428683remate
rename82718813rename
repave114813873repave
resale64025543resale
reside74224933reside
respade1039573respade
retake104718533retake
retape83917683retape
rewake135218463rewake
rexine134719443rexine
sade55544483__sade
secede93311993secede
sedate73019813sedate
senate63725173senate
serape84818413serape
sesame8311013sesame
setae56026223seta_e
sewage10310733sewage
sexed136618543sexed_
shade95125583_shade
sheave124514003she_ave
spade84423323_spade
stade64825303_stade
tease55428713te_ase
telae54323293tela_e
tenace82715693tenace
texas126514933texa_s
texases1437573texases
thecae11299653theca_e
thecate123210023thecate
thenage11107843thenage
tirade7311693tirade
trade65026043_trade
tsade64311123_tsade
unlade72714153unlade
unmade92911063unmade
velate93720143velate
venae85920983vena_e
vexed165713113vexed_
wade85237073__wade
weave115218533we_ave

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 Filter1786911127160.390458182.1
2DLD Change Limit1127163565.53020382.6
3Display Results3563560.1103236.4
 (SQL Overall)1786913566.03029633.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.