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

81 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
blazoner194413(None) 
blazoned2044311blazoned
blazoners2043861blazoners
blazer174414022blaz__er
blazon1736762blazon__
blazonry2242162blazonry
blazons1836162blazon_s
emblazoner2351842emblazoner
almoner949383al_moner
atoner64817193__atoner
ballonet10314503ballonet
balloter1078893balloter
baloney1237483b_aloney
banner84421503b_a_nner
baronet91022203b_aronet
bayonet121212213b_ayonet
beaconed1336983beaconed
beckoner1654963beckoner
bizone1738603b_izone_
bizones1837823b_izones
blabber10418923bla_bber
blackener1754973blackener
blacker154513513bla_cker
bladder11429153bla_dder
blader93618583bla__der
blamer104417143bla__mer
blancher15338633blancher
blander103715163bla_nder
blanker134612023bla_nker
blarney12174763bla_rney
blaster94017303bla_ster
blastier10249493blastier
blather125314203bla_ther
blatter94415653bla_tter
blaze165520833blaz__e_
blazed184314713blaz__ed
blazered2035063blazered
blazers184811683blaz__ers
blazes174817353blaz__es
blazing193612393blazin_g
blazoning2144033blazoning
blazonries2153123blazonries
blonder104011943bl__onder
bloomer11419813bl_oomer
blooper11358533bl_ooper
blower115316573bl__ower
boner75133083b___oner
branner94212373bra_nner
brazened20134903brazened
brazer174917533braz__er
brazier183911473braz_ier
buttoner1036973buttoner
calzone1848623calzone_
calzones1948763calzones
clamorer1236903clamorer
cloner84418093cl__oner
crayoner1344853crayoner
emblazoned2452063emblazoned
emblazoners2451433emblazoners
falconer1346033falconer
flavone1335523flavone_
flavones1435833flavones
flavorer1454553flavorer
glazer164212263glaz__er
glazier17409353glaz_ier
halazone2046093halazone_
halazones2145983halazones
hizzoner1942173hizzoner
laborer9249503_laborer
lanner64920603_la_nner
layover1334433_layover
lazier154214613_laz_ier
loner55431043_l__oner
plainer93811983pla_iner
planer84122653pla__ner
planner93511623pla_nner
reasoner849343reasoner
seasoner857693seasoner
slalomer1045033slalomer
wagoner1136093_wagoner
zoner144520343___zoner

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162818.57617043.1
3Display Results81810.0332454.5
 (SQL Overall)178691818.76520386.9
 
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.