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

70 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
garnished1419614(None) 
garnishee13185761garnishee
garnisheed15193131garnisheed
garnisher13195851garnisher
garnishes13198811garnishes
tarnished13196061tarnished
varnished16195601varnished
banished14189062ba_nished
burnished1544922burnished
furnished1644582furnished
garfishes16167082garfishes
garnish111610842garnish__
garnishees14184172garnishees
garnishers14174862garnishers
tarnishes12188892tarnishes
ungarnished1652352ungarnished
vanished15207742va_nished
varnisher15195402varnisher
varnishes15207912varnishes
agonised10248483agonis_ed
aniseed839403_a_niseed
banisher13169183ba_nisher
banishes131812463ba_nishes
brandished1744003brandished
burnisher1444823burnisher
burnishes1436643burnishes
carnified1547293carnified
danishes121710493da_nishes
evanished1644323evanished
famished1766023fa_mished
finished1536483_finished
furbished1843773furbished
furnisher1544523furnisher
furnishes1536233furnishes
galoshed1334473ga_loshed
ganister9178993ga_nister
gannister1054173gannister
garfish14179203garfish__
garish104516923gar_ish__
garishly1545693gar_ishly
garlicked1772883garlicked
garnered10247113garn_ered
garnishing1544573garnishing
garnishment1774373garnishment
garrisoned1242283garrisoned
gashed116321973ga___shed
gnashed12317523g__nashed
harnessed13186193harnessed
lavished1555133la_vished
marishes13512553mar_ishes
minished1437873_minished
monished1438133_monished
oarfishes15156953oarfishes
parishes13314753par_ishes
perished14310083per_ished
planished1566123planished
plenished1584953plenished
punished1436043_punished
ravished1555713ra_vished
revarnished1852553revarnished
stonished1345593stonished
tarnish101611873tarnish__
untarnished1553083untarnished
unvarnished1852283unvarnished
vanisher14167453va_nisher
vanishes141610753va_nishes
varnish13169533varnish__
varnishers16174343varnishers
varnishy17163403varnish_y
wampished2042803wampished

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.406440125.6
2DLD Change Limit148641707.00021234.4
3Display Results70700.0332121.2
 (SQL Overall)178691707.43924020.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.