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

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

95 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
shelterless145204(None) 
shelterers1344342shelter_ers
shutterless1452132shutterless
centerless1245003_centerless
cheerless1495293che__erless
sewerless1244303s_e_werless
sheerlegs1343293she__erlegs
sheerness1236273she__erness
sheetless1235823she__etless
shelterbelt1661443shelterbelt
shelterbelts176733shelterbelts
sheltered1335573shelter_e_d
shelterer1245033shelter_e_r
shelters113412813shelter___s
shepherdess2051413shepherdess
showerless1642543sh_owerless
smelteries1246163smelterie_s
svelteness1344423svelte_ness
adulteress1142904adulter_ess
beltless10297714_belt__less
butterless1244194_butterless
cheekless1873884che__ekless
cotterless1244034_cotterless
featherless1743914_featherless
fenderless1443534_fenderless
halteres113414604_halter_e_s
haltless11308444_halt__less
hammerless1742374_hammerless
heathless1535594_heat_hless
heatless113011464_heat__less
heedless12278814_he__edless
heelless11257654_he__elless
heirless1146054_he__irless
helleries122611684_hellerie_s
helmless1334274_hel__mless
helpless1335064_hel__pless
heteroses12410784_he_teroses
hiltless11297124_hilt__less
holeless1189364_hol_e_less
leaderless1143434_leaderless
lusterless1043694_lusterless
peerless1037514_pe__erless
peltless10267374_pelt__less
saltless8259344s_alt__less
scaleless1135514scal_e_less
scentless1135114scent__less
seatless83213004s_eat__less
seedless9319514s_e__edless
seeress7311574s_e__er_ess
selfless1135014s_el__fless
senseless945974s_ense_less
sesterces1147874s_esterce_s
shadeless1335734sh_ade_less
shameless1435924sh_ame_less
shapeless1435574sh_ape_less
shatterers13185724shatter_ers
shearlegs1342494she__arlegs
sheerest11310084she__er_est
sheeters113111864sheeter___s
shellers112812584shel___lers
shelter103214964shelter____
sheltering1446494shelter_ing
shelties111111384shelt__ie_s
shelvers14388814shelver___s
shiftless15265304shift__less
shirtdress1441814shirtdr_ess
shirtless12266414shirt__less
shitless11249244sh_it__less
shoeless1137804sh__oe_less
shoreless1236634sh_ore_less
shuttleless1461084shuttleless
skeltered1443874skelter_e_d
skelters12349374skelter___s
sleepless1144554s__leepless
sleeveless1341974sleeve_less
slenderness1243454slenderness
smelters103310514smelter___s
smileless1134694smil_e_less
soleless8910034s_ol_e_less
spelters103912244spelter___s
starless81610844s___tarless
stateless937564s_tate_less
stemless1036654s___temless
sterlets8169274s___terlets
stiltedness1253794stiltedness
styleless1243414styl_e_less
sweaterdress166764sweaterdress
sweltered1344454swelter_e_d
swelters113110194swelter___s
sweltriest1343284swelt_riest
systemless1541994s_ystemless
waterless1238014__waterless
wheatless1534004wheat__less
wheelless1543764whe__elless
whelpless1742054whel__pless

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819958.61017284.4
3Display Results95950.0462065.2
 (SQL Overall)178691959.07919681.8
 
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.