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

80 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
grumpily164346(None) 
frumpily1843321frumpily
glumpily1643591glumpily
bumpily1665652_bumpily
crumply16336092crump_ly
dumpily1566232_dumpily
grimily1336522grim_ily
grubbily1642972grubbily
gruffily1863082gruffily
grumbly15355402grum_bly
grumphy18443622grump_hy
grumpier1334802grumpier
grumping14266902grumping
grumpish1643762grumpish
grumpy14498152grump__y
jumpily2174982_jumpily
lumpily1476562_lumpily
rumply13348572_rump_ly
campily1638273_campily
chummily2042843chummily
clumsily1544003clumsily
creepily1574953creepily
crispily1574693crispily
croupily1544743croupily
crumbly16347523crum_bly
crumping15319903crumping
crumple13368363crump_le
crusily12199093cru_sily
crustily13328173crustily
drippily1643033drippily
droopily1443943droopily
drumly1235703drum__ly
fruitily1445153fruitily
frumpier1534173frumpier
frumpish1843503frumpish
frumpy16466883frump__y
gamily123712183g_am_ily
gaudily1236523gau_dily
gauzily2034393gau_zily
gemmily1534603g_emmily
gluily10308293glu__ily
glumly12356623glum__ly
glumpier1334873glumpier
glumpy14527193glump__y
goutily1137933gou_tily
grassily1236433grassily
greasily1236233greasily
greedily1345183greedily
grimly12459933grim__ly
grittily1244183grittily
groggily1443283groggily
grouchily1842843grouchily
gruffly17413893gru_ffly
grumble12349233grum_ble
grump105115313grump___
grumped13337333grump_ed
grumphie1642763grumphie
grumphies1743653grumphies
grumpiest1435023grumpiest
grumps114510573grump__s
gushily14257823g_ushily
gustily113010903g_ustily
gutsily11267223g_utsily
plumply1634223plump_ly
preppily1444593preppily
promptly1743913promptly
pulpily1436103_pulpily
ropily113312443_r_opily
roupily1246653_roupily
ruddily1236303_ruddily
rumbly134412163_rum_bly
rumple103913013_rump_le
rustily103112993_rustily
ruttily10338613_ruttily
scrimpily1842553scrimpily
scummily1743303scummily
skimpily1963053skimpily
trumpery1533613trumpery
trumping13308733trumping
trustily11257103trustily

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 Filter1786911461620.423422437.4
2DLD Change Limit146162806.62322068.9
3Display Results80800.0332424.2
 (SQL Overall)178691807.07925242.4
 
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.