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

121 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
sheltered133557(None) 
shelterer1245031shelterer
skeltered1443871skeltered
sweltered1344451sweltered
haltered123112562_haltered
peltered112510452_peltered
philtered1545492philtered
sceptered1444722sceptered
shattered13178202shattered
sheered113515452she__ered
shelter103214962shelter__
shelterers1344342shelterers
shelters113412812shelter_s
shuttered13156332shuttered
weltered12238432_weltered
altered83215743__altered
ashlered1244623ash_l_ered
bettered113011843_bettered
centered112513523_centered
chaptered17176793chaptered
chartered15158393chartered
chattered15197993chattered
checkered2144683checkered
cheered133713293che__ered
chequered2442613chequered
chittered15166413chittered
chuntered1536663chuntered
entered82718883__entered
faltered122810993_faltered
festered122512113_festered
fettered12259493_fettered
filtered12259043_filtered
gettered10258613_gettered
haltere103614713_haltere_
halteres113414603_halteres
heathered16149463_heathered
hectored1436883_hectored
helmeted1435833_helmeted
hollered1237603_hollered
holstered1345883_holstered
lettered92910783_lettered
metered103514013_me_tered
neutered937423_neutered
paltered113012493_paltered
pestered112814973_pestered
petered103314973_pe_tered
philtred14114183philt_red
prealtered1344943prealtered
realtered1037893realtered
reentered1038573reentered
sauntered1036283sauntered
scattered12197353scattered
sceptred1343653scept_red
scuttered12166423scuttered
sectored1138073s_ectored
severed113513863s_e_vered
sewered112911243s_e_wered
shatterer12177203shatterer
sheared114516003she__ared
sheathed1547223sheat_hed
sheened113511703she__ened
sheerer103813843she__erer
sheeted113813043she__eted
sheeter103814913sheeter__
sheeters113111863sheeter_s
sheetfed1544143sheet_fed
shelled113815093shel__led
sheller103515893sheller__
shellers112812583sheller_s
shelterbelt1661443shelterbelt
sheltering1446493sheltering
shelterless1452043shelterless
sheltie10109913shelt_ie_
shelties111111383shelt_ies
shelved14379933shel__ved
shelver134211063shelver__
shelvers14388813shelver_s
shepherd1744373shepher_d
shepherded2052263shepherded
shickered19115723shickered
shimmered1744783shimmered
shivered15177103sh_ivered
shortened1345663shortened
shouldered1542233shouldered
showered1537013sh_owered
shuddered1543433shuddered
silvered12237563s_ilvered
sintered92213903s_intered
sistered92612803s_istered
skelter113610003skelter__
skelters12349373skelter_s
skewered1634213ske_wered
skittered1434633skittered
smattered12186783smattered
smelted10399093smelt__ed
smelter93311913smelter__
smelteries1246163smelteries
smelters103310513smelter_s
smeltery13274963smelter_y
smoldered1343793smoldered
sneakered1443713sneakered
sneered83113973sne__ered
soldered1038153s_oldered
spattered12187643spattered
speered103614813spe__ered
spelter94113703spelter__
spelters103912243spelter_s
sputtered12166323sputtered
steamered1244913steamered
steered83615253ste__ered
stuttered10145763stuttered
svelter10359673svelter__
sweetened1343253sweetened
swelter103711173swelter__
swelters113110193swelter_s
teetered9258303_teetered
telfered1234883_telfered
tentered96412103_tentered
unaltered1037723unaltered
unentered1037573unentered
westered122511873_westered

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 Limit1486411217.09320956.0
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.56223630.1
 
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.