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

259 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
blazons183616(None) 
blazon1736761blazon_
amazons1836652amazons
azons146518252__azons
bacons104917582b_acons
ballons93916962ballons
barons85025382b_arons
batons85519422b_atons
bazoos173212622b_azoos
beacons11410732beacons
blains84516372bla_ins
blazers184811682blazers
blazes174817352blaz_es
blazing193612392blazing
blazoned2044312blazoned
blazoner1944132blazoner
blazoners2043862blazoners
blazonry2242162blazonry
brazens18418712brazens
claxons1635802claxons
emblazons2242772emblazons
flacons1238052flacons
flagons1137972flagons
klaxons1833262klaxons
ablations11311513ablations
ablators1069873ablators
aeons57624653__aeons
agons66423783__agons
alamos8415003alamo_s
alanins7315803alanins
alans55636173ala__ns
alations82518893alations
amazon1736833amazon_
axons125517933__axons
azans146516883__azans
azlons154110423__azlons
azon135725053__azon_
baboons113211083baboons
baboos103517013b_aboos
bacon95620593b_acon_
bairns86710873b_airns
balboas113710073balboas
balcony1435853balcony
baleens938473baleens
ballon84117493ballon_
balloons103110523balloons
ballots94116033ballots
banns75321233b_a_nns
bans66555143b_a__ns
barns76335143b_a_rns
baron78131243b_aron_
barong96015823b_arong
barongs105310833b_arongs
barony115915303b_arony
baryons121010473baryons
basins85722763b_asins
basions94213953basions
baton75822423b_aton_
bayous11411153b_ayous
bazars174613113b_azars
bazoo163815673b_azo_o
bazooms20285383b_azooms
beacon10511373beacon_
beanos85516513beano_s
beans75734693bea__ns
beckons15279143beckons
belabors1236403belabors
belons84119413b_elons
benzins1838693benzins
benzoins1945573benzoins
benzols1836673benzols
betons84919553b_etons
bicrons113410473bicrons
billions102211793billions
billons93013363billons
bisons83914373b_isons
bizone1738603b_izone
bizones1837823b_izones
blabs95619633bla__bs
blackens16388103blackens
blacks144914953bla_cks
bladers104214683bladers
blades95221253bla_des
blading113615363blading
bladings12337753bladings
blaffs14426623bla_ffs
blahs105616513bla__hs
blain75421793bla_in_
blamers115314213blamers
blames105121863bla_mes
blaming123515693blaming
blams95023853bla__ms
bland85320453bla__nd
blank115418553bla__nk
blanks124112893bla_nks
blares85021633bla_res
blaring104317113blaring
blasts85116773bla_sts
blatant9310673blatant
blats75132503bla__ts
blauboks1642293blauboks
blawing134012753blawing
blawn106813703bla_wn_
blaws105620463bla__ws
blaze165520833blaz__e
blazed184314713blaz_ed
blazer174414023blaz_er
blazoning2144033blazoning
blazonings2241983blazonings
blazonries2153123blazonries
blobs95620033bl__obs
blocs95219653bl__ocs
blogs85319233bl__ogs
blond85618373bl__ond
blonds95213343bl__onds
bloods94614843bl_oods
blooms104613173bl_ooms
bloops106611343bl_oops
blots75626173bl__ots
blousons1054403blousons
blows105423833bl__ows
bolsons969483bolsons
bonbons1139333bonbons
boons75031913b__oons
borons85520543b_orons
borzois1835833borzois
bosons85016653b_osons
bostons9312903bostons
boutons9310783boutons
bozos165216863b_ozo_s
bradoons1136763bradoons
brains85125473bra_ins
brans75437433bra__ns
bravoes12418533bravoes
bravos114711393bravo_s
brawns115614083bra_wns
brazas175812433braz_as
brazen174812453brazen_
brazers184513943brazers
brazes175522193braz_es
brazils1867753brazils
brazing193715113brazing
bullions101710043bullions
bunions92210473bunions
burtons9310853burtons
buttons9310333buttons
calzone1848623calzone
calzones1948763calzones
canons85522063_canons
capons104119503_capons
celadons1137003celadons
chazans21268123chazans
clamors11710093clamors
clans75031013cla__ns
clarions10310493clarions
claroes93113733claroes
claros84015113claro_s
classons1037703classons
claxon1536583claxon_
clons75228133cl__ons
cratons94316033cratons
crayons12439233crayons
dalapons1145443dalapons
daltons8310403daltons
deacons10310393deacons
diazins1739183diazins
dragons938383dragons
elains64919853ela_ins
elans55527753ela__ns
elations83719123elations
elevons1067573elevons
emblazon2143023emblazon_
etalons739073etalons
falcons1239123falcons
fanons96115213_fanons
flacon1138633flacon_
flagon1037983flagon_
flamens124611063flamens
flans85327973fla__ns
flavins1338543flavins
flavone1335523flavone
flavones1435833flavones
flavors1337293flavors
gallons83015953gallons
gazoos163010223_gazoos
glamors1068113glamors
glans65125833gla__ns
glazers174410043glazers
glazes165315643glaz_es
glazing183611003glazing
glazings19325753glazings
gluons738503gl_uons
halazone2046093halazone
halazones2145993halazones
halons95720713_halons
hazans183411653_hazans
kaons95014853_ka_ons
kazoos19259113_kazoos
khazens2332663khazens
klaxon1733853klaxon_
labors84016413_labors
ladens74516233_ladens
ladrons83813193_ladrons
lagans75717783_lagans
lagoons839253_lagoons
lapins84520683_lapins
lardons83914493_lardons
latens64620213_latens
lauans65113533_lauans
lawns85215423_la_wns
layins93817653_layins
lazars153812393_lazars
lazes145129573_laz_es
lazies154418783_lazies
lazing164821473_lazing
lemons84415053_lemons
lions55923213_l_ions
llanos6108333llano_s
logons79818173_logons
loons55731723_l_oons
macons104017243_macons
masons83916513_masons
menazons1945733menazons
oblations1139373oblations
paeons83915523_paeons
plafond1344183plafond
plafonds1443273plafonds
plains85019593pla_ins
plans75731273pla__ns
plasmons12217663plasmons
platans93413123platans
platens94213983platens
platoons1038683platoons
plazas17409913plaz_as
pleons84213343pl_eons
plutons938343plutons
polarons1039863polarons
racons84319343_racons
radons74118533_radons
rayons94113343_rayons
razors154711663_razors
reasons72514943reasons
salmons93713263salmons
salons63823693_salons
saloons74415323saloons
seasons72614233seasons
slaloms9106543slaloms
talions7314113talions
talons64019443_talons
tauons63412673_tauons
taxons134211503_taxons
ulans54921303ula__ns
wagons103911213_wagons
wazoos18288553_wazoos
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
yapons114411773_yapons
zazens1435833_zazens

Search took 8 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.406440125.6
2DLD Change Limit1340272597.14018771.3
3Display Results2592590.0932784.9
 (SQL Overall)1786912597.63923391.9
 
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.