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

127 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
grummets1327503(None) 
grommets13234661grommets
grummest13286361grummest
grummet12298871grummet_
crumpets14335942crumpets
drummers13316162drummers
glummest13235562glummest
gourmets1144152gourmets
grammes123611322gramme_s
grimmest13286292grimmest
grommet12268452grommet_
grumes94415552gru_me_s
grummer12338782grumme_r
grummeted1552152grummeted
gummers123712202g_ummers
plummets14304772plummets
rummers113513652_rummers
rummest11279832_rummest
trumpets12315572trumpets
armets84918353ar__mets
armlets94610063ar_mlets
brimmers14287073brimmers
brumes106417073bru_me_s
brunets9419553bru_nets
bummers133712443_bummers
bummest13298623_bummest
crammers14369353crammers
crimmers14298543crimmers
cruets85314953cru__ets
crumbers14338243crumbers
crummies1437643crummies
crummiest1545563crummiest
crumpet133711063crumpet_
crusets93811043cru_sets
cummers133713483_cummers
druggets11313913druggets
drumbeats1442323drumbeats
drummed13306323drumme_d
drummer12407503drumme_r
emmets10349153__emmets
fumets114311813_fu_mets
gammers123214563g_ammers
gimlets10338433g_imlets
gimmes113010903g_imme_s
glimmers13396153glimmers
glumes94516813glu_me_s
glummer12417983glumme_r
glumness1135203glumness
gourmet1059203gourmet_
grammars13345943grammars
grammas12499773gramm_as
gramme114210333gramme__
greets75117423gr__eets
gremmies1355993gremmies
grimes94619033gr_ime_s
grimiest11299823grimiest
grimmer123510093grimme_r
grimness1175993grimness
grivets11357973gr_ivets
grommeted1553163grommeted
groomers11388483groomers
grubbers13316203grubbers
grudgers11266753grudgers
grudges10349423grudge_s
gruelers936173gruelers
gruels73910153gru__els
grues65721963gru__e_s
gruffest1544593gruffest
grumblers14245023grumblers
grumbles13288873grumbles
grume86218163gru_me__
grummeting1642453grummeting
grumous1086613gru_mous
grumped13337333grumpe_d
grumpiest1435023grumpiest
grumps114510573gru_m_ps
grungers10298503grungers
grunges93310403grunge_s
grunters9359033grunters
grunts75511853gru__nts
guglets9369693g_uglets
gullets84013713g_ullets
gumless10228273g_umless
gummas114810513g_umm_as
gummata1244613g_ummata
gummed123811663g_umme_d
gummer114615453g_umme_r
gummiest13269033g_ummiest
gummite1236133g_ummite
gummites1346173g_ummites
gummous1236263g_ummous
gurglets10355543gurglets
gurnets84010793g_urnets
gussets837443g_ussets
hummers143813063_hummers
krimmers16315673krimmers
kummels15234793_kummels
mammets103911113_mammets
maumets11369693mau_mets
mummers103712843_mummers
plummest14276413plummest
plummet13278353plummet_
primmest14226693primmest
pummels13236543_pummels
ramets83517393_r_amets
ramjets1635163_ramjets
rammers113715043_rammers
remeets93712413_remeets
rimmers113812883_rimmers
rumens83611813_ru_mens
rummer104715483_rumme_r
rummies113212793_rummies
rummiest12299353_rummiest
runlets73310773_runlets
russets738163_russets
scummers14277783scummers
slummers12358933slummers
strummers1333693strummers
strumpets1362893strumpets
summers113616503_summers
summits1137983_summits
thrummers1642413thrummers
trammels12295413trammels
trimmers12288913trimmers
trimmest12227023trimmest
trommels12254333trommels
trumpet113810723trumpet_

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 Limit1461621277.39019778.3
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.88922650.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.