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 “blazoners” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 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
blazoners204386(None) 
blazoner1944131blazoner_
blazers184811682blaz__ers
blazoned2044312blazone_d
blazonry2242162blazon_ry
blazons1836162blazon__s
emblazoners2451432emblazoners
almoners1068133al_moners
atoners75013953__atoners
ballonets1146723ballonets
balloters1157673balloters
baloneys1334663b_aloneys
banners94018713b_a_nners
baroness101210063b_aroness
baronets101410903b_aronets
bayonets13135583b_ayonets
beckoners1744063beckoners
bizones1837823b_izone_s
blabbers11308153bla_bbers
blackeners1844123blackeners
blackness1735663blackness
bladders12397803bla_dders
bladers104214683bla__ders
blamers115314213bla__mers
blanchers16307433blanchers
blandness1235973blandness
blankness1544673blankness
blarneys13183193bla_rneys
blasters104116143bla_sters
blathers134713793bla_thers
blatters104414093bla_tters
blazer174414023blaz__er_
blazes174817353blaz__e_s
blazon1736763blazon___
blazoning2144033blazoning
blazonings2241983blazonings
blazonries2153123blazonries
bloomers12348823bl_oomers
bloopers12397373bl_oopers
blowers124313593bl__owers
boners84825433b___oners
branners104010923bra_nners
brazers184513943braz__ers
braziers19397193braz_iers
buttoners1145703buttoners
calzones1948763calzone_s
clamorers1345783clamorers
cloners94514823cl__oners
crayoners1444493crayoners
emblazoner2351843emblazoner_
falconers1445323falconers
flavones1435833flavone_s
flavorers1563983flavorers
glazers174410043glaz__ers
glaziers18406563glaz_iers
glaziness1935753glaziness
halazones2145993halazone_s
hizzoners2041633hizzoners
laborers10208383_laborers
lanners73618333_la_nners
layovers1434073_layovers
laziness17239983_laziness
loners64225813_l__oners
planers94517943pla__ners
planners10399933pla_nners
reasoners947113reasoners
seasoners946263seasoners
slalomers1144553slalomers
wagoners1235473_wagoners
zoners155115993___zoners

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 Filter1786911486410.420425454.8
2DLD Change Limit148641708.31317880.5
3Display Results70700.0302333.3
 (SQL Overall)178691708.76320391.5
 
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.