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

328 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
hexone1628923(None) 
hexane16379531hexane
hexones17299141hexones
hexose16267841hexose
axone125918472_axone
begone9512132begone
debone93714782debone
depone93616552depone
exine125518492_exine
exon117116802_exon_
exons125813342_exons
heroine103517482heroine
heron85025502heron_
herons94820542herons
hexade17438902hexade
hexanes17319462hexanes
hexing174210512hexing
hexoses17228882hexoses
hone77549322h__one
ketone105014532ketone
leone55018822le_one
redone74820052redone
rexine134719442rexine
rezone153814782rezone
acetone9310793acetone
aedine73218393aedine
aeon45634613ae_on_
aeons57624653ae_ons
aerobe8412403aerobe
agone65924553_agone
alexine142410543alexine
alone55732963_alone
ancone83916953ancone
anemone9119453anemone
anyone94612733anyone
atone56527983_atone
axon115524303_axon_
axones134614513_axones
axons125517933_axons
become123312593become
before11410153before
behove14207203behove
beigne9148613beigne
belon73924113belon_
belong93411043belong
belons84119413belons
bene66439493be__ne
benne76521123be_nne
beton76022063beton_
betons84919553betons
betony114211583betony
beyond1237073beyond
bizone1738603bizone
bone65949323__bone
bygone1256173bygone
cenote83715843cenote
cetane8315283cetane
chalone12312103chalone
chegoe1237273chego_e
chinone12510153chinone
clone75728163_clone
colone85425003colone
cone67256963__cone
crone75231333_crone
deboned113411633deboned
deboner103110483deboner
debones103315113debones
decane93818873decane
decode104414743decode
define104718143define
demode104013463demode
demon86520313demon_
demons94917723demons
demote94817803demote
dene56643413de__ne
denote74118043denote
deponed113712873deponed
depones103717093depones
depose94215763depose
devon95113683devon_
devons104512253devons
devote104513783devote
dexie134716893dex_ie
done55747913__done
drone65324983_drone
ebon66821103_ebon_
ebons74316093_ebons
ebony104511513_ebony
elope75219343_elope
emote75421193_emote
eon36052083_e_on_
eons46638713_e_ons
epode85114093_epode
erne46727423_e_rne
erode64520993_erode
erose55727273_erose
esne47018793_e_sne
evoke12478853_evoke
evzone1894683evzone
exile126117653_exile
exines135715803_exines
exing136016813_exing
exogen1436513_exogen
exonic153211413_exonic
exonym1844583_exonym
expose1549523_expose
exude134010293_exude
eyne76322463_e_yne
feline94820143feline
felon84619293felon_
felons93615763felons
felony123710323felony
ferine96422583ferine
gemote94613023gemote
gene56237223ge__ne
genome94312193genome
geode7412593ge_ode
gone55639043__gone
halon86124863halon_
halons95720713halons
hambone1439313hambone
haole84820083h_aole
hearse94114273hearse
heaume1137543heaume
heave114521813he_ave
heaven123912603heaven
hebe96424703he__be
heckle153112093heckle
heddle114211163heddle
hedge105317333he_dge
hedonic1339043hedonic
heeze175313483he_eze
heinie92512663heinie
helo75332853helo__
helos84928063helo_s
helot85332683helo_t
helots95217703helots
helve115018093he_lve
heme95034413he__me
hemin103620933hemin_
hemins113417563hemins
hemline12311073hemline
hemoid12313513hemoid
hempen1338963hempen
hempie132410563hempie
hen67555273he__n_
henbane1237353henbane
hence104920043he_nce
henge94819823he_nge
henna84414043he_nna
hens75642573he__ns
hent76656383he__nt
heptane1238363heptane
heptose1237493heptose
here76447103he__re
hereon93914363hereon_
hermae115314473hermae
hern76134893he_rn_
herns84825583he_rns
hero74635783hero__
heroes94923823heroes
heroic113516923heroic
heroin94420593heroin
heroines112916573heroines
heroins103518013heroins
heroize193210963heroize
heronry1346043heronry
heros84930863hero_s
hewing134514243hewing
hewn106719853he_wn_
hex137436173hex___
hexad164910623hex_ad
hexades18378703hexades
hexads17468193hexads
hexagon1843823hexagon_
hexagons1943943hexagons
hexamine2046863hexamine
hexed165615763hex_ed
hexer155116683hex_er
hexerei1764163hexerei
hexers165612753hexers
hexes155123043hex_es
hexosan1744333hexosan
hexosans1844103hexosans
hexyl1844463hex_yl
hexyls1933433hexyls
hipbone1445923hipbone
histone10312843histone
hoe67562723h__o_e
hoke115935933h__oke
hole77553393h__ole
home98042443h__ome
hon67759383h__on_
honed95332263h__oned
honer85332093h__oner
hones88144493h__ones
honey115629913h__oney
hong85833953h__ong
honk116931193h__onk
hons77350783h__ons
hope96639673h__ope
hormone12410503hormone
hose76547243h__ose
hove107132223h__ove
howe106734103h__owe
humane112812173humane
hyenine1336953hyenine
hyponea1546453hyponea
hyson1138693hyson_
hysons1237633hysons
impone103011853impone
intone61115423intone
ionone6313443ionone
irone55126363_irone
jejune1233763jejune
jeon116821443je_on_
jeton124815403jeton_
jetons134512613jetons
kerne94718213ke_rne
ketene106613003ketene
ketones115014503ketones
ketose105711813ketose
krone94018733_krone
legong836963legong
lemon75618183lemon_
lemons84415053lemons
lemony11419553lemony
leones64417723le_ones
lexeme1536493lexeme
lone45849133__lone
melon73922083melon_
melons84117713melons
mesne75116293me_sne
meson74118313meson_
mesons83215843mesons
metope10611123metope
nene45932063ne__ne
neon47026423ne_on_
neoned7311483ne_oned
neons55818683ne_ons
neurone739433neurone
none45743173__none
ochone11311293ochone
one37050913___one
orgone71110913orgone
ozone14310613_ozone
pekoe114612363peko_e
pelon74423213pelon_
penne75423853pe_nne
peon65635243pe_on_
peones83821043pe_ones
peons75327183pe_ons
peony105717563pe_ony
peptone11310763peptone
peyote1139853peyote
phone105621933_phone
pone65747533__pone
prone75332623_prone
pyrone112714473pyrone
rebore86625643rebore
recane83022873recane
recode93618713recode
recon75624243recon_
recons84922993recons
redbone1037973redbone
redon65424883redon_
redons75222183redons
refine95225693refine
reline65434353reline
remote84222603remote
remove116115573remove
repine85627813repine
repose84121413repose
rerose63320843rerose
reshone102414163reshone
resole64624183resole
retene69224273retene
retine66237333retine
retore67630763retore
retune69121953retune
revoke135216243revoke
revote94917453revote
rewoke1339521213rewoke
rewon86920573rewon_
rewore938030153rewore
rewove126420073rewove
rexines144719153rexines
rezoned173611163rezoned
rezones163213943rezones
saxony1636233saxony
scone74621833_scone
second9411153second
seconde1037413seconde
seine55732873se_ine
sene46848053se__ne
serene63522353serene
serine65432673serine
seton55223543seton_
setons64620173setons
setose65114773setose
sexing144313893sexing
sexton133610793sexton_
sextons143710413sextons
shone83725973_shone
sone46649983__sone
stone55431183_stone
taxon124414663taxon_
taxons134211503taxons
telome8311923telome
tenon53320513tenon_
tenoned839363tenoned
tenoner739673tenoner
tenons62916603tenons
terne56426153te_rne
theine94814923the_ine
throne98517603throne
tone46953743__tone
toxine133114123toxine
trone55131863_trone
undone7914253undone
veloce11310133veloce
venene92912523venene
venine93718433venine
venose9310843venose
vexing17479173vexing
xenon122612453xenon_
xenons132710483xenons
zone135231083__zone

Search took 8 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 Limit1127163287.11015853.2
3Display Results3283280.2031615.8
 (SQL Overall)1786913287.45323975.7
 
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.