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

166 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
shielded133439(None) 
shielder1235181shielder
bielded11226712_bielded
fielded12206812_fielded
shedded13419062sh_edded
shelled113815092sh_elled
shelved14379932sh_elved
shield106212972shiel__d
shielders1334762shielders
shields11538042shield_s
shilled113313622shi_lled
shredded1444062shredded
spieled104811882spiel_ed
wielded12216682_wielded
yielded12184712_yielded
builded1136473bui_lded
chided135113963chi__ded
chield124610213chiel__d
chields13507483chield_s
childbed1742883chi_ldbed
childe124711213chi_lde_
childes134211273chi_ldes
chilled133310933chi_lled
chiseled1435883chisel_ed
chiselled1544223chiselled
fielder11217413_fielder
friended1335033friended
gelded94512113__gelded
gilded94413223_gi_lded
headed114020473_h_eaded
heeded114215763_h_eeded
heeled104018423_heel_ed
heiled104415613_heil_ed
helled104024703_h_elled
helmed124513693_h_elmed
helped124714153_h_elped
helved134313703_h_elved
herded114215643_h_erded
hided105222443_hi__ded
hilled104022223_hi_lled
hilloed113211293_hilloed
hilted104016043_hi_lted
melded104714713__melded
milded104416153_mi_lded
misfielded1742443misfielded
rewelded1335893rewelded
sailed74327763sai_l_ed
scalded11409763s_calded
scended11329873s_cended
scolded11358863s_colded
screeded1235643screeded
seceded11319203sece_ded
seeded84520463s__eeded
seeled73922093s_eel_ed
selfed10310913s__elfed
sended85121233s__ended
shaded114518873sh__aded
shaled105023953sh_al_ed
shauled1148793shaul_ed
shawled1437773shawl_ed
sheafed14388973sh_eafed
sheared114516013sh_eared
sheaved143411633sh_eaved
shedder12339323sh_edder
sheened113511703sh_eened
sheered113515463sh_eered
sheeted113813043sh_eeted
sheetfed1544143sheetfed
sheller103515893sh_eller
shelter103214963sh_elter
shelve124012763sh_elve_
shelver134211063sh_elver
shelves134112093sh_elves
shewed134716183sh_e_wed
shied96125493shi___ed
shiel811023773shiel___
shielding1434553shielding
shieling123512403shieling
shiels95418923shiel__s
shifted14359983shi_fted
shimmed15338583shi_mmed
shimmied16294983shimmied
shined104620783shi__ned
shingled13358323shingled
shinned114310923shi_nned
shinnied12345833shinnied
shipload1464343shipload
shipped153312103shi_pped
shirked153710463shi_rked
shirred113710503shi_rred
shitload1294003shitload
shitted114212053shi_tted
shivered15177103shivered
shlepped1633643shlepped
shoaled113810973shoal_ed
shooled115212663shool_ed
shoulder1234753shoulder
shoveled15195353shovel_ed
shovelled16174413shovelled
shredder1334403shredder
shrewder1534403shrewder
shrewed14589853shre_wed
shrieked16265173shrie_ked
shrieved15276073shrie_ved
shrilled1246863shrilled
shriveled1643153shrivel_ed
shrivelled1742373shrivelled
shrouded1333603shrouded
sided74825953s_i__ded
sidled84215173s_idl_ed
sieged85212713s_ie_ged
sieved104611443s_ie_ved
silked114314813s_i_lked
siloed74615303s_i_loed
silted74020013s_i_lted
skelped1435203s_kelped
skidded1465083ski_dded
skilled123110863ski_lled
skirled12348183skirl_ed
sledded10378873s_ledded
smelled103511863s_melled
smelted10399093s_melted
smiled93716433smi_l_ed
snedded10377393s_nedded
snelled83313053s_nelled
sniveled1255463snivel_ed
snivelled1353993snivelled
soiled73822473soi_l_ed
speeded113310423s_peeded
speeled103712453speel_ed
speiled104412123speil_ed
spelled103714743s_pelled
spieler93111233spiel_er
spiered104412463spie_red
spiled94621993spi_l_ed
spilled103613623spi_lled
spindled12287643spindled
steaded92811673s_teaded
steeled83513223steel_ed
stifled113511093stifl_ed
stilled83314793sti_lled
stilted83511473sti_lted
sueded84014633s_ue_ded
suicided1246033suicided
swelled113211703s_welled
swilled113611833swi_lled
swindled13307623swindled
swirled11308223swirl_ed
swiveled1544163swivel_ed
swivelled1662963swivelled
thieved1434973thie_ved
thirled11328093thirl_ed
threaded1366323threaded
ungelded1147403ungelded
unwelded1337143unwelded
welded114013383__welded
wheedled1633043wheedled
wheeled14318473wheel_ed
whelmed16375163wh_elmed
whelped16355643wh_elped
whidded1634423whi_dded
whiled134514133whi_l_ed
whirled14368043whirl_ed
wielder11197673_wielder
wilded113714503_wi_lded
yielder11175113_yielder

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.420425454.8
2DLD Change Limit1461621666.72021750.3
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.20324807.9
 
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.