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

96 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
shadowed164447(None) 
shadower1544861shadower
beshadowed2051672beshadowed
shaded114518872shad__ed
shadow1337252shadow__
shadowers1644302shadowers
shadowier1642892shadowier
shadows1437192shadow_s
shadowy1744722shadow_y
shallowed1655082shallowed
shamoyed1744042shamoyed
shawed134817232sha__wed
showed135016972sh__owed
adored84714243__adored
avowed1335963__avowed
chawed155214603cha__wed
chowed154914653ch__owed
dadoed9449903_dado_ed
dowed104632613___dowed
endowed1248173_endowed
haded105227623_had__ed
hallowed15179493_hallowed
haloed104717603_halo_ed
harrowed1556263_harrowed
hawed126025423_ha__wed
indowed1237443_indowed
miaowed1333883mia_owed
pshawed16103033psha__wed
reavowed1534673reavowed
saddled103112033s_addled
sallowed12149033sallowed
samoyed1335893s_amoyed
savored1158343s_avored
sawed95628403s_a__wed
scowed124413833s__cowed
seasoned948113seasoned
shacked174015393sha_cked
shackled18277603shackled
shade95125583shad__e_
shader104218763shad__er
shades105924533shad__es
shadier113111153shad_ier
shadoof1446133shado_of
shadoofs1554233shadoofs
shadowbox2551363shadowbox
shadowboxed286673shadowboxed
shadowiest1742803shadowiest
shadowily1982023shadowily
shadowing1744263shadowing
shadowless1742093shadowless
shafted14288813sha_fted
shagged134210133sha_gged
shakoes144510023shako_es
shaled105023953sha__led
shallower1555673shallower
shambled16156153shambled
shamed125120213sha__med
shammed153911423sha_mmed
shammied16265543shammied
shampooed1742943shampooed
shanked153212123sha_nked
shaped125020103sha__ped
shared105829063sha__red
sharked153613913sha_rked
sharped134112053sha_rped
shauled1148793sha_uled
shaved135118383sha__ved
shawled1437773sha_wled
shedded13419063shed_ded
shewed134716183sh__ewed
shmoozed23254363shmoozed
shoed95723013sh__o_ed
shooed103916083sh__ooed
shooled115212663sh_ooled
shored105723653sh__ored
shoved134214283sh__oved
shower124315113sh__ower
shrewed14589853sh_rewed
skidooed1442623skidooed
slalomed1134283slalomed
slowed104617073s__lowed
snawed104813733sna__wed
snowed104613623s__nowed
sorrowed1264833sorrowed
sowed94933863s___owed
spaded103816753spad__ed
spadones1137253spadones
stowed105817203s__towed
strowed115312143s_trowed
sundowned1442683sundowned
swaddled14254963swaddled
swallowed1663583swallowed
thawed13458463tha__wed
unavowed1534783unavowed
widowed1534843_widowed
windowed1635573windowed

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 Filter1786911461620.403443402.0
2DLD Change Limit146162967.19020328.5
3Display Results96960.0303200.0
 (SQL Overall)178691967.62323441.0
 
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.