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

175 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
seconded123635(None) 
seconde1037411seconde_
seconder1137181seconder
secondes1138131secondes
decoded123212382deco_ded
recoded113115032reco_ded
reconned113610652reconned
recorded122511062recorded
scended11329872s_cended
scolded11358862s_colded
sconced12359172s_conced
seceded11319202sec_eded
secluded1233662secluded
second9411152secon__d
seconders1236952seconders
secondi1044942second_i
secondly1443662secondly
secondo1044932second_o
seconds1038282second_s
sended85121232se__nded
absconded1543003absconded
accorded14155353accorded
ascended1246513ascended
beaconed1336983beacon_ed
beckoned1735783beckon_ed
beclouded1543503beclouded
becrowded1842923becrowded
belonged1235313belonged
bended105521233be__nded
bonded104719953__bonded
codded114515303__codded
coded95433183__co_ded
coned86040053__con_ed
conked135019113__conked
conned95119703__conned
corded105923353__corded
deaconed1237493deacon_ed
deboned113411633debon_ed
decanted122310493decanted
decided124312423dec_ided
decocted1437683decocted
decode104414743deco_de_
decoder113712293deco_der
decodes113914983deco_des
decoyed14358333deco_yed
defended1437223defended
defunded1435163defunded
demanded13348513demanded
demoded123611123demo_ded
depended1337983depended
deponed113712873depon_ed
desanded11227453desanded
descended1446283descended
desponded1445323desponded
emended11329603_emended
encoded1139033enco_ded
ended74421263_e__nded
eroded84313583_ero_ded
escorted1136703escorted
escoted1038183esco_ted
fended114216913fe__nded
fonded115717043__fonded
fronded12388863_fronded
mended104418683me__nded
neoned7311483ne_on_ed
pended103819013pe__nded
ponded105218773__ponded
precoded1438863preco_ded
rebounded1335463rebounded
recaned102817203recan_ed
recanted112513513recanted
receded112713043rec_eded
reckoned1546953reckon_ed
recoaled113111783recoaled
recoated113416783recoated
recocked17248473recocked
recode93618713reco_de_
recodes102918633reco_des
recoiled113613213recoiled
recoined113614423recoined
recombed1536713recombed
reconfer1337673reconfer
reconvey1655603reconvey
recooked15268243recooked
recopied1339843recopied
recorder11249633recorder
recorked15239853recorked
recounted1238713recounted
recouped13128663recouped
redonned10297103redonned
redounded1235263redounded
refolded1337063refolded
refounded1435473refounded
refunded1336953refunded
relanded102410463relanded
reloaded1059103reloaded
remanded123011323remanded
remended123010393remended
reminded123411523reminded
remolded1237403remolded
rended84524103re__nded
rescinded1335763rescinded
resodded1136353resodded
resounded1136323resounded
responded1336513responded
rewinded13277673rewinded
reworded13228103reworded
rezoned173611163rezon_ed
sanded84920613s__anded
scalded11409763s_calded
scanned104110893s_canned
scanted104114393s_canted
scented102811883s_cented
scoffed16266183s_coffed
scolder103210343s_colder
sconce104711723s_conce_
sconces113811453s_conces
scone74621833s_con_e_
scones84521303s_con_es
scooped124611743s_cooped
scooted103612283s_cooted
scoped115116653s_co_ped
scored94621133s_co_red
scorned10229953s_corned
scoured103811153s_coured
scouted104112033s_couted
scowder13286873s_cowder
scowed124413833s_co_wed
scowled13398193s_cowled
scudded12215933s_cudded
seasoned948113season_ed
secede93311993sec_ede_
seceder10329573sec_eder
secedes103711983sec_edes
secerned1136103secerned
seclude1035233seclude_
secludes1134953secludes
seconal9310073secon_al
seconals1047053seconals
secondary1543193secondary
secondhand1751003secondhand
seconding1337613seconding
secreted1138633secreted
sectioned1246523section_ed
sectored1138063sectored
secund937103secun__d
secundly1443123secundly
secundum1342923secundum
secured1059723sec_ured
seeded84520463se__eded
seined74023063se_in_ed
sender73824413se__nder
sensed73918163se__nsed
serenaded11215933serenaded
shrouded1333603shrouded
snooded94110363s_nooded
sodded94113303s__odded
sonde64622833s__onde_
sonder73623523s__onder
sondes74922873s__ondes
sounded93214463s_ounded
spondee10310593s_pondee
sponged1137953s_ponged
spooned103412443spoon_ed
stoned75923143s_ton_ed
stounded10276213stounded
stranded102710813stranded
swooned11368593swoon_ed
swounded13314563swounded
tended83819483te__nded
tenoned839363tenon_ed
unbonded12299763unbonded
uncoded11312743unco_ded
vended114416353ve__nded
wended113616153we__nded

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.406440125.6
2DLD Change Limit1461621757.40619735.6
3Display Results1751750.0802187.5
 (SQL Overall)1786911757.89222642.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.