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

69 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
burnished154492(None) 
burnisher1444821burnisher
burnishes1436641burnishes
furnished1644581furnished
banished14189062b_anished
burnish1238622burnish__
burnishers1543702burnishers
furbished1843772furbished
furnisher1544522furnisher
furnishes1536232furnishes
garnished14196142garnished
punished1436042pu_nished
tarnished13196062tarnished
varnished16195602varnished
banisher13169183b_anisher
banishes131812463b_anishes
blandished1743333blandished
blemished1763783blemished
braised104014803b_rais_ed
brandished1744003brandished
brisked144210003b_r_isked
bruised10389503b_ruis_ed
brunched16317853brun_ched
brushed133811213b_r_ushed
bunched154312413bu_n_ched
buried94822373bur_i__ed
burned95818963burn___ed
burnie83715413burni__e_
burnies94017823burni__es
burnishing1643913burnishing
burnoosed1242323burnoosed
burnsides1244233burnsides
burseed1049503bur__seed
bursted1039423bur__sted
bushed124822383bu___shed
evanished1644323evanished
finished1536483_finished
furbisher1743703furbisher
furbishes1745243furbishes
furnish1337383furnish__
furnishers1643633furnishers
garnishee13185763garnishee
garnisheed15193133garnisheed
garnisher13195853garnisher
garnishes13198813garnishes
kurbashed1982563kurbashed
minished1437873_minished
monished1438133_monished
nourished1374603nour_ished
outfished16116603outfished
outwished1655683outwished
perished14310083per_ished
planished1566123planished
plenished1584953plenished
published1744343published
punisher1335773pu_nisher
punishes1338113pu_nishes
refurnished18102743refurnished
stonished1345593stonished
surmised1136863surmis_ed
tarnishes12188893tarnishes
unfished15218293_unfished
unfurnished1852233unfurnished
unrushed12247573_unrushed
unshed10313773_u_n_shed
unwished15237833_unwished
vanished15207743_vanished
varnisher15195403varnisher
varnishes15207913varnishes

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 Filter1786911486410.423422437.4
2DLD Change Limit148641697.15620771.5
3Display Results69690.0302300.0
 (SQL Overall)178691697.60923484.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.