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

198 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
trone5513186(None) 
crone75231331crone
drone65324981drone
irone55126361irone
krone94018731krone
prone75332621prone
throne98517601throne
tone46953741t_one
trine54734601trine
trode65322851trode
troke94821051troke
trona54118951trona
trones65629281trones
trope75725801trope
trove85221921trove
agone65924552agone
alone55732962alone
arene55329412arene
arose55832082arose
atone56527982atone
axone125918472axone
bone65949322_bone
borne77926792borne
brine75132272brine
broke116019782broke
brome94421972brome
bronc91714342bronc
bronze173610922bronze
brose75227032brose
clone75728162clone
cone67256962_cone
crane75331602crane
crones84729242crones
crony105918672crony
crore74922872crore
croze164719452croze
done55747912_done
droned84616862droned
droner74717672droner
drones75023432drones
drove95518062drove
erne46727432er_ne
erode64520992erode
erose55727282erose
estrone7413952estrone
froe75329992fro_e
frond95316342frond
frons86124042frons
front85029222front
frore86218802frore
froze174515652froze
gone55639042_gone
grope84821612grope
grove95219332grove
groyne1037212groyne
hone77549322_hone
iron46728462iron_
ironed74916012ironed
ironer64216452ironer
irones64724012irones
irons55324132irons
irony85015902irony
krona93611792krona
kronen10348912kronen
kroner104612572kroner
leone55018822leone
lone45849132_lone
none45743172_none
one37050912__one
orgone71110912orgone
ozone14310612ozone
phone105621932phone
pone65747532_pone
probe94320812probe
prole74527792prole
prong85218112prong
prose75835122prose
prove104823192prove
prune75119632prune
pyrone112714472pyrone
robe65335642_robe
rode55844312_rode
roe36861082_ro_e
role45851822_role
rope65542912_rope
rose46148902_rose
rote46249022_rote
roue45941742_roue
rove75136982_rove
rune45236302_rune
scone74621832scone
shone83725982shone
sone46649982_sone
stone55431182stone
strobe84513812strobe
strode75215972strode
stroke105116172stroke
strong74914882strong
strove95014792strove
terne56426152terne
thane86122532thane
thine85026862thine
thole85620842thole
thong95014182thong
those85218142those
throe89321422thro_e
throned115412172throned
thrones105715842thrones
throng10539972throng
throve128012392throve
tine45855142t_ine
toe310166852t_o_e
toke86738492t_oke
tole46052902t_ole
tome67543192t_ome
ton310265102t_on_
toned65435342t_oned
toner55336242t_oner
tones56048662t_ones
toney86027412t_oney
tong56434362t_ong
tonne54921432tonne
tons46553052t_ons
tony75635152t_ony
toon47740632toon_
toonie63617992toonie
toons55027532toons
tope65946382t_ope
tore47359322t_ore
torn46044252torn_
torose64317692torose
torse55833332torse
torte55431702torte
tote46643672t_ote
trace75829612trace
trade65026042trade
trance84718762trance
trank96222422trank
tranq145416892tranq
trans54933042trans
trave85223032trave
tree47745812tr_ee
treen55622752treen
trend64817452trend
tribe74420272tribe
trice75127492trice
triene64316382triene
trike95320162trike
trined74920712trined
trines64132562trines
triode75311892triode
triose64715382triose
tripe75425382tripe
trite54730032trite
tritone73613882tritone
triune64210182triune
troak95213572troak
troche113112512troche
trock114817602trock
trod57627952tro_d
trog57628212tro_g
trogs67022602trogs
trois57226092trois
troked114114582troked
trokes104019262trokes
troll54416532troll
tromp95815802tromp
trompe105611262trompe
tronas63816902tronas
troop76417532troop
trooz145016152trooz
trop66833302tro_p
tropes84824352tropes
tropine93116652tropine
trot46351312tro_t
troth85622202troth
trots56629942trots
trounce936822trounce
troupe84812432troupe
trout57332572trout
trover95014662trover
troves94719112troves
trow78031422tro_w
trowed104714652trowed
trowel94211462trowel
trows88826182trows
troy77429682tro_y
troys86418612troys
truce75118692truce
true46725852tr_ue
trunk94713042trunk
tune45635862t_une
twine85822362twine
tyne76325052t_yne
urine55026602urine
wrong94712322wrong
wrote84717482wrote
zone135231082_zone

Search took 4 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.516346300.4
2DLD Change Limit538001982.62620487.4
3Display Results1981980.0762605.3
 (SQL Overall)1786911983.21855528.6
 
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.