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

264 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
ronyon930913(None) 
ronion63315641ronion
ronyons10258431ronyons
anyon85615222_anyon
bonbon10310072bonbon
canyon114512032canyon
donjon1436462donjon
fronton1037202fronton
gonion73612832gonion
onion54320972_onion
pinyon11459762pinyon
ponton83217642ponton
rayon83815702r_ayon
rondo65218372rondo_
rondos74616732rondos
ronions73313342ronions
toyon86715672to_yon
wonton93410962wonton
amnion84812053amnion
ancon75718233_ancon
anion55028813_anion
anon46134853_an_on
anyone94612733_anyone
anyons94513503_anyons
banyan1139483banyan
baryon111211613baryon
bolson8410683bolson
bonbons1139333bonbons
bongo85720943bongo_
bongos95316653bongos
bony96732083bony__
boon67142173bo__on
boron76727143bo_ron
boson76019733bo_son
boston8513043boston
bouton8311533bouton
boyo96923843bo_yo_
boyos105418283bo_yos
bronco10179493bronco_
broncos11188073broncos
bunion83111313bunion
cannon84514443cannon
canon74725303can_on
canton85722993canton
canyons124511593canyons
chronon1237353chron_on
cocoon10312263cocoon
codon86522853co_don
cogon89120903co_gon
colon78630193co_lon
common12310803common
condo85322593condo_
condom114215363condom
condone102616293condone
condor94616973condor
condos94322333condos
congo85623133congo_
congos94219883congos
congou94313243congou
conin76232723con_in
conjoin1638203conjoin
conn66229133con__n
consol82614113consol
conto76027173conto_
contos84923233contos
convoy14348543convoy
cony96537833cony__
coon67248943co__on
cordon95017293cordon
cotton8312993cotton
coupon102810993coupon
crayon114110003crayon
crony105918673crony__
croon75522783cro__on
croton84415453cro_ton
crouton947133crouton
doblon938013doblon
dobson936593dobson
donjons1536733donjons
donor64418193don_or
doyen95014413do_yen
dromon939363dro_mon
drongo836793drongo_
drongos935493drongos
eonian6311833eonian
erosion7311113erosion
fanion94514323fanion
fanon84619013fan_on
foison948933foison
frontons1136503frontons
gnomon936183gnomon
godson857383godson
gonof95218653gon_of
gonzo15310243gonzo_
goon57236173go__on
gorgon8310243gorgon
grunion835433grunion
honan85319773hon_an
honor85718623hon_or
inion54620183_inion
ionone6313443ion_one
ironman936613ironman
ironmen936453ironmen
irony85015903irony__
johnson1742333johnson
jomon14610083jo_mon
kronen10348913kron_en
kronor10417233kron_or
kroon94514483kro__on
logion76013723logion
logon615922313lo_gon
longan75612363longan
loon47344793lo__on
lotion65716523lotion
minion83416243minion
minyan1138173minyan
monaxon1644913monaxon
mondo85721233mondo_
mondos95217333mondos
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
mono66036723mon_o_
monos75930863mon_os
monsoon938493monsoon
monuron937463monuron
mony96830013mony__
moon67140813mo__on
morion86217733morion
moron76925423mo_ron
motion85217553motion
mouton8410853mouton
neon47026423__neon
ninon55517383nin_on
nonagon847313nonagon
noncom1039683noncom
nonfan948293nonfan
noniron738373noniron
nonman8412363nonman
nonmen8412833nonmen
nonyl849773nony_l
nonyls957853nonyls
noon47134623__noon
notion64516583notion
nylon82910513__nylon
odeon6411483_odeon
onions64016433_onions
oniony9369703_oniony
ono36838033_on_o_
onos46229003_on_os
onto46127663_onto_
onyx1478363_ony_x
orison6411663orison
orlon5415003_orlon
pennon8310643pennon
phonon114012033phon_on
pinion83815893pinion
pinon76024533pin_on
pinyin112710613pinyin
pinyons12299003pinyons
poison8312223poison
polygon1346933polygon
polyol1138713polyol
pompon1238943pompon
pontons93315553pontons
pontoon93010703pontoon
pony96434053pony__
ponying133312123ponying
poon67341263po__on
potion84519573potion
poyou102611523po_you
prenoon9310043prenoon
pronoun939033pronoun
pronto8313993pronto_
propylon1544873propylon
proton84318893pro_ton
prounion1046823prounion
racon75422143r_acon
racoon83814473racoon
radon64620503r_adon
ramson8310463ramson
rancor8810373rancor
randan7315253randan
random92513553random
ransom82410943ransom
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rayons94113343r_ayons
reason62616333reason
reckon123010543reckon
recon75624243r_econ
redon65424883r_edon
region74614903region
renin54830033ren_in
rennin63914033rennin
renown9369983renown
renvoi945863renvoi
reunion737673reunion
rewon86920573r_ewon
rhyton12356113rhyton
ribbon1036533ribbon
roan47234203ro__an
robbin103611183robbin
robin74820283ro_bin
robot7325973ro_bot
rockoon1345653rockoon
rodeo65921093rodeo_
rodeos75314503rodeos
rodman949713rodman
rodmen939713rodmen
roman75424823ro_man
romano84912943romano
romeo73719703romeo_
romeos84013173romeos
rondel73212643rondel
ronnel63310883ronnel
rontgen835173rontgen
rood56733003ro__od
roof75738833ro__of
rook85532033ro__ok
room66235083ro__om
root45655923ro__ot
ropy96323413ropy__
roscoe839763roscoe
rosin55325313ro_sin
rosy76024873rosy__
roto45935053ro_to_
rotor55519733ro_tor
rotos56027883ro_tos
rotten64115433rotten
rouen54920903ro_uen
roven85521973ro_ven
rowan85418733ro_wan
rowen84921153ro_wen
royal85014703ro_yal
rundown1165443rundown
ryot75528563r__yot
solion6616383solion
solon55026133so_lon
soon46240503so__on
sponson935383sponson
tendon7312033tendon
tenon53320513ten_on
tondo69718683tondo_
tondos75115923tondos
tony75635153tony__
toon47740633to__on
toyo76925453to_yo_
toyons95512133to_yons
toyos87519143to_yos
trogon73611753tro_gon
union54519793_union
unwon84512343_unwon
voudon1035873voudon
wanion93213063wanion
wanton94413813wanton
womyn13426363womy_n
wontons103310533wontons
xenon122612453xen_on
yon67348953___yon
youpon11366003youpon
zoon137326983zo__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.1401276364.3
2DLD Change Limit1127162645.34621084.2
3Display Results2642640.0763473.7
 (SQL Overall)1786912645.56232127.1
 
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.