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

144 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
shuttered1315633(None) 
scuttered12166421scuttered
shattered13178201shattered
sputtered12166321sputtered
stuttered10145761stuttered
buttered112712622_buttered
chattered15197992chattered
chittered15166412chittered
chuntered1536662chuntered
cluttered12185942cluttered
fluttered13185942fluttered
guttered10259162_guttered
muttered112610792_muttered
puttered112611142_puttered
reuttered1036072reuttered
sauntered1036282sauntered
scattered12197352scattered
shatterer12177202shatterer
sheltered1335572sheltered
shuddered1543432shuddered
shutter103712142shutter__
shutters113611352shutter_s
shuttled1234672shutt_led
skittered1434632skittered
smattered12186782smattered
spattered12187642spattered
spluttered13153172spluttered
sputterer11165262sputterer
squattered2043252squattered
stutterer9164912stutterer
unuttered1065732unuttered
uttered82712432__uttered
battered113315053_battered
bettered113011843_bettered
bittered112711833_bittered
blattered12198573blattered
blustered12157263blustered
chaptered17176793chaptered
chartered15158393chartered
chatterer14196843chatterer
clattered12178413clattered
clustered12186613clustered
cottered112511733_cottered
countered12313003countered
fettered12259493_fettered
flattered13188633flattered
flittered13196253flittered
flustered13185883flustered
flutterer12185263flutterer
frittered13205163frittered
gettered10258613_gettered
glittered11195413glittered
haltered123112563_haltered
hungered13217053_hungered
hunkered16186923_hunkered
hutted104616333_hutt__ed
jittered16267223_jittered
lettered92910783_lettered
littered92511383_littered
lustered92510603_lustered
mattered112412903_mattered
mustered112511503_mustered
mutterer10218913_mutterer
nattered92011623_nattered
neutered937423neu_tered
pattered112714203_pattered
philtered1545493philtered
pottered112311663_pottered
putterer10209913_putterer
saunterer945033saunterer
sauteed8349613sau_te_ed
scatterer11186293scatterer
sceptered1444723sceptered
scouthered1643643scouthered
scunnered1243803scunnered
scuppered1643933scuppered
scutter93512173scutter__
scutters103311023scutter_s
scuttled1134533scutt_led
shatter103615703shatter__
shatterers13185723shatterers
shatters113313913shatter_s
sheered113515453sh__eered
shelterer1245033shelterer
shickered19115723shickered
shimmered1744783shimmered
shitted114212053shitt__ed
shivered15177103sh_ivered
shortened1345663shortened
shotted113912403shott__ed
shouldered1542233shouldered
showered1537013sh_owered
shunted11339783shunt__ed
shunter103611733shunter__
shunters113210753shunter_s
shuted103913173shu_t__ed
shuteye1343363shu_teye_
shuteyes1443473shu_teyes
shutterbug1671663shutterbug
shuttering1496563shuttering
shutterless1452133shutterless
shuttle1046103shutt_le_
shuttler1164903shutt_ler
shuttlers1254123shuttler_s
shuttles1136553shutt_les
sintered92213903s_intered
sistered92612803s_istered
skeltered1443873skeltered
slathered13148553slathered
slithered13136623slithered
slubbered14175253slubbered
slumbered14215593slumbered
smatterer11185813smatterer
smothered1545683smothered
smutted1037463smutt__ed
splattered13163943splattered
splutterer12132743splutterer
sputter94014053sputter__
sputterers12174583sputterers
sputters104012873sputter_s
sputtery13366473sputter_y
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
tattered92011443_tattered
thundered1444573thundered
tittered9239493_tittered
tottered9208703_tottered
twittered1333813twittered
unbuttered1353133unbuttered
utterer71910463__utterer
wuthered15157433_wuthered
yattered12239533_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.423422437.4
2DLD Change Limit1486411446.90621523.5
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.39224173.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.