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

113 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
garnishes1319881(None) 
garfishes16167081garfishes
garnished14196141garnished
garnishee13185761garnishee
garnishees14184171garnishees
garnisher13195851garnisher
garnishers14174861garnishers
tarnishes12188891tarnishes
varnishes15207911varnishes
banishes131812462ba_nishes
burnishes1436642burnishes
danishes121710492da_nishes
furnishes1536232furnishes
garnish111610842garnish__
garnisheed15193132garnisheed
marishes13512552mar_ishes
oarfishes15156952oarfishes
parishes13314752par_ishes
tarnished13196062tarnished
vanishes141610752va_nishes
varnished16195602varnished
varnisher15195402varnisher
varnishers16174342varnishers
agonises92613163agonis_es
agonistes10266263agonistes
anises64826693_a_nis_es
arises65233803_ar_is_es
arrises71617583_arris_es
artistes83213343_artistes
banished14189063ba_nished
banisher13169183ba_nisher
banishers14258053ba_nishers
batfishes1746583batfishes
boarfishes1844973boarfishes
brandishes1645893brandishes
burnished1544923burnished
burnisher1444823burnisher
burnishers1543703burnishers
carnies94123963carni__es
carnifies1439893carnifies
carwashes1745773carwashes
catfishes1746303catfishes
corniches1666673corniches
dervishes1644933dervishes
evanishes1545603evanishes
famishes1658283fa_mishes
farnesses122310813farnesses
finishes1438983_finishes
furbishes1745243furbishes
furnished1644583furnished
furnisher1544523furnisher
furnishers1643633furnishers
gahnites1235703gahni_tes
galoshes1236893ga_loshes
gamashes1456943ga_mashes
ganaches1437413ga_naches
ganister9178993ga_nister
ganisters10248313ga_nisters
gannister1054173gannister
gannisters1153843gannisters
garfish14179203garfish__
garigues1034953gar_igues
garish104516923gar_ish__
garishly1545693gar_ishly
garishness1445743gar_ishness
garnishing1544573garnishing
garnishment1774373garnishment
garnishments1873333garnishments
garnitures1143183garnitures
garpikes1534373garpi_kes
garrisons1043793garrisons
gashes105725153ga___shes
gaynesses1336563gaynesses
girshes11248293gir__shes
gnashes11419573g__nashes
goatfishes1743933goatfishes
granites92116363grani_tes
grayfishes2043633grayfishes
grinches1436943g_rinches
gurshes112210033gur__shes
hagfishes1945153hagfishes
harnesses121812073harnesses
hashishes1444393hashishes
kaddishes1844093kaddishes
knishes1438263__knishes
lavishes1457403la_vishes
marshes123615373mar__shes
minishes13310583_minishes
monishes13311483_monishes
ornithes1136423_ornithes
panfishes1737593panfishes
parises94827183par_is_es
parvises133911913parvis_es
perishes13313753per_ishes
planishes14138523planishes
plenishes1487083plenishes
punishes1338113_punishes
radishes1269463ra_dishes
ratfishes1546103ratfishes
ravishes1478043ra_vishes
revarnishes1742793revarnishes
sawfishes1845743sawfishes
starfishes1646153starfishes
stonishes1247363stonishes
tarbushes1444883tarbushes
tarnish101611873tarnish__
ungarnished1652353ungarnished
vanished15207743va_nished
vanisher14167453va_nisher
vanishers15186613va_nishers
varnish13169533varnish__
varnishy17163403varnish_y
wampishes1944303wampishes

Search took 7 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.310576422.6
2DLD Change Limit1486411136.36023371.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.71626606.8
 
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.