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

158 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
puggish1426599(None) 
piggish14227701piggish
biggish14247502biggish
boggish14238652boggish
doggish13237532doggish
haggish15207472haggish
hoggish15247592hoggish
jiggish19225942jiggish
loggish12258722loggish
pigfish16217172pigfish
priggish1544682priggish
publish1447912publish
puckish18237212puckish
puggier11309382puggier
puggiest12219222puggiest
pugging122912542pugging
punish111411502pu_nish
punkish16257692punkish
pupfish1735532pupfish
sluggish1344772sluggish
thuggish1642652thuggish
waggish15207072waggish
woggish15276672woggish
aguish1059283_aguish
anguish11117633anguish
buckish18237883buckish
buggier113611343buggier
buggies114613813buggies
buggiest123410363buggiest
bugging123515183bugging
bullish12511193bullish
burnish1238623burnish
cubbish1635803cubbish
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
dogfish15226763dogfish
dreggish1453133dreggish
druggist11163663druggist
dudish1148313du_dish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
english1137953english
fogyish1735363fogyish
fuggier12348963fuggier
fuggiest13228813fuggiest
fuggily1534963fuggily
fugging133912913fugging
fuguist1136073fuguist
furbish1536443furbish
furnish1337383furnish
hagfish17227613hagfish
haggis11209513haggis_
hogfish17257023hogfish
huffish1935713huffish
hugging132710633hugging
hunnish1336163hunnish
jugging172910723jugging
largish1138603largish
longish11229093longish
luggie8318903luggi_e
luggies93011213luggies
lugging104114353lugging
lumpish14127383lumpish
lungfish1543963lungfish
lungis77113023lungis_
mudfish1646263mudfish
muggier11288943muggier
muggiest12228533muggiest
muggily1435103muggily
mugging122711793mugging
muggins11248073muggins
muggs94912323mugg_s_
mulish11311903mu_lish
nunnish1035933nunnish
ogrish1039263_ogrish
outfish132210573outfish
outgush1145133outgush
outwish13289853outwish
paganish1447773paganish
palish114718273p_alish
panfish15229973panfish
parish115022353p_arish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
pegging122811133pegging
perish114619063p_erish
perkish16258823perkish
pettish1238283pettish
piggie103210773piggi_e
piggier113510003piggier
piggies113813483piggies
piggiest12259663piggiest
piggin103111093piggi_n
pigging123614673pigging
piggins113010473piggins
piggishly1942723piggishly
pinfish15319303pinfish
pinkish16279113pinkish
pish96127913p___ish
pixyish2253653pixyish
planish12412053planish
plenish1239943plenish
plugging13306893plugging
plumpish17164733plumpish
polish114916723p_olish
poorish123712303poorish
popish133812113p_opish
priggism1444383priggism
prudish1376563prudish
pubis94616473pu_bis_
pudgier11377723pudgier
pudgiest12297893pudgiest
pudgily1434903pudgily
pugged114314533pugg_ed
pugginess1384963pugginess
puggree11176113puggree
puggries12166383puggries
puggry13374823pugg_ry
puggy124612323pugg__y
pugh106619233pu_g__h
pugilism13144683pugilism
pugilist11136633pugilist
pugs76332773pu_g_s_
pulis74225603pu_lis_
pungs85422223pung_s_
punjis1536693punjis_
puppyish1742453puppyish
purges94421763purges_
purging113314183purging
puris75332023pu_ris_
purism104715063pu_rism
purist85525053pu_rist
purplish1554933purplish
push95526623pu___sh
pygmyish2241343pygmyish
roguish1156833roguish
roughish1545213roughish
rubbish1436303rubbish
rugging102512763rugging
runtish1048693runtish
ruttish1048303ruttish
suggest9310863suggest
sunfish1338883sunfish
tigrish1137573tigrish
toughish1545283toughish
tugging102611233tugging
tundish1137283tundish
unwish1239093_unwish
uppish1336633_uppish
voguish1465203voguish
vuggier12296813vuggier
vuggiest13216923vuggiest
vuggs10579133vugg_s_
youngish1543633youngish

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.1561145455.1
2DLD Change Limit1340271586.53320515.4
3Display Results1581580.0602633.3
 (SQL Overall)1786911586.74926476.7
 
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.