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

203 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
paragon1031102(None) 
paragons11311501paragons
argon65520592_ar_gon
dragon838842_dragon
jargon1448822jar_gon
martagon1145272martagon
parador103311412parador
parados103816052parados
paradox17358172paradox
paragoge1257152paragoge
paragoned1357062paragoned
paramo102614642paramo_
paramos113213512paramos
parasol939552parasol
parazoan1946552parazoan
pardon94618732par_don
parergon1144392parergon
pargo86723722par_go_
pargos95719042par_gos
parson83817902par_son
parton84720992par_ton
perigon1039852perigon
tarragon944662tarragon
agon56531883___agon
amazon1736823_amazon
apron7318833apr__on
archon11311753_archon
argol65317263_ar_gol
argons75018203_ar_gons
argot67728643_ar_got
arson55118833_ar_son
bargain1079063bargain
baron78131243bar__on
baryon111211613bar_yon
baryton1246003baryton
carabin11313213carabin
caracol11310423caracol
caragana1146273caragana
carageen1155633carageen
caravan1239223caravan
carbon104919043car_bon
cardamon1345553cardamon
cardon94120853car_don
cardoon104813813cardoon
cargo85322073car_go_
cargos94619183car_gos
carrion9312673carrion
carryon1237033carryon
carton84522663car_ton
cartoon94114463cartoon
craton84517193_craton
crayon114110003_crayon
dalapon1044893dalapon
decagon1135863decagon
dragons938383_dragons
dragoon935283_dragoon
estragon944793estragon
farrago1144923farrago_
flagon1037983_flagon
galago838903galago_
galagos938143galagos
garage8314513garag_e
garaged1039253garaged
garages9314113garages
garaging1139043garaging
garcon92912483gar_con
garron73113493gar_ron
gorgon8310243gor_gon
harpoon1238313harpoon
hexagon1843823hexagon
jargons1558203jar_gons
jargony1834493jar_gony
jargoon1545193jargoon
lardon74415063lar_don
lardoon83410373lardoon
largo65319783lar_go_
largos74815063lar_gos
marabou1147493marabou
marathon1346813marathon
margin94016843mar_gin
maroon83118203mar_oon
marron83717543mar_ron
martagons1245123martagons
nonagon847313nonagon
octagon1045243octagon
paction112713963paction
paean77222723paea__n
paeon74819493p__aeon
pagan86121163p__agan
pagod95013683p__agod
paladin101011773paladin
pangen94115913pa_ngen
papadom1466763papadom
papain10313793papa_in
papayan1445303papayan
para65242173para___
parable111819773parable
parabola1246653parabola
parachor1546653parachor
parade94720643para_de
paraded114014263paraded
parader103914863parader
parades104121463parades
parading12313863parading
paradors113411893paradors
paradrop1344603paradrop
parae76335703para__e
paraffin1644903paraffin
parafoil1345973parafoil
paraform1546923paraform
paragoges1347253paragoges
paragoning1445953paragoning
parament12415393parament
paramount1347183paramount
paramour1246083paramour
parang93715513para_ng
parangs104314373parangs
paranoea1048553paranoea
paranoia10410563paranoia
paranoic1249833paranoic
paranoid11311133paranoid
parapet11317643parapet
paraph13311263para_ph
paraphs1439313paraphs
paras76143043para__s
parasang1147333parasang
parashot13410143parashot
parasols1039263parasols
parathion1446173parathion
paravane1348093paravane
parawing14310583parawing
parazoans2045603parazoans
pardons103817623par_dons
pareo74632603par_eo_
pareos87023773par_eos
parge85831853par_g_e
parged104922033par_ged
parges94529543par_ges
parget94529393par_get
parging113318603par_ging
parian83223963par_ian
parlor8312673par_lor
parodoi10267723parodoi
parodos103011753parodos
parol74826273par__ol
parrot8320663par_rot
parsons93516873par_sons
partaken1445553partaken
partan83820563par_tan
partons94620513par_tons
partook1337313partook
parvo107719183par_vo_
parvos116614753par_vos
passion9310883passion
patagia1068783patagia
patron84018043pa_tron
patroon92811973patroon
pavan106518473pava__n
pedagog12113763pedagog
pendragon1352283pendragon
pentagon1146323pentagon
pereion9312043pereion
pereon83517453per_eon
perigons11310083perigons
perron83216623per_ron
person83517873per_son
pharaoh1545023phara_oh
piragua1044643piragua
pirogen1038263pirogen
polaron939843polaron
polygon1346933polygon
portion9615493portion
prao66229023p_ra_o_
praos74923563p_ra_os
prawn105312433p_ra_wn
prion75119993p_r_ion
prison8514023p_rison
progun968783p_rogun
proton84318893p_roton
pyran10514473pyra__n
pyrogen1337353pyrogen
racon75422143__racon
radon64620503__radon
rayon83815703__rayon
sabaton937713sabaton
sabayon1244233sabayon
sacaton938993sacaton
saran53730303sara__n
sargo65424413sar_go_
sargos74318273sar_gos
tardyon1134673tardyon
tarpon82812803tar_pon
tarragons1044473tarragons
tetragon945263tetragon
trigon74513103_trigon
trogon73611753_trogon
virago1046643virago_
viragos1146713viragos
waggon1136393wa_ggon
wagon94312953__wagon
warison1037083warison
yatagan1144133yatagan
zacaton1845633zacaton

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.1561145455.1
2DLD Change Limit1340272038.08016587.5
3Display Results2032030.0633222.2
 (SQL Overall)1786912038.29921531.6
 
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.