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

150 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
sputtered1216632(None) 
puttered112611151_puttered
scuttered12166421scuttered
shuttered13156331shuttered
spattered12187651spattered
spluttered13153171spluttered
sputterer11165261sputterer
stuttered10145761stuttered
buttered112712632_buttered
cluttered12185942cluttered
fluttered13185942fluttered
guttered10259172_guttered
muttered112610802_muttered
pattered112714212_pattered
pottered112311662_pottered
putterer10209912_putterer
reuttered1036072reuttered
sauntered1036292sauntered
scattered12197362scattered
shattered13178212shattered
skittered1434632skittered
smattered12186792smattered
splattered13163942splattered
splutterer12132742splutterer
sputter94014052sputter__
sputterers12174582sputterers
sputters104012872sputter_s
sputtery13366472sputter_y
squattered2043262squattered
stutterer9164912stutterer
unuttered1065732unuttered
uttered82712442__uttered
battered113315073_battered
bespattered1681723bespattered
bettered113011843_bettered
bittered112711833_bittered
blattered12198583blattered
blustered12157263blustered
chattered15198003chattered
chittered15166413chittered
chuntered1536663chuntered
clattered12178423clattered
clustered12186613clustered
cottered112511743_cottered
countered12313003countered
fettered12259493_fettered
flattered13188643flattered
flittered13196253flittered
flustered13185883flustered
flutterer12185263flutterer
frittered13205163frittered
gettered10258613_gettered
glittered11195413glittered
jittered16267223_jittered
lettered92910783_lettered
littered92511383_littered
lustered92510613_lustered
mattered112412913_mattered
mustered112511513_mustered
mutterer10218913_mutterer
nattered92011633_nattered
neutered937423neu_tered
paltered113012503_paltered
pattened11299393_pattened
patterer103112183_patterer
patterned1265753_patterned
peltered112510453_peltered
pestered112814973_pestered
petered103314973_p_etered
portered112311553_portered
pothered142311043_pothered
potterer102310263_potterer
puckered1736103_puckered
putted94220253_putt__ed
puttee85919723_putte_e_
puttees93612913_putte_es
putter83921443_putter__
putterers11238363_putterers
putters94219193_putter_s
puttied103811163_putt_ied
saunterer945033saunterer
sauteed8349613sau_te_ed
scatterer11186293scatterer
sceptered1444723sceptered
scouthered1643643scouthered
scunnered1243803scunnered
scuppered1643933scuppered
scutter93512173scutter__
scutters103311023scutter_s
scuttled1134533scutt_led
shatterer12177203shatterer
sheltered1335583sheltered
shuddered1543433shuddered
shutter103712143shutter__
shutters113611353shutter_s
shuttled1234673shutt_led
sintered92213903s_intered
sistered92612803s_istered
skeltered1443873skeltered
slathered13148553slathered
slithered13136623slithered
slubbered14175253slubbered
slumbered14215593slumbered
smatterer11185813smatterer
smothered1545683smothered
smutted1037463smutt__ed
spatted104014143spatt__ed
spatter94016523spatter__
spatters103914703spatter_s
speered103614813sp__eered
sphered133512313sp__hered
spiered104412463sp__iered
spitted103912703spitt__ed
spitter94015183spitter__
spitters104113383spitter_s
splintered1383923splintered
splutter10357443splutter__
splutterers13142163splutterers
splutters11286273splutter_s
spluttery14293623splutter_y
spotted103713143spott__ed
spotter94514883spotter__
spotters104313383spotter_s
spurred103610623spu__rred
spurted103111973spurt__ed
spurter94013003spurter__
spurters103311703spurter_s
sputtering13106463sputtering
steered83615253s__teered
stutter72911463stutter__
stutterers10164303stutterers
stutters83210473stutter_s
suckered1537833s_uckered
suffered1536733s_uffered
summered1338143s_ummered
sundered10312153s_undered
supered10316123s_u_pered
suttee63721543s_utte_e_
suttees74114063s_utte_es
sutured8310373s_u_tured
sweltered1344453sweltered
swithered16135463swithered
tattered92011453_tattered
tittered9239493_tittered
tottered9208703_tottered
twittered1333813twittered
unbuttered1353133unbuttered
utterer71910463__utterer
wuthered15157433_wuthered
yattered12239543_yattered

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.420425454.8
2DLD Change Limit1486411507.17320722.3
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.