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

251 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
garnish11161084(None) 
garfish14179201garfish
garish104516921gar_ish
tarnish101611871tarnish
varnish13169531varnish
bairnish1345472bairnish
banish111416042ba_nish
burnish1238622burnish
carlish12312772carlish
danish101513792da_nish
darkish1537942darkish
furnish1337382furnish
garni6315702garni__
garnished14196142garnished
garnishee13185762garnishee
garnisher13195852garnisher
garnishes13198812garnishes
gawkish1835832gawkish
girlish1137192girlish
grayish1437812grayish
largish1138602largish
larkish1439082larkish
mannish121710692mannish
marish114319052mar_ish
oarfish13158612oarfish
parish115022352par_ish
tannish101610572tannish
tartish101512632tartish
vanish121513212va_nish
varnishy17163402varnishy
warmish1538372warmish
agonise83112693agonise
agonist82615403agonist
aguish1059283_aguish
anis45746463_a_nis_
anise55129703_a_nise
apish105116633_a_pish
arise56436433_ar_ise
arnica8310443_arnica
arris56824683_arris_
arsis55722423_arsis_
artist64125543_artist
aspish114810333_aspish
babyish1736513babyish
baldish1339503baldish
barnier93213673barnier
barniest104815053barniest
barning104320353barning
barns76335143barn_s_
batfish1558683batfish
bearish123013273bear_ish
boarfish1635753boarfish
boarish123911913boar_ish
brainish1338813brainish
brandish1469023brandish
brinish1239963brinish
caddish143810133caddish
carnie84421093carni_e
carnies94123963carnies
carnify1555883carnify
carns75937563carn_s_
carwash1536003carwash
catfish1559023catfish
cattish12410723cattish
clannish1345263clannish
crankish1736513crankish
cronish12310863cronish
currish1238353currish
dampish1567663dampish
darning93817333darning
darns66927893darn_s_
dervish1436983dervish
donnish11187633donnish
dronish1138913dronish
dryish1336323_dryish
dwarfish1843783dwarfish
earnest7318733earnest
earning83418213earning
earns55927563earn_s_
evanish1337653evanish
faddish15359003faddish
faintish1446193faintish
fairish1338993fairish
famish14311843fa_mish
farness102912203farness
fattish1359263fattish
finish124613413_finish
furbish1536443furbish
gaddis94211373gaddis_
gadis74825293ga_dis_
gahnite1135973gahnite
gaining94015663gaining
gains65729513gain_s_
gainst74914703gain_st
galosh1038573ga_losh
gamins94420053gamins_
gangs76222573ga_ngs_
ganjah17145503ga_njah
garbing113613273garbing
garbs86321413gar_bs_
garfishes16167083garfishes
garishly1545693gar_ishly
garlic9310043garli_c
garlics1038013garlics
garner73917003garn_er
garners83815983garners
garnet73928413garn_et
garnets84115403garnets
garnisheed15193133garnisheed
garnishees14184173garnishees
garnishers14174863garnishers
garnishing1544573garnishing
garpike1435093garpike
garring93116713garring
garrison943983garrison
gars55750743gar__s_
garth94720223gar__th
garths104111503garths_
gash86833023ga___sh
gayness1136843gayness
gharris11306433gharris_
girning93210693girning
girns64516803girn_s_
girsh95310023gir__sh
gnash9449833g__nash
gnomish1345563gnomish
goatfish1544293goatfish
goatish1139563goatish
goodish1237963goodish
goyish13379013g_oyish
grains74223093grains_
grands84218243grands_
granita82111303granita
granite82017083granite
grans64832543gran_s_
grants73722473grants_
gratis74819243gratis_
grayfish1844483grayfish
greenish1247083greenish
greyish1435173greyish
grinch1238483g_rinch
grins65427223g_rins_
grist65529873g_r_ist
grith95520373g_r_ith
guaranis996863guaranis_
gursh94512333gur__sh
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
harness102413933harness
harpist12312363harpist
harsh116418053har__sh
hashish1238353hashish
hawkish2036553hawkish
hennish1336863hennish
hornist102314823hornist
hunnish1336163hunnish
jadish17319903ja_dish
jargonish2043983jargonish
kaddish16317973kaddish
karns96624143karn_s_
knish1238603__knish
laddish12299723laddish
ladyish14287823ladyish
laris54737463lar_is_
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
maddish14289483maddish
maidish13239553maidish
marsh105320853mar__sh
mawkish1935823mawkish
minish115216303_minish
monish114217593_monish
moonish123311043moonish
nanism8311203na_nism
nannyish1443303nannyish
narcism1188733narcism
narcist9512443narcist
naris55735293nar_is_
nerdish1137103nerdish
nunnish1035933nunnish
oafish121311723oa_fish
ogreish1134673ogreish
ogrish1039263ogr_ish
orangish1246553orangish
ornis54616773_ornis_
paganish1447773paganish
palish114718273pa_lish
panfish15229973panfish
pariah114320583par_iah
paris75145943par_is_
parsonish1446323parsonish
parvis116114803parvis_
parvise124211693parvise
perish114619063per_ish
perkish16258823perkish
planish12412053planish
plenish1239943plenish
prankish1737023prankish
punish111411503_punish
radish103516913ra_dish
raffish1658843raffish
rakish134313963ra_kish
rammish1437563rammish
ranis55235833ra_nis_
rankish14510383rankish
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
revarnish1543933revarnish
saltish10312163saltish
sarins63932623sarins_
saris54544953sar_is_
sawfish1637683sawfish
serfish1348973serfish
sparkish17276973sparkish
starfish1438083starfish
stonish10410653stonish
swainish1444753swainish
swinish1347203swinish
tallish103313583tallish
tanist6324593ta_nist
tarbush1234173tarbush
tarnished13196063tarnished
tarnishes12188893tarnishes
tarns56433953tarn_s_
tonish93415903_tonish
tonnish10149093tonnish
townish13167933townish
uranism91112513uranism
vampish1766283vampish
varnas94212823varnas_
varnished16195603varnished
varnisher15195403varnisher
varnishes15207913varnishes
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warning113717093warning
warns87231003warn_s_
waspish1586923waspish
wearish132310153wear_ish
wennish1336243wennish
winish124212263_winish
wormish1537163wormish
yarning113512953yarning
yarns85621793yarn_s_
zanyish2235903zanyish

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 Filter1786911340270.453394461.4
2DLD Change Limit1340272517.70317399.3
3Display Results2512510.0932698.9
 (SQL Overall)1786912518.24921662.1
 
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.