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

97 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
blazoned204431(None) 
blazoner1944131blazoner
beaconed1336982beaconed
blazed184314712blaz__ed
blazered2035062blazered
blazon1736762blazon__
blazoners2043862blazoners
blazonry2242162blazonry
blazons1836162blazon_s
brazened20134902brazened
emblazoned2452062emblazoned
atoned75417543__atoned
azoted16388593__azoted
balconied1444853balconied
ballonet10314503ballonet
ballooned1245103ballooned
balloted1189043balloted
baloney1237483b_aloney
baned85436353b_a__ned
banned94721343b_a_nned
barned95623583b_a_rned
baronet91022203b_aronet
basined10310003b_asined
bayonet121212213b_ayonet
beaned95621473bea__ned
beckoned1735793beckoned
belabored1443823belabored
bizone1738603b_izone_
bizones1837823b_izones
blabbed11357813bla_bbed
blacked163613373bla_cked
blackened1845273blackened
bladed104717763bla__ded
blamed116017953bla__med
blanched16308603blanched
bland85320453bla__n_d
blanked144011223bla_nked
blared95018243bla__red
blarney12174763bla_rney
blasted104213473bla_sted
blatted104812713bla_tted
blawed124713893bla__wed
blaze165520833blaz__e_
blazer174414023blaz__er
blazes174817353blaz__es
blazing193612393blazin_g
blazoning2144033blazoning
blazonries2153133blazonries
blond85618373bl__on_d
blonde94813293bl__onde
blooded11379803bl_ooded
bloomed12439433bl_oomed
blooped12398543bl_ooped
blowed125016693bl__owed
boned85133243b___oned
braconid1345633braconid
brained103816103bra_ined
branned104311693bra_nned
bravoed13436113bravo_ed
brazed184717083braz__ed
buttoned1137503buttoned
calzone1848623calzone_
calzones1948763calzones
clamored1336953clamored
clarioned1245723clarioned
cloned94518803cl__oned
crayoned1435003crayoned
deaconed1237493deaconed
emblazoner2351843emblazoner
flavone1335523flavone_
flavones1435833flavones
flavored1554583flavored
glazed174711773glaz__ed
halazone2046103halazone_
halazones2146003halazones
labored102810253_labored
ladened979053_ladened
latened8711923_latened
lazed154925843_laz__ed
lazied164610653_laz_ied
masoned1039803_masoned
plafond1344183plafon_d
plained103812233pla_ined
planed94420913pla__ned
planned103810153pla_nned
platooned1244403platooned
razored1736333_razored
reasoned9410733reasoned
rezoned173611163_rezoned
seasoned948113seasoned
slalomed1134283slalomed
taloned8310223_taloned
unatoned939423unatoned
unzoned172310653_unzoned
wagoned1256223_wagoned
weaponed1445493weaponed
zoned154020263___zoned

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 Filter1786911461620.423422437.4
2DLD Change Limit146162977.37319824.0
3Display Results97970.0332939.4
 (SQL Overall)178691977.82922824.2
 
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.