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 “sheltering” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
sheltering144649(None) 
skeltering1545001skeltering
sweltering1445231sweltering
haltering132212002_haltering
peltering122011672_peltering
philtering1646252philtering
sceptering1545792sceptering
shattering1498282shattering
sheering123715102she__ering
shuttering1496562shuttering
weltering13219492_weltering
altering91917113__altering
ashlering1344153ash_l_ering
bettering122212753_bettering
centering122915143_centering
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
checkering2244403checkering
cheering143612703che__ering
chequering2543123chequering
chittering16107183chittering
chuntering1647803chuntering
entering91920053__entering
faltering132211113_faltering
festering132413173_festering
fettering132310513_fettering
filtering13199723_filtering
gettering112310033_gettering
hectoring1538303_hectoring
helmeting1545503_helmeting
hollering1337743_hollering
holstering1447083_holstering
lettering102112073_lettering
metering112915633_me_tering
neutering1038963_neutering
paltering122612893_paltering
pestering122315663_pestering
petering112516813_pe_tering
philtring1544173philt_ring
prealtering1446173prealtering
realtering1139473realtering
reentering1149983reentering
sauntering1137223sauntering
scattering1398013scattering
sceptring1444273scept_ring
scuttering1386633scuttering
sectoring1239583s_ectoring
severing122013853s_e_vering
sewering122411093s_e_wering
shearing123915903she__aring
sheathing1636873sheat_hing
sheening123010803she__ening
sheeting122712833she__eting
shelling123515213shel__ling
shelter103214963shelter___
sheltered1335573shelter_ed
shelterer1245033shelter_er
shelterers1344343shelterers
shelters113412813shelter__s
shelving15278173shel__ving
shepherding2152273shepherding
shimmering1884623shimmering
shivering1637333sh_ivering
shoestring1444173shoest_ring
shortening1445303shortening
shouldering1662343shouldering
showering1646403sh_owering
shuddering1643513shuddering
silvering1337923s_ilvering
sintering101014803s_intering
sistering101213753s_istering
skewering1744633ske_wering
skittering1535393skittering
smattering1397583smattering
smelteries1246163smelteries
smelting11339713smelt__ing
smoldering1474103smoldering
sneering93414503sne__ering
soldering1169033s_oldering
spattering13107793spattering
speering113116323spe__ering
sputtering13106463sputtering
steamering1345443steamering
steering93916793ste__ering
stuttering1196353stuttering
sweetening14134133sweetening
swelteringly1951733swelteringly
teetering10239893_teetering
telfering1336253_telfering
tentering102313203_tentering
westering132112643_westering

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603925.57625215.7
3Display Results92920.0462000.0
 (SQL Overall)178691926.02829643.5
 
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.