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

89 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
grittily124418(None) 
brittly12165972britt_ly
grimily1336522gri_mily
gristly11187332grist_ly
grittier9316262grittier
gritting10309982gritting
gritty10338402gritt__y
guiltily1243422guiltily
prettily1337282prettily
ritzily1945142_ritzily
ruttily10338612_ruttily
wittily1336172_wittily
artily92814713ar__tily
bristly12178063brist_ly
brittle9168603britt_le
brittlely1442473brittlely
cattily123210853_cattily
chattily1634603chattily
craftily1644783craftily
crispily1574693crispily
crustily13328173crustily
daintily1245523daintily
dirtily1138583_dirtily
dottily1147283_dottily
draftily1534413draftily
drippily1643033drippily
fattily13379463_fattily
feistily1445263feistily
flintily1434893flintily
friskily1834503friskily
fritting123510703fritting
frizzily2253143frizzily
frostily1436693frostily
frothily1745303frothily
fruitily1445143fruitily
giddily1335073g_iddily
gittin72910553g_itti_n
gitting93215703g_itting
glittery12375613glittery
goutily1137933g_outily
grassily1236433grassily
gratify1436113gr_atify
gratuity1244283gratuity
greasily1236233greasily
greatly1137613great_ly
greedily1345183greedily
grifting13299263grifting
grimly12459933gri__mly
grisly104310583gri__sly
gristle8169223grist_le
gristmill1261703gristmill
gritted94110903gritt_ed
gritter83913353gritt_er
gritters94210633gritters
grittiest10176983grittiest
grizzly19354473gri_zzly
groggily1443283groggily
grottier9316673grottier
grotty10389833grott__y
grubbily1642973grubbily
gruffily1863083gruffily
grumpily1643463grumpily
gustily113010903g_ustily
gutsily11267223g_utsily
knottily1543153knottily
mistily122612343_mistily
nattily103610323_nattily
niftily1335753_niftily
nuttily10308633_nuttily
pettily1238173_pettily
pithily1567033_pithily
prettify1644343prettify
pricily142710283pri_cily
prissily1346693prissily
privily15207623pri_vily
rattly94111543_ratt_ly
riskily1436413_riskily
rustily103112993_rustily
shiftily1744553shiftily
smuttily1344273smuttily
snottily1145553snottily
spottily1335153spottily
tattily10409993_tattily
thriftily1842003thriftily
trickily1736233trickily
tritely1039003tri_tely
trustily11257103trustily
wrathily1744773wrathily
writerly1444153writerly

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.436409841.7
2DLD Change Limit146162896.65621959.4
3Display Results89890.0332697.0
 (SQL Overall)178691897.12525079.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.