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

206 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
donnish1118763(None) 
tonnish10149091tonnish
danish101513792d_anish
dogfish15226762dogfish
doggish13237532doggish
dollish11610092dollish
doltish11118732doltish
donnas75511322donnas_
donning93512762donning
donnishly1643332donnishly
dovish1338102do_vish
dronish1138912dronish
duncish1335792duncish
hennish1336862hennish
hunnish1336162hunnish
longish11229092longish
mannish121710692mannish
monish114217592mo_nish
monkish1638242monkish
moonish123311042moonish
nunnish1035932nunnish
tannish101610572tannish
tonish93415902to_nish
townish13167932townish
wennish1336242wennish
admonish1446033admonish
adonis7314063ado_nis_
banish111416043_banish
bennis84314803bennis_
blondish1476173blondish
boarish123911913boarish
boggish14238653boggish
bonefish1646283bonefish
bonnes85621453bonnes_
bonnie85314853bonni_e
bonnier94711313bonnier
bonniest10310773bonniest
bonnily1236873bonnily
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
brinish1239963brinish
brownish1645643brownish
burnish1238623burnish
clannish1345263clannish
clownish1643803clownish
cockish1838503cockish
codfish1637163codfish
cognise1059683cognise
coldish1399303coldish
coltish121310933coltish
concise11314473concise
conins84327233conins_
conning103718753conning
connive1238993connive
conns75024233conn_s_
consist9316033consist
coolish12312523coolish
cowfish1836433cowfish
coyish143710393co_yish
cronish12310863cronish
dampish1567663dampish
dandyish1644723dandyish
darkish1537943darkish
deafish1438533deafish
delish105215613d_elish
denning93515173denning
dentist8316743dentist
dervish1436983dervish
diminish14127523diminish
dinning93416553dinning
dish86328333d___ish
dodoism1135893dodoism
doings84913183doings_
donas65926473do_nas_
donees74519493donees_
doneness9411513doneness
dongas84914613dongas_
dongs76525813do_ngs_
donna66215033donn__a
donne65520463donn__e
donned85015743donn_ed
donnee74317063donn_ee
donnees84210363donnees
donnerd9427813donnerd
donnert82815533donnert
donniker1333923donniker
donors75115793donors_
dons56048703do_n_s_
donsie7613643donsi_e
donsy96414683do_n_sy
donuts7410583donuts_
dornick1435273dornick
dowdyish1952833dowdyish
downier11299703downier
downiest122710603downiest
downing123811673downing
downs94918573down_s_
downwash1842623downwash
dryish1336323d_ryish
dudish1148313d_udish
dullish1148743dullish
dumpish15116113dumpish
dunness8298983dunness
dunnest83312263dunnest
dunning93514473dunning
dunnite857333dunnite
duskish1535183duskish
eonism83213533eo_nism
evanish1337653evanish
finfish16268193finfish
finish124613413_finish
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
furnish1337383furnish
garnish111610843garnish
gnomish1345563gnomish
goatish1139563goatish
goodish1237963goodish
goyish13379013go_yish
hogfish17257023hogfish
hoggish15247593hoggish
hornist102314823hornist
hottish13117903hottish
ionise63516943io_nise
jinnis13489053jinnis_
knish1238603__knish
lionfish1454093lionfish
loggish12258733loggish
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
minish115216303_minish
minxish1936213minxish
mobbish1635923mobbish
modish123813543mo_dish
monism104016313mo_nism
monist84324983mo_nist
monkfish2044003monkfish
moonfish1675333moonfish
moorish123311783moorish
mopish134311593mo_pish
nannyish1443303nannyish
ninnyish1442843ninnyish
noirish1037883noirish
noncash1245163noncash
nourish1039703nourish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oldish10169313_oldish
onanism9310133_onanism
onanist7314633_onanist
onrush935343_onrush
ornis54616773_ornis_
owlish1238703_owlish
panfish15229973panfish
pennis84315743pennis_
pinfish15319303pinfish
pinkish16279113pinkish
planish12412053planish
plenish1239943plenish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
punish111411503_punish
punkish16257693punkish
rankish14510383rankish
roguish1156833roguish
rompish1436693rompish
roundish1246253roundish
runtish1048693runtish
softish13127813softish
sonnies7315223sonnies
sottish10129443sottish
sourish10310693sourish
stonish10410653stonish
sunfish1338883sunfish
swinish1347203swinish
tarnish101611873tarnish
tennis64015303tennis_
tennist72813113tennist
thinnish1454883thinnish
toadish1139063toadish
tonnes65320853tonnes_
toyish122911123to_yish
tundish1137283tundish
unwish1239093_unwish
vanish121513213_vanish
varnish13169533varnish
voguish1465203voguish
winish124212263_winish
woggish15276673woggish
wolfish1636933wolfish
womanish1646823womanish
wonning113210793wonning
wormish1537163wormish
yonis85020823yo_nis_
youngish1543633youngish
zanyish2235903zanyish

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272065.95322514.2
3Display Results2062060.0762710.5
 (SQL Overall)1786912066.43527768.6
 
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.