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

384 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
trogon7361175(None) 
trigon74513101trigon
trogons83410721trogons
argon65520592ar_gon
brogan9311042brogan
cogon89120902_cogon
croon75522782cro_on
croton84415452croton
dragon838842dragon
dromon939362dromon
gorgon8310242gorgon
isogon7227542isogon
kroon94514482kro_on
logon615922312_logon
progun968782progun
proton84318892proton
thoron94713902thoron
tigon63914442t_igon
toon47740632t_o_on
toyon86715672t_oyon
trigo65716052trigo_
trigons84312092trigons
trigos74214172trigos
triton63914892triton
trog57628212trog__
trogs67022602trog_s
troop76417532tro_op
trooz145016152tro_oz
tropin83316752tropin
aboon74918703abo_on
acrogen1038203acrogen
agon56531883__agon
archon11311753archon
argol65317263ar_gol
argons75018203ar_gons
argot67728653ar_got
arson55118833ar_son
atropin9311583atropin
biogen9310253biogen
bogan87519003_bogan
boon67142173_bo_on
boron76727143_boron
boson76019733_boson
brogans1049663brogans
brogue94211033brogue
broken124011523broken
bromin102615693bromin
bromo95217203bromo_
bromos104213313bromos
broo65129823bro_o_
brood84620243bro_od
brook114717763bro_ok
broom95022213bro_om
broos75126413bro_os
brown105619533bro_wn
chronon1237353chronon
codon86522853_codon
cogons96818113_cogons
colon78630193_colon
coon67248943_co_on
cordon95017293cordon
craton84517193craton
crayon114110003crayon
crepon1039943crepon
crook115217573cro_ok
croons85418423cro_ons
crotons93714373crotons
crouton947133crouton
crown105620083cro_wn
cryogen1345043cryogen
dragons938383dragons
dragoon935283dragoon
drogue8938333drogue
dromond1135473dromond
dromons1038193dromons
drongo836793drongo_
drongos935493drongos
drool65416103dro_ol
droop85814823dro_op
drown95515823dro_wn
epigon937963epigon
ergo56420153er_go_
ergot65422893er_got
erosion7311113erosion
erugo6369853erugo_
erugos7347343erugos
estragon944793estragon
estrogen946573estrogen
exogen1436513exogen
flagon1037983flagon
forgo94418333forgo_
forgone1139343forgone
forgot104318133forgot
frog85624363frog__
froggy1434493froggy
frogman1335873frogman
frogmen1335893frogmen
frogs96220773frog_s
fronton1037203fronton
frown115415973fro_wn
frozen18408443frozen
gnomon936183gnomon
gogo69722833_gogo_
gogos77516523_gogos
googol835843googol
goon57236173_go_on
gorgons938853gorgons
grego7310523grego_
gregos847533gregos
grison7310103grison
groan65618423gro_an
grog65923343grog__
groggy1234803groggy
grogs76319413grog_s
groin65521083gro_in
groom85317983gro_om
grown95317353gro_wn
hogan97817703_hogan
iroko939663iroko_
irokos1037233irokos
iron46728463ir__on
isogone8237913isogone
isogons8217613isogons
isogony11215453isogony
jargon1448823jargon
jargoon1545193jargoon
jomon14610083_jomon
kerogen1236093kerogen
kronen10348913kronen
kronor10417233kronor
krooni10397183kro_oni
kroons103711243kro_ons
lagoon7410483lagoon
logan68123283_logan
login66025003_login
logion76013723_logion
logo57931763_logo_
logoi69715943_logoi
logons79818173_logons
logos67225333_logos
loon47344793_lo_on
lorgnon844423lorgnon
maroon83118203maro_on
moon67140813_mo_on
morgan9311373morgan
morgen9312203morgen
morion86217733morion
moron76925423_moron
neocon836713neocon
nitrogen945823nitrogen
noon47134623_no_on
organ6915393or_gan
orgone71110913or_gone
origan7310693origan
origin7311033origin
orison6411663orison
orlon5415003or_lon
orogeny11107023orogeny
paragon10311023paragon
patroon92811973patro_on
perigon1039853perigon
phonon114012033phonon
photon1111514833photon
pirogen1038263pirogen
poon67341263_po_on
prion75119993pr_ion
prison8514023prison
prog75729003prog__
progeny1389463progeny
progs86624153prog_s
prolan8414693prolan
prolog94212973prolog
prolong10319633prolong
promo95620003promo_
promos105116423promos
pronoun939033pronoun
proof105221533pro_of
propone112716303propone
proso77222413proso_
prosos85718553prosos
protons93118003protons
proven114314773proven
pyrogen1337353pyrogen
racon75422143_racon
radon64620503_radon
rayon83815703_rayon
recon75624243_recon
redon65424883_redon
region74614903_region
rewon86920583_rewon
rigor62714053_rigor
roan47234203_ro_an
robin74820283_robin
robot7325973_robot
roger64521413_roger
rogue66417533_rogue
roman75424823_roman
ronion63315643_ronion
ronyon9309133_ronyon
rood56733003_ro_od
roof75738833_ro_of
rook85532033_ro_ok
room66235083_ro_om
root45655923_ro_ot
rosin55325313_rosin
roto45935053_roto_
rotor55519733_rotor
rotos56027883_rotos
rouen54920903_rouen
roven85521973_roven
rowan85418733_rowan
rowen84921153_rowen
shogun1045713shogun
shoon84022013sho_on
slogan7539223slogan
solon55026133_solon
soon46240503_so_on
sorgo64719723sorgo_
sorgos74514663sorgos
spoon74719443spo_on
stolon64112073stolon
strook10410303stro_ok
strown96812093stro_wn
swoon85014783swo_on
talion6317713talion
talon55824113t_alon
tampon102911233tampon
tango66921173tango_
tangos74216303tangos
tardyon1134673tardyon
tarpon82812803tarpon
tarragon944673tarragon
tauon54816583t_auon
taxon124414663t_axon
teflon937453teflon
telson6310293telson
tendon7312033tendon
tenon53320513t_enon
teopan839353teopan
ternion739493ternion
teston6313303teston
tetragon945273tetragon
thegn95810903theg_n
theogony1543463theogony
tholoi9339233tholoi
tholos94213003tholos
thorn85318703tho_rn
thoro86217873thoro_
thorons104511913thorons
thrown1214911443thro_wn
tiglon737923tiglon
tigons74112263t_igons
tog410255043t_og__
toga57027413t_og_a
togae67020113t_ogae
togas67823003t_ogas
togs57242433t_og_s
togue64816303t_ogue
token95419313t_oken
tolan55124013t_olan
toman75724053t_oman
ton310265103t___on
too38965423t_o_o_
took86531073t_o_ok
tool46735683t_o_ol
toom66532933t_o_om
toons55027533t_o_ons
toot45958883t_o_ot
topo66932403t_opo_
topoi76018353t_opoi
topos75726393t_opos
torchon1237363torchon
torn46044253t_o_rn
toro48045683t_oro_
toros54336193t_oros
torot56139943t_orot
torpor839193torpor
torsion7310803torsion
torso56922143torso_
torsos64815733torsos
torten65314353torten
tortoni738033tortoni
town76928703t_o_wn
toxin124716713t_oxin
toyo76925453t_oyo_
toyons95512133t_oyons
toyos87519143t_oyos
tragi64717173trag_i
tragic93811543tragic
tragopan1144343tragopan
tragus749233tragus
train56529113tr_ain
trapan82412973trapan
treason748763treason
treen55622753tr_een
tremor84210403tremor
trepan82511673trepan
tricorn937963tricorn
tricot8317753tricot
trig55528163trig__
trigly103810943trigly
trigonal946243trigonal
trigs65423063trig_s
trio45233343tr_io_
triol55521363tr_iol
trios55528093tr_ios
tripod9399853tripod
tripos84014923tripos
tritone73613883tritone
tritons73814883tritons
troak95213573tro_ak
troaks104410603troaks
trocar848773trocar
troche113112513troche
trock114817603tro_ck
trocks123614633trocks
trod57627953tr__od
trodden934883trodden
trode65322853tro_de
troika1035493troika
trois57226093tro_is
troke94821053tro_ke
troked114114583troked
trokes104019263trokes
troking123514103troking
troland837543troland
troll54416533tro_ll
trollop944793trollop
trolls64613943trolls
trolly94012363trolly
trombone1245373trombone
tromp95815803tro_mp
trompe105611263trompe
tromps104911703tromps
trona54118953tro_na
tronas63816903tronas
trone55131863tro_ne
trones65629283trones
troops85712783troops
trop66833303tr__op
trope75725803tro_pe
tropes84824353tropes
trophy1438283trophy
tropic103014193tropic
tropine93116653tropine
tropins93116313tropins
troponin1047943troponin
trot46351313tr__ot
troth85622203tro_th
troths95414153troths
trots56629943tro_ts
trotyl9236673trotyl
trough108512023trough
troughs11698683troughs
troupe84812433troupe
trout57332573tro_ut
trouts66116633trouts
trouty95211793trouty
trove85221923tro_ve
trover95014663trover
troves94719113troves
trow78031423tr__ow
trowed104714653trowed
trowel94211463trowel
trowing113413703trowing
trows88826183tro_ws
trowth1277883trowth
troy77429683tr__oy
troys86418613tro_ys
trudgen9357053trudgen
trudgeon10253313trudgeon
trug55720043trug__
trugs65516803trug_s
turgor736863turgor
turion6313163turion
turnon638193turnon
tycoon1136023tycoon
typhon1436673typhon
uropod937263uropod
vroom105312473vro_om
waggon1136393waggon
wagon94312953_wagon
yogin98317743_yogin
zoon137326983_zo_on

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.393454684.5
2DLD Change Limit1127163845.03022408.7
3Display Results3843840.1263047.6
 (SQL Overall)1786913845.54932202.4
 
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.