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 “puzzlingly” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
puzzlingly244188(None) 
buzzingly2343252buzz_ingly
dazzlingly2351992dazzlingly
pulingly1436802pu__lingly
puzzling19225392puzzling__
bumblingly2042683bumblingly
bunglingly1743403bunglingly
bustlingly1643063bustlingly
dizzyingly2651333dizzyingly
drizzlingly2451293drizzlingly
fumblingly2142533fumblingly
guzzling18225063guzzling__
humblingly2142543humblingly
muzzling19245733muzzling__
nuzzling17224773nuzzling__
punningly1545153pu_nningly
purblindly1851403purblindly
purringly1545743pu_rringly
pushingly1844733pu_shingly
puzzledly2361173puzzl_edly
amazingly2444144amaz_ingly
appallingly1951514appallingly
appealingly1952244appealingly
bafflingly2242214bafflingly
blazingly2444484blaz_ingly
boilingly1545914_boilingly
bulgingly1644434bu_lgingly
burningly1545044bu_rningly
buzzing18186544buzz_ing__
chillingly1943374chillingly
chucklingly2651414chucklingly
cunningly1545534cu_nningly
cuttingly1545374cu_ttingly
darlingly1436054_darlingly
dazzling1834364dazzling__
drawlingly1843294drawlingly
failingly1636134_failingly
feelingly1645104_feelingly
fizzling20264994fizzling__
fumingly1735744fu__mingly
fuzzily2145074fuzz_i__ly
fuzzing19336184fuzz_ing__
gallingly1435864_gallingly
gigglingly1542004gigglingly
grazingly2344944graz_ingly
growlingly1842844growlingly
gruelingly1543504gruelingly
grumblingly2071534grumblingly
gulpingly1644164gu_lpingly
gushingly1744254gu_shingly
howlingly1944194_howlingly
huzzaing2042434huzzaing__
jumpingly2473864ju_mpingly
juttingly2044584ju_ttingly
killingly1744844_killingly
lollingly1345354_lollingly
lumpingly1784664lu_mpingly
luringly1237324lu__ringly
lurkingly1744574lu_rkingly
middlingly1842324middlingly
mizzling19255444mizzling__
moilingly1545844_moilingly
musingly1436434mu__singly
muzzily2045024muzz_i__ly
nigglingly1642314nigglingly
numbingly1743964nu_mbingly
pantingly1537864p_antingly
passingly1545784p_assingly
piercingly1843234piercingly
pipingly1635704p__ipingly
pityingly1843954p_ityingly
pleadingly1793394pleadingly
pleasingly1644174pleasingly
ploddingly1842344ploddingly
plyingly1734504p__lyingly
posingly1436934p__osingly
pouringly1545954p_ouringly
poutingly1536484p_outingly
pratingly1538374p_ratingly
prattlingly1752244prattlingly
pressingly1646004pressingly
probingly1746014p_robingly
pryingly1735544p__ryingly
publicly1743314pu_bli_cly
puddling13218034puddling__
puddlings14243794puddling_s
puling93621404pu__ling__
pulings103511324pu__ling_s
pulling103821074pu_lling__
pungling12228664pungling__
purfling1467764purfling__
purflings1554094purfling_s
purling103620294pu_rling__
purlings113910284pu_rling_s
purpling1368544purpling__
putzing19359124putz_ing__
quakingly2644224qu_akingly
ramblingly1842974ramblingly
rattlingly1443654rattlingly
scowlingly1942964scowlingly
sidlingly1445094_sidlingly
sizzling17225784sizzling__
smilingly1545744_smilingly
sterlingly1445204sterlingly
stiflingly1743444stiflingly
stumblingly1951434stumblingly
swirlingly1743424swirlingly
tellingly1345434_tellingly
tinglingly1543024tinglingly
undyingly1744164_undyingly
unkingly1637254_u_nkingly
unpuzzling2141574unpuzzling__
urgingly1336734_u_rgingly
wailingly1635524_wailingly
willingly1645404_willingly
zizzling16233924zizzling__

Search took 10 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 Filter1786911614500.436409841.7
2DLD Change Limit1614501168.87618189.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911169.35819095.0
 
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.