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

136 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
secondes113813(None) 
seconde1037411seconde_
seconded1236351seconded
seconder1137181seconder
seconders1236951seconders
seconds1038281second_s
decodes113914982deco_des
recodes102918632reco_des
sconces113811452s_conces
scones84521302s_con_es
secedes103711982sec_edes
secludes1134952secludes
seconals1047052seconals
second9411152second__
secondi1044942second_i
secondly1443662secondly
secondo1044932second_o
sondes74922872s__ondes
acnodes1037833_acnodes
ancones93116343ancon_es
becomes132911963beco_mes
betonies10413063betonies
beyonds1335063beyond_s
blondes104213163_blondes
codes86247293__co_des
condoes104319203__condoes
condos94322333__condos
cones76457423__con_es
conges94928173__conges
conies84338593__conies
contes84432913__contes
debones103315113debon_es
decades113615513dec_ades
decanes103118913decan_es
decides114217653dec_ides
decode104414743deco_de_
decoded123212383deco_ded
decoder113712293deco_der
decoders122810413deco_ders
decongest1345633decongest
depones103717093depon_es
ebonies9312883_ebonies
ecocides1346583_ecocides
encodes10310643enco_des
epodes94315563_epo_des
erodes74819883_ero_des
felonies11310993felonies
geodes8412153ge_o_des
hexones17299143hexon_es
icones84616383_icon_es
ketones115014503keton_es
lemonades1244093lemonades
leones64417723le_on_es
mondes94322353__mondes
peones83821043pe_on_es
peonies93620153pe_onies
precodes13711573preco_des
recanes93222263recan_es
recedes102816063rec_edes
recode93618713reco_de_
recoded113115033reco_ded
recondense1345503recondense
reconfer1337673reconfer
reconfers1437213reconfers
reconned113610653reconned
recons84922993recon__s
reconvey1655603reconvey
reconveys1743533reconveys
recopies12313733recopies
recorded122511063recorded
recorder11249633recorder
recorders12187953recorders
records105213923record_s
rezones163213943rezon_es
saccades13137253saccades
sarodes84216143saro_des
saxonies1537913saxonies
scended11329873s_cended
scends95213003s_cend_s
scenes84520353s_cen_es
scolded11358863s_colded
scolder103210343s_colder
scolders11288993s_colders
scolds95011233s_cold_s
sconce104711723s_conce_
sconced12359173s_conced
scone74621833s_con_e_
scopes104719593s_co_pes
scores84725923s_co_res
scouses93313243s_couses
scowder13286873s_cowder
scowders14276233s_cowders
seances93015343se_ances
seasides938743seasides
secants93413893secan_ts
secede93311993sec_ede_
seceded11319203sec_eded
seceder10329573sec_eder
seceders11277963sec_eders
seclude1035233seclude_
secluded1233663secluded
seconal9310073secon_al
secondaries1454043secondaries
secondary1543193secondary
seconding1337613seconding
secretes10410473secretes
secund937103secund__
secundly1443123secundly
secundum1342923secundum
secures9613163sec_ures
seines65029903se_in_es
selenides10178193selenides
sended85121233se__nded
sender73824413se__nder
senders83022353se__nders
sends65528243se__nd_s
senores73218113seno_res
senses63923943se__nses
serenades10217943serenades
serenes73222903seren_es
serines74229543serin_es
setons64620173seton__s
simonies10311113simonies
sonde64622833s__onde_
sonder73623523s__onder
sonders83820713s__onders
sones55444143s__on_es
spodes94817433s_po_des
spondee10310593s_pondee
spondees1136483s_pondees
sponges10311043s_ponges
spoonies101911753spoonies
stones65130033s_ton_es
subcodes1338143subco_des
sycoses1249133syco_ses
tacnodes1145003tacnodes

Search took 9 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 Limit1461621368.23617746.7
3Display Results1361360.0462956.5
 (SQL Overall)1786911368.70220534.5
 
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.