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

113 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
scrumming165402(None) 
scramming1634881scramming
scumming15256791sc_umming
strumming1454411strumming
chumming18366202_chumming
cramming15339432_cramming
crumbing15267812_crumbing
crumping15319902_crumping
drumming14265782_drumming
scamming15328542sc_amming
screaming14217832screaming
scrimping1634952scrimping
scrubbing1633932scrubbing
scrummaging1951142scrummaging
scrupling1435192scrupling
slumming13278382s_lumming
stumming13347672s_tumming
summing122912382s__umming
thrumming1742902thrumming
brimming15196623_brimming
bumming143410783__bumming
chumping18349063_chumping
clamming15329373_clamming
clumping15319883_clumping
cramping153411853_cramping
creaming133413143_creaming
crimping15299783_crimping
crudding1335723_crudding
cruising112610153_cruising
crumbling1655083_crumbling
crummie1336153_crummi_e
crummier1435603_crummier
crummies1437643_crummies
crumpling1645323_crumpling
crushing143010053_crushing
crusting113612793_crusting
culming123811183_c_ulming
cummin1288783_c_ummin_
cummins1358963_c_ummins
degumming1643133degumming
dramming14347573_dramming
grumping14266903_grumping
gumming133810193__gumming
humming153310673__humming
mumming114010023__mumming
primming15268173_primming
ramming123115063__ramming
rimming123411073__rimming
scamping153510193sc_amping
scheming1636633sc_heming
schlumping2041943schlumping
schussing1542953schussing
scourging1334573scourging
scouring112810853scou_ring
scouting112612753scou_ting
scragging1435273scragging
scrambling1743473scrambling
scraping133310863scr_aping
scrapping1635743scrapping
scrawling15195583scrawling
screaking16228243screaking
screeding1336323screeding
screening1247193screening
screwing14288233scr_ewing
scribing13238183scr_ibing
scrieving1534133scrieving
scrimmaging1951253scrimmaging
scripting1437473scripting
scriving14258763scr_iving
scrolling12187803scrolling
scrooping1446593scrooping
scrouging1335263scrouging
scrounging1443353scrounging
scrummage1641873scrummage
scrummed1554313scrumm_ed
scrunching18163473scrunching
scrutiny1344773scru_tiny
scrying1338663scr__ying
scubaing1335733sc_ubaing
scudding1335673sc_udding
scuffing17287113sc_uffing
sculking15307913sc_ulking
sculling112910993sc_ulling
sculping13298943sc_ulping
scumbling1634423sc_umbling
scummier1445083sc_ummier
scummily1743303sc_ummily
scurrying15183833scurrying
shamming16289413s_hamming
shimming16278253s_himming
shlumping1733373shlumping
shrimping1734063shrimping
shrugging1533703shrugging
siruping1136503siru_ping
skimming17286273s_kimming
slamming133310003s_lamming
slimming13288093s_limming
slumping13359973s_lumping
spamming15317603s_pamming
sprucing1336893spru_cing
spuming1248523s_pu_ming
stemming13408203s_temming
streaming12239653streaming
strunting1037873strunting
strutting1037003strutting
stumping13289083s_tumping
succumbing1951833succumbing
surnaming1245143surnaming
swimming16316323s_wimming
syruping1434253syru_ping
tramming13279343_tramming
trimming13318653_trimming
trumping13308733_trumping

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411137.01621186.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.46823927.6
 
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.