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

107 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
burnishes143664(None) 
burnished1544921burnished
burnisher1444821burnisher
burnishers1543701burnishers
furnishes1536231furnishes
banishes131812462b_anishes
burnies94017822burni__es
burnish1238622burnish__
burnsides1244232burnsides
furbishes1745242furbishes
furnished1644582furnished
furnisher1544522furnisher
furnishers1643632furnishers
garnishes13198812garnishes
punishes1338112pu_nishes
tarnishes12188892tarnishes
varnishes15207912varnishes
banished14189063b_anished
banisher13169183b_anisher
banishers14258053b_anishers
batfishes1746583batfishes
bernicles1345403bernicles
blandishes1644613blandishes
blemishes1665083blemishes
bluefishes1844313bluefishes
boarfishes1844973boarfishes
bornites10310983borni_tes
boxfishes2444153boxfishes
braises93818873b_rais_es
brandishes1645893brandishes
brashes124518463b_r_ashes
brises84927613b_r_is_es
brisses94314313b_r_isses
bruises93212913b_ruis_es
brunches153710453brun_ches
brushes124014663b_r_ushes
bulrushes1443323bulrushes
bunches144116033bu_n_ches
bunnies94415003bunni__es
burdies104117563burdi__es
burgesses1245513burgesses
buries84633273bur_i__es
burkites1436673burki_tes
burnables1344003burnables
burnie83715413burni__e_
burnings11387623burni_ngs
burnishing1643913burnishing
burnishings1751863burnishings
burnooses1143433burnooses
burnouses1144853burnouses
burses84425513bur__s_es
bushes115226113bu___shes
byrnies12378573byrni__es
corniches1666673corniches
cuishes122810823cu__ishes
danishes121710493_danishes
dervishes1644933dervishes
evanishes1545603evanishes
finishes1438983_finishes
furbished1843773furbished
furbisher1743703furbisher
furbishers1843093furbishers
furnish1337383furnish__
garfishes16167083garfishes
garnished14196143garnished
garnishee13185763garnishee
garnishees14184173garnishees
garnisher13195853garnisher
garnishers14174863garnishers
gurshes112210033gur__shes
knishes1438263__knishes
kurbashes1883523kurbashes
marishes13512553mar_ishes
minishes13310583_minishes
monishes13311483_monishes
mudfishes1844193mudfishes
nourishes12116733nour_ishes
oarfishes15156953oarfishes
ornithes1136423_ornithes
outfishes15118023outfishes
outwishes15126563outwishes
parishes13314753par_ishes
perishes13313753per_ishes
planishes14138523planishes
plenishes1487083plenishes
publishes1645933publishes
punished1436043pu_nished
punisher1335773pu_nisher
punishers1434973pu_nishers
pupfishes1944313pupfishes
qurshes19228573qur__shes
qurushes2034943qur_ushes
refurnishes17102993refurnishes
rubbishes1644303rubbishes
stonishes1247363stonishes
subniches1665153subniches
sunfishes1547033sunfishes
sunrises8310693sunris_es
surffishes1984073surffishes
surmises10310643surmis_es
tarnished13196063tarnished
tundishes1344543tundishes
unwishes14147483_unwishes
vanishes141610753_vanishes
varnished16195603varnished
varnisher15195403varnisher
varnishers16174343varnishers

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.1731032896.0
2DLD Change Limit1486411076.84321721.6
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.06225303.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.