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

244 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
estrone741395(None) 
estrones8313321estrones
oestrone849971oestrone
bestrode1147132bestrode
enthrone111110112enthrone
eserine7415902eserine
estrange9488892estrange
estrin6315922estrin_
estrins7315852estrins
estrogen946572estrogen
estrous7712532estrous
oestrones949772oestrones
restrove1138962restrove
stone55431182_st_one
strobe84513812_strobe
strode75215972_strode
stroke105116172_stroke
strong74914882_strong
strove95014792_strove
trone55131862__trone
amarone9311203amarone
astony9510523ast_ony
astride8311973astride
astringe938223astringe
atone56527983_at_one
bestride1138613bestride
bestrow1237243bestro_w
bestrowed1585163bestrowed
bestrown1345193bestrown
bestrows1337043bestrows
cestode1037963cest_ode
cistron9299883cistron_
cistrons102710623cistrons
citrine92514023citrine
citron83112983citron_
citrons92913223citrons
crone75231333__crone
destine83719953dest_ine
destroy1138153destro_y
destroyed1445083destroyed
destroyer1344553destroyer
destroys1236693destroys
dethrone1247563dethrone
dextrine1688253dextrine
dextrose1645363dextrose
drone65324983__drone
earstone848603earst_one
eccrine1137283eccrine
ecotone938583ecotone
elytron1045463elytron_
enrobe86610793e_nrobe
enshrine1147263enshrine
enteron7313333enteron_
enterons8314153enterons
enthroned1396883enthroned
enthrones12910073enthrones
entrance10311323entrance
entrant7318873entrant
entree61817883entr_ee
entropy1247353entropy
entwine1039143entwine
epergne1046143epergne
epigone1057843epigone
erne46727423e__r_ne
erode64520993e__rode
erose55727273e__rose
escarole1045743escarole
escrow1135913escro_w
escrowed1434653escrowed
escrows1235803escrows
eserines8413743eserines
esne47018793es___ne
estate64719763est_ate
esterase849483esterase
esthete1047433esthete
estop74312103est_o_p
estops84011223est_ops
estragon944793estragon_
estragons1044653estragons
estral64716513estr_al
estranged11387663estranged
estranger10447843estranger
estranges10359983estranges
estray95713333estr_ay
estrayed1236393estrayed
estrays10529403estrays
estreat7314813estreat
estriol747553estriol
estriols856253estriols
estrogens1045703estrogens
estrual7367933estrual
estrum81810513estr_um
estrums9208603estrums
estrus61912113estr_us
estruses838483estruses
estuarine944983estuarine
eterne6311723e_terne
ethane94613243e_thane
ethene93312923e_thene
ethyne12407153e_thyne
everyone1444763everyone
evzone1894683e_vzone
externe1438573externe
extranet15412993extranet
extreme1645653extreme
extrorse1544553extrorse
extrude1545013extrude
eyestone1146533eyest_one
felstone1146863felst_one
festoon1037673festoon_
festooned1344303festooned
festoons1136443festoons
gemstone1145843gemst_one
histone10312843hist_one
instroke1245583instroke
inthrone1179473inthrone
intone61115433int_one
intron64215023intron_
introns73515023introns
irone55126363__irone
isogone8237913isogone
isotone7239983isotone
ketone105014533ket_one
keystone1545333keyst_one
keystroke1552283keystroke
krone94018733__krone
ladrone83611873ladrone
latrine7715123latrine
madrone102812663madrone
matron83918313matron_
matrons93517633matrons
mesotron1045383mesotron_
mesotrons1145513mesotrons
minestrone1254453minestrone
natron64116023natron_
natrons73215663natrons
neurone739433neurone
neutron737763neutron_
neutrons838293neutrons
oestrin7312243oestrin_
oestrins8312673oestrins
oestrogen1044443oestrogen
oestrous869923oestrous
ostiole739013ostiole
outdone8311643outdone
outgone8311463outgone
outrode82313423outrode
padrone102512073padrone
patron84018043patron_
patrons93818103patrons
peptone11310763pept_one
pesthole1347553pesthole
petronel1048143petronel
postpone1248693postpone
prone75332623__prone
pyrone112714473_pyrone
reshone102414163res_hone
restoke116113903rest_oke
restore75822973rest_ore
restrike1239673restrike
restring91518783restring
restrive11310923restrive
restroom1047573restroom
restrung9176443restrung
sarode75317513_sarode
sarong73914873_sarong
scone74621833_s_cone
serene63522353_serene
serine65432673_serine
sestine73017923sest_ine
setline7313923setline
seton55223543set_on_
setons64620173set_ons
setose65114773set_ose
shone83725983_s_hone
shrine94920053_shrine
shrove125412233_shrove
sone46649983_s__one
stane55933003_st_ane
stoae55024263_st_oae
stoke94922513_st_oke
stole54928813_st_ole
stoned75923143_st_oned
stoner65823203_st_oner
stones65130033_st_ones
stoney96217353_st_oney
stony85818643_st_ony
stooge73811663_stooge
stope74727243_st_ope
store56333813_st_ore
stove85220253_st_ove
strafe95215983_strafe
strake104017393_strake
strand74514823_strand
strang75718313_strang
strange85416343_strange
striae65422273_striae
stride75420963_stride
strife95318363_strife
strike105619733_strike
string75327563_string
stripe85822443_stripe
strive95020963_strive
strobes93813263_strobes
stroked124613623_stroked
stroker114113523_stroker
strokes114316323_strokes
stroll6311603_stroll
stroma84313073_stroma
stronger9349693_stronger
strook10410303_strook
strop77422243_stro_p
strophe1239143_strophe
strops86220383_strops
stroud7310383_stroud
strow88920573_stro_w
strowed115312143_strowed
strown96812093_strown
strows96718273_strows
stroy87720393_stro_y
stroyed114110863_stroyed
stroyer103510783_stroyer
stroys95914603_stroys
strung75213023_strung
strunt64918913_strunt
styrene10116693_styrene
teston6313303test_on_
testons7313563test_ons
testoon748373testoon_
testoons837323testoons
tetrode839343tetrode
throne98517603_throne
tone46953743__t_one
trine54734603__trine
trode65322853__trode
troke94821053__troke
trona54118953__trona
trones65629283__trones
trope75725803__trope
trove85221923__trove
unthrone11128183unthrone
upstroke1443993upstroke
vitrine102511363vitrine
yestreen1144593yestreen

Search took 9 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.1431249587.4
2DLD Change Limit1340272447.84317088.7
3Display Results2442440.0763210.5
 (SQL Overall)1786912448.06222164.6
 
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.