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

116 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
strumming145441(None) 
scrumming1654021scrumming
stumming13347671st_umming
drumming14265782_drumming
scramming1634882scramming
scumming15256792s_cumming
slumming13278382s_lumming
stemming13408202st_emming
streaming12239652streaming
strunting1037872strunting
strutting1037002strutting
stumping13289082st_umping
summing122912382s__umming
thrumming1742902thrumming
tramming13279342_tramming
trimming13318652_trimming
trumping13308732_trumping
brimming15196623_brimming
bumming143410783__bumming
chumming18366203_chumming
cramming15339433_cramming
crumbing15267813_crumbing
crumping15319903_crumping
degumming1643133degumming
dramming14347563_dramming
grumping14266903_grumping
gumming133810193__gumming
humming153310673__humming
mumming114010023__mumming
primming15268173_primming
ramming123115063__ramming
retrimming1544263retrimming
rimming123411073__rimming
scamming15328543s_camming
screaming14217823screaming
scrimping1634953scrimping
scrubbing1633933scrubbing
scrummaging1951143scrummaging
scrupling1435193scrupling
shamming16289413s_hamming
shimming16278253s_himming
shlumping1733373shlumping
shrimping1734063shrimping
shrugging1533703shrugging
siruping1136503siru_ping
skimming17286273s_kimming
slamming133310003s_lamming
slimming13288093s_limming
slumping13359973s_lumping
spamming15317603s_pamming
sprucing1336893spru_cing
spuming1248523s_pu_ming
stamping133310963st_amping
steaming114013213st_eaming
stimying1437503st_imying
stomping13309763st_omping
storming11209423st_orming
stounding1136233stounding
strafing122111193str_afing
straining10410563straining
stranding1149653stranding
strapping1436993strapping
strawing122411623str_awing
straying122912693str_aying
streaking142010323streaking
streamings13185163streamings
streeking14217453streeking
streeling10189483streeling
stressing1038333stressing
strewing12289843str_ewing
striating10914193striating
striding102713603str_iding
striking133012233str_iking
string75327563str___ing
stringing1139753stringing
striping112612523str_iping
stripling1257783stripling
stripping1436493stripping
striving122611393str_iving
stroking132610943str_oking
strolling10238793strolling
stropping1436933stropping
strouding1136373strouding
strowing122310563str_owing
stroying122410593str_oying
struggling1342503struggling
strummed1344473strumm_ed
strummer1234783strumm_er
strummers1333693strummers
strung75213023stru___ng
stubbing13237453st_ubbing
studding1136703st_udding
studying1335553st_udying
stuffing15247843st_uffing
stumbling1435003st_umbling
stunning9298463st_unning
stunting92811503st_unting
stymying1733963st_ymying
surnaming1245143surnaming
swimming16316323s_wimming
syruping1434253syru_ping
thumbing16245513_thumbing
thumping16296713_thumping
tomming12359243_t_omming
tramping132711273_tramping
trimmings14254453_trimmings
tromping13319593_tromping
trucing103211843_tru_cing
trucking153310163_trucking
trudging11266443_trudging
trueing83410183_tru_eing
truing73913933_tru__ing
trussing9268653_trussing
trusting93411653_trusting
tumping123114243_t_umping
untrimming1543583untrimming

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.1561145455.1
2DLD Change Limit1486411167.56319653.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.76523012.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.