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

139 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
scrummed155431(None) 
scrammed1555001scrammed
scummed14347911sc_ummed
strummed1344471strummed
chummed17396442_chummed
crammed143710122_crammed
crumbed14378472_crumbed
crumped144311222_crumped
drummed13306322_drummed
scammed14479542sc_ammed
screamed13277602screamed
scrimped1555312scrimped
scrubbed1533852scrubbed
scrummaged1851522scrummaged
scrupled1335822scrupled
scummer13398752sc_ummer
slummed12359272s_lummed
strummer1234782strummer
stummed12348552s_tummed
summed114014042s__ummed
thrummed1642842thrummed
brimmed14386783_brimmed
bummed134211723__bummed
chumped17379493_chumped
clammed14369963_clammed
clumped143610663_clumped
crammer134010963_crammer
cramped144712183_cramped
creamed123913713_creamed
crimmer133310773_crimmer
crimped143910763_crimped
crudded1235733_crudded
cruised103710213_cruised
crumber13339643_crumber
crumbled15357443_crumbled
crummie1336153_crummie
crummier1435603_crummier
crummies1437643_crummies
crummy15365893_crumm_y
crumpet133711063_crumpet
crumpled15296873_crumpled
crushed134111963_crushed
crusted103712753_crusted
culmed114610593_c_ulmed
cummer124414593_c_ummer
degummed1542603degummed
drammed13378073_drammed
drummer12407503_drummer
grummer12338783_grummer
grummet12298873_grummet
grumped13337333_grumped
gummed123811663__gummed
hummed144812673__hummed
mummed104411553__mummed
primmed14388853_primmed
rammed113117303__rammed
rimmed114812303__rimmed
rummer104715483__rummer
scammer133611973sc_ammer
scamped144711963sc_amped
schemed1577753sc_hemed
schlumped1941953schlumped
schussed1443053schussed
scoured103811153scou_red
scourged1234573scourged
scouted104112033scou_ted
scragged1335823scragged
scrambled16164813scrambled
scramjet1945033scramjet
scraped124313133scr_aped
scrapped1556533scrapped
scrawled1445923scrawled
screaked15246983screaked
screamer12267883screamer
screed95718933scr__eed
screeded1235643screeded
screened1137413screened
screwed135710663scr_ewed
scribed124510643scr_ibed
scried95817303scr__ied
scrieved14366203scrieved
scrimmaged1851663scrimmaged
scrimper1455763scrimper
scripted13117553scripted
scrived134511113scr_ived
scrolled1137053scrolled
scrooped1356403scrooped
scrouged1235383scrouged
scrounged1343143scrounged
scrubber1434123scrubber
scrum95418203scru_m__
scrummage1641873scrummage
scrummages1752053scrummages
scrumming1654023scrumming
scrums104614253scru_m_s
scrunched1744033scrunched
scruple1137193scruple_
scruples1237433scruples
scubaed1236123sc_ubaed
scudded12215933sc_udded
scuffed16298243sc_uffed
sculked14307183sc_ulked
sculled102911693sc_ulled
sculped12398253sc_ulped
scumbled1535053sc_umbled
scummers14277783sc_ummers
scummier1445083sc_ummier
scummy15265223sc_umm_y
scurried11267053scurried
shammed153911423s_hammed
shimmed15338583s_himmed
shlumped1643443shlumped
shrimped1634213shrimped
shrugged1433673shrugged
siruped1036013siru_ped
skimmed16306053s_kimmed
slammed123511103s_lammed
slimmed12368473s_limmed
slummer113711203s_lummer
slumped123710153s_lumped
spammed14348523s_pammed
spruced12307533spru_ced
spumed114711543s_pu_med
stemmed12278153s_temmed
streamed11258903streamed
strumae9368093strumae_
strummers1333693strummers
strumpet1256033strumpet
strunted957243strunted
strutted946343strutted
stumped124210153s_tumped
succumbed1842073succumbed
summer104017713s__ummer
surnamed1135113surnamed
syruped1334543syru_ped
thrummer1542933thrummer
trammed123810713_trammed
trimmed12348933_trimmed
trumped12439713_trumped

Search took 9 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 Limit1461621397.68619016.7
3Display Results1391390.0463021.7
 (SQL Overall)1786911398.15521911.8
 
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.