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

282 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
seconds103828(None) 
second9411151second_
seconde1037411seconde
secondes1138131secondes
secondi1044941secondi
secondo1044931secondo
beyonds1335062beyonds
recons84922992recon_s
records105213922records
scends95213002s_cends
scolds95011232s_colds
scones84521302s_cones
secants93413892secants
seconal9310072seconal
seconals1047052seconals
seconded1236352seconded
seconder1137182seconder
seconders1236952seconders
secondly1443662secondly
secund937102secund_
sends65528242se__nds
setons64620172seton_s
absconds1343593absconds
accords1247243accords
aeons57624653ae_on_s
almonds10127953almonds
ancones93116343ancones
ascends10388203ascends
bacons104917583bacon_s
beacons11410733beacon_s
beckons15279143beckon_s
beclouds1345373beclouds
becomes132911963becomes
becrowds1683773becrowds
behinds1335283behinds
beholds1336423beholds
belongs10408223belongs
belons84119413belon_s
bends85628973be__nds
betons84919553beton_s
beyond1237073beyond_
blonds95213343_blonds
bonds86126843__bonds
ceboids1237653ceboids
cods76848103__co_ds
coeds85920163__coeds
colds85726973__colds
condo85322593__condo
condos94322333__condos
cones76457423__cones
conks115525703__conks
conns75024233__conns
cons66057693__con_s
conus76726533__conus
cords86030623__cords
deacons10310393deacon_s
debones103315113debones
decanes103118913decanes
decants103514443decants
decocts1237833decocts
decode104414743deco_de
decodes113914983decodes
decors94017773deco_rs
decos85522123deco__s
decoys123911283deco_ys
defends12358773defends
defunds12376753defunds
demands114311413demands
demons94917723demon_s
depends11348993depends
depones103717093depones
desands94810163desands
descends12266983descends
desponds1246243desponds
devons104512253devon_s
ebons74316093_ebon_s
elands74914773_elands
emends95711433_emends
ends56528523_e__nds
eons46638713_e_on_s
escorts9418403escorts
escots84211743esco_ts
exons125813343_exon_s
fecund1235433fecund_
felons93615763felon_s
fends96324973fe__nds
feods99516853fe_o_ds
fonds95824823__fonds
fronds106412343_fronds
fucoids1335663fucoids
geoids8369843ge_oids
gerunds935183gerunds
herons94820543heron_s
hexones17299143hexones
icones84616383_icones
icons76516493_icon_s
jetons134512613jeton_s
keloids1288663keloids
ketones115014503ketones
legends936073legends
legongs934543legongs
lemons84415053lemon_s
lends65326253le__nds
leones64417723le_ones
macons104017243macon_s
meloids10911453meloids
melons84117713melon_s
mends84927693me__nds
mesons83215843meson_s
mucoids1237423mucoids
neocons936913neocon_s
neons55818683ne_on_s
pecans101515833pecan_s
pends85527193pe__nds
peones83821043pe_ones
peons75327183pe_on_s
percoids1339663percoids
pernods1038483pernods
ponds85323403__ponds
racons84319343racon_s
rebinds104511873rebinds
rebounds1156023rebounds
recanes93222263recanes
recants93217093recants
reckons13269653reckon_s
reclads1049993reclads
recoals94214623recoals
recoats92616643recoats
recocks154711463recocks
recode93618713reco_de
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recombs1336753recombs
recon75624243recon__
recooks134711233recooks
record96117423record_
recorks134813023recorks
recounts1038773recounts
recoups1188843recoups
redons75222183redon_s
redounds1055963redounds
refinds114512123refinds
refolds11298953refolds
refounds1255733refounds
refunds11448623refunds
relands85214883relands
relends84013253relends
reloads8911313reloads
remands104914883remands
remends105013033remends
reminds104614793reminds
remolds10299703remolds
rends65129953re__nds
rescinds1136333rescinds
resends83513713resends
resods74116303reso_ds
resounds956483resounds
responds1136913responds
rewinds114810483rewinds
rewords115413973rewords
rezones163213943rezones
salons63823693salon_s
sands65228583s__ands
sarcoids1137803sarcoids
sarods74918573saro_ds
sarongs84511803sarongs
scads85419963s_c_ads
scalds94813693s_calds
scans74625103s_can_s
scants85219723s_cants
scenas84114703s_cenas
scend85516293s_cend_
scenes84520353s_cenes
scents85317023s_cents
scions82612243scion_s
scoffs14347503s_coffs
scold85414863s_cold_
sconce104711723s_conce
sconces113811453s_conces
scone74621833s_con_e
scoops105414363s_coops
scoots85315943s_coots
scopes104719593s_copes
scops95820193s_co_ps
scores84725923s_cores
scorns85713023s_corns
scots74025913s_co_ts
scours84913593s_cours
scouts84817943s_couts
scowls11549593s_cowls
scows106617803s_co_ws
scrods94111603s_crods
scuds85116243s_c_uds
seabeds10417223seabeds
seacocks1645643seacocks
seafoods1245673seafoods
seasons72614233season_s
secant84023293secan_t
seccos1039923sec_cos
secede93311993sec_ede
secedes103711983secedes
secerns987733secerns
seclude1035233seclude
secludes1134953secludes
secondary1543193secondary
seconding1337613seconding
secpars1138413secpars
secrets9311773secrets
secs65033893sec___s
sections102714703section_s
sectors93116443sectors
sects75622893sec__ts
secundly1443123secundly
secundum1342923secundum
secures9613163secures
sedans74816093sedan_s
seeds64330063se__eds
seeings84411293seeings
segnos73610443se_gnos
segos64919483sego__s
seines65029903se_ines
semens84616963semen_s
send55237293se__nd_
sennas64214233se_nnas
senoras72714953senoras
senores73218113senores
senors63620783seno_rs
sepoys1138473sepo_ys
serenes73222903serenes
serines74229543serines
serins64029673serin_s
sermons9311783sermon_s
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
setoffs1334133setoffs
seton55223543seton__
setous64917373seto_us
setouts74110333setouts
sevens93813663seven_s
sewans95215903sewan_s
sewings11369173sewings
sextons143710413sexton_s
shends105313773s_hends
shrouds1136023shrouds
sloids73712693s_loids
slojds14345473s_lojds
sloyds10346293s_loyds
snoods74312453s_noods
sods54940213s__o_ds
solands84412343solands
solons65120023solon_s
sonde64622833s__onde
sondes74922873s__ondes
sones55444143s__ones
songs67725553s__ongs
sons46049553s__on_s
sords64527803s__ords
sounds74616183s_ounds
spends94714473s_pends
spoons84116013spoon_s
stands75118053s_tands
steroids9911443steroids
stones65130033s_tones
stounds8377823stounds
strands83711953strands
strouds837803strouds
swoons94511143swoon_s
swords104510803s_words
swounds11405643swounds
syconia1248313syconia
sycoses1249133sycoses
sycosis1238823sycosis
synods1077953syno_ds
technos1236183technos
teinds738263te_inds
tends65425583te__nds
tenons62916603tenon_s
vends95520893ve__nds
wends95822813we__nds
xenons132710483xenon_s

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272826.89319443.9
3Display Results2822820.1062660.4
 (SQL Overall)1786912827.13925030.3
 
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.