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

430 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
hexane1637953(None) 
hexade17438901hexade
hexanes17319461hexanes
hexone16289231hexone
cetane8315282cetane
decane93818872decane
exine125518492_exine
heave114521812he_ave
henbane1237352henbane
heptane1238362heptane
hexad164910622hexa_d
hexades18378702hexades
hexads17468192hexads
hexamine2046862hexamine
hexing174210512hexing
hexones17299142hexones
hexose16267842hexose
humane112812172humane
recane83022872recane
rexine134719442rexine
aedine73218393aedine
aerate64830553aerate
alane56135613_alane
alexine142410543alexine
alkane104313323alkane
ane37866943___ane
arcane81216743arcane
axone125918473_axone
bane65250423__bane
bean66443863be_an_
beaned95621473be_aned
beanie83618593be_anie
beano75421553be_ano
beans75734693be_ans
became123213163became
began86319573began_
begaze1838333begaze
begone9512133begone
behave14209013behave
beigne9148613beigne
bename103316073bename
bene66439493be__ne
benne76521123be_nne
berake124216083berake
berate84729023berate
betaine9413783betaine
betake124512703betake
beware11313713beware
bezant17814543bezant
borane84620213borane
butane8313653butane
cane66653113__cane
cease75227653ce_ase
cerate84829463cerate
cetanes9315133cetanes
chelae113614603chela_e
chelate122914893chelate
chicane1489553chicane
coxae146115183coxa_e
crane75331603_crane
dean56039483de_an_
deaned84620453de_aned
deans66131393de_ans
deave95022333de_ave
debase94014473debase
debate94419193debate
debone93714783debone
decade104216163decade
decanes103118913decanes
decant93524223decant
decare93919153decare
dedans85915073dedans
deface123113863deface
defame123212433defame
defang1137753defang
define104718143define
degage92711383degage
degame102713183degame
dekare112811563dekare
delaine8314783delaine
delate73827753delate
demand104314253demand
dene56643413de__ne
deplane10311413deplane
depone93616553depone
derange939813derange
derate74531233derate
desand84812633desand
dewan95718043dewan_
dewans105215143dewans
dexie134716893dex_ie
dioxane1565423dioxane
ease45042333_e_ase
eave75733583_e_ave
elan46734243_elan_
eland65820393_eland
elans55527753_elans
elate55335883_elate
enate54428143_enate
erase54925493_erase
erne46727423_e_rne
esne47018793_e_sne
etape74413703_etape
ethane94613243ethane
evade938183_evade
exact143516933_exact
exalt123018533_exalt
exam132514623_exa_m
examen1538283_examen
examine161510033_examine
exams14199083_exams
exhale1636873_exhale
exile126117653_exile
exines135715803_exines
exing136016813_exing
exon117116803_exon_
exons125813343_exons
expand16236573_expand
expanse16145603_expanse
extant132714753_extant
exude134010293_exude
eyne76322463_e_yne
fane75343563__fane
fease84824873fe_ase
feaze175216313fe_aze
feline94820143feline
female11310553female
ferine96422583ferine
fixate1638733fixate
furane94015493furane
gane55145293__gane
gelant72821673gelant
gelate73421253gelate
gene56237223ge__ne
germane1049663germane
hade85440193h__ade
hae67364003h__a_e
haen76229453h__aen
hake115637843h__ake
hale76052833h__ale
hamate113319823hamate
hame97043133h__ame
hance105424153h__ance
hand86833703h__and
hang85535543h__ang
hank115134133h__ank
hanse85722793h__anse
hant75461583h__ant
hare76255733h__are
hate78450173h__ate
have106137073h__ave
hazan173813613hazan_
hazans183411653hazans
haze164833393h__aze
head87137173he_a_d
headed114020473he_aded
header104422543he_ader
heads95127113he_ads
heady125117263he_ady
heal75645693he_a_l
healed105121443he_aled
healer94221803he_aler
heals85733453he_als
heap96432893he_a_p
heaped124516903he_aped
heaper114119523he_aper
heaps105223223he_aps
heapy135914983he_apy
hear76143883he_a_r
heard95222753he_ard
hearer94323643he_arer
hears86737373he_ars
hearse94114273hearse
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
hectare1238463hectare
heddle114211163heddle
hedge105317333he_dge
heeze175313483he_eze
hegari1039513hegari
heinie92512663heinie
hektare1435503hektare
helve115018093he_lve
hemal104419803hema_l
hematine131614673hematine
heme95034413he__me
hemin103620933hemin_
hemins113417563hemins
hemline12311073hemline
hempen1338963hempen
hempie132410563hempie
hen67555273he__n_
henbanes1336563henbanes
hence104920043he_nce
henge94819823he_nge
henna84414043he_nna
hennaed1135103hennaed
hennas94211803hennas
hens75642573he__ns
hent76656383he__nt
heptanes1339003heptanes
herald10311343herald
herbage1337003herbage
here76447103he__re
hermae115314473hermae
hern76134893he_rn_
herns84825583he_rns
heroine103517483heroine
heron85025503heron_
herons94820543herons
hetman112510603hetman_
hetmans12187593hetmans
hewable15177823hewable
hewing134514243hewing
hewn106719853he_wn_
hex137436173hex___
hexadic2045413hexadic
hexagon1843823hexagon
hexagons1943943hexagons
hexamines2146183hexamines
hexapla1943343hexapla
hexapod2043653hexapod
hexed165615763hex_ed
hexer155116683hex_er
hexerei1764163hexerei
hexers165612753hexers
hexes155123043hex_es
hexosan1744333hexosan_
hexosans1844103hexosans
hexoses17228883hexoses
hexyl1844463hex_yl
hexyls1933433hexyls
hoecake1645203hoecake
hogan97817703hogan_
hogans105914313hogans
hogmane1336333hogmane
homage121210603homage
honan85319773honan_
honans94814503honans
hone77549323h__one
human102716033human_
humaner12257663humaner
humans112312433humans
humate113214443humate
hwan105716893h_wan_
hyenine1336953hyenine
immane1038883immane
inane52820343_inane
insane6314883insane
jane115031473__jane
jean116629283je_an_
jeaned143813463je_aned
jeans126022113je_ans
jejune1233763jejune
kane85133963__kane
kerne94718213ke_rne
ketene106613003ketene
ketone105014533ketone
lane45153323__lane
lean46345243le_an_
leaned73422543le_aned
leaner64022193le_aner
leans55536253le_ans
leant56737783le_ant
lease55230263le_ase
leave84723723le_ave
legate72917453legate
leman75622603leman_
lemans85316393lemans
leone55018823le_one
levant9314493levant
lexeme1536493lexeme
liane54720663_liane
luxate1338083luxate
mane65052013__mane
mean65538083me_an_
meaner84617843me_aner
meanie83718393me_anie
means75831223me_ans
meant76537203me_ant
meany104620473me_any
melange1038363melange
menace103216943menace
menage93216543menage
mesne75116293me_sne
metage93114453metage
metate82720533metate
methane123211793methane
negate72915573negate
nene45932063ne__ne
octane81411633octane
pane64950283__pane
pavane114113443pavane
peace95026083pe_ace
peage84723563pe_age
pean66147173pe_an_
peans75437643pe_ans
pease75231113pe_ase
pecan91919033pecan_
pecans101515833pecans
pedant9319493pedant
pedate93117763pedate
pekan111613973pekan_
pekans121710553pekans
pelage9515363pelage
penance11313443penance
penang92511113penang
pennae84314033pennae
penne75423853pe_nne
pentane9415743pentane
pesade9311103pesade
phenate12412193phenate
phytane1545443phytane
plane74929143_plane
reave84528023re_ave
rebate84424103rebate
recaned102817203recaned
recanes93222263recanes
recant83228683recant
redan66125013redan_
redans75421023redans
redate74124683redate
redone74820053redone
reface113616353reface
refine95225693refine
regale74821453regale
regave104713383regave
rehang1039823rehang
relace83122153relace
reland75920433reland
relate64033633relate
reline65434353reline
remade94316983remade
remake124016113remake
reman75730153reman_
remand95618963remand
remans84823003remans
remate84428683remate
rename82718813rename
repand95316063repand
repanel939963repanel
repave114813873repave
repine85627813repine
reran57329103reran_
resale64025543resale
retake104718533retake
retape83917683retape
retene69224273retene
retine66237333retine
retune69121953retune
rewake135218463rewake
rewan85623663rewan_
rexines144719153rexines
rezone153814783rezone
sane45954333__sane
seance83716683se_ance
secant84023293secant
sedan65620423sedan_
sedans74816093sedans
sedate73019803sedate
seine55732873se_ine
sejant133114483sejant
senate63725143senate
sene46848053se__ne
serape84818413serape
serene63522353serene
serine65432673serine
sesame8311013sesame
setae56026223seta_e
sewage10310733sewage
sewan85921293sewan_
sewans95215903sewans
sexing144313893sexing
sextan13389643sextan_
sextans14349263sextans
sextant142911963sextant
sheave124514003she_ave
shebang1334843shebang
silane62718053silane
skeane104611373skeane
stane55933003_stane
tease55428713te_ase
telae54323293tela_e
tenace82715693tenace
tenant6322473tenant
terne56426153te_rne
terrane72814223terrane
tetany959843tetany
texas126514933texa_s
texases1437573texases
thane86122533_thane
thebaine1355423thebaine
thecae11299653theca_e
thecate123210023thecate
theine94814923the_ine
thenage11107833thenage
tisane6311573tisane
tolane64316583tolane
toxine133114123toxine
urbane82211383urbane
vane75534683__vane
vegan95114153vegan_
vegans103910853vegans
velate93720143velate
venae85920983vena_e
venene92912523venene
venine93718433venine
vexing17479173vexing
wane76344713__wane
wean75734353we_an_
weaned103816153we_aned
weaner93816773we_aner
weans85326743we_ans
weave115218533we_ave
yean75834583ye_an_
yeaned103813903ye_aned
yeans86624883ye_ans
zenana15297983zenana

Search took 6 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.1401276364.3
2DLD Change Limit1127164305.40620850.2
3Display Results4304300.1403071.4
 (SQL Overall)1786914305.68631426.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.