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

171 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
secerned113610(None) 
decerned1237261decerned
scorned10229952s_corned
seceded11319202sece_ded
secern81010222secern__
secerns987732secern_s
secreted1138632secreted
secured1059722secur_ed
severed113513862sever_ed
sewered112911242sewer_ed
acorned10238283_acorned
beckoned1735783beckoned
becursed1335583becursed
bemeaned1335783bemeaned
caverned1436163caverned
cered85227443__cer_ed
concerned1438643concerned
corned95224523__corned
deceased1247713deceased
deceived1535893deceived
decern91310953decern__
decerns10119053decern_s
declined123910883declined
decreed112710253dec_reed
decried112612853dec_ried
decurved1534843decurved
deferred13106363deferred
degermed1335453degermed
dehorned1345683dehorned
demeaned1237283demeaned
demerged13157603demerged
depermed1436453depermed
deserted101012203deserted
deserved13108133deserved
deterged11127923deterged
deterred10137803deterred
deveined1336673deveined
discerned1347863discerned
earned74818333_e_arned
emerged11158213_emerged
emersed10138513_emersed
escarped1355163escarped
escorted1136703escorted
eterne6311723_eterne_
evened101010313_eve_ned
everted112711853_everted
exerted152210053_exerted
fevered14339723fever_ed
governed1335193governed
interned93016653interned
jeered143912793je_er_ed
keened114013633ke_e_ned
kerned114112933__kerned
learned8329303le_arned
lechered1437523lecher_ed
leered73816223le_er_ed
levered114212303lever_ed
lucerne945753lucerne_
lucernes1046363lucernes
metered103514013meter_ed
peened94318163pe_e_ned
peered93819493pe_er_ed
petered103314973peter_ed
recaned102817203rec_aned
receded112713043rece_ded
received1437983received
recessed1139713recessed
reckoned1546953reckoned
recleaned1236583recleaned
reclined113613603reclined
recoined113614423recoined
reconned113610653reconned
recorded122511063recorded
recorked15239853recorked
recurred1137093recurred
recurved1436493recurved
reearned948883reearned
refereed12149693refereed
referred1297833referred
relearned1035633relearned
remerged12149173remerged
reperked15177793reperked
reserved121010583reserved
returned9459133returned
reverbed14269223reverbed
revered112819333rever_ed
reverend12288853reverend
reversed122711613reversed
reverted122714713reverted
rezeroed1835993rezeroed
sabered103213023saber_ed
sacred94917103sac_r_ed
scanned104110893s_canned
scared95227293s_car_ed
scarfed134711183s_carfed
scarped124314403s_carped
scarred104512633s_carred
scarted104816123s_carted
scend85516293s_ce_n_d
scended11329873s_cended
scene77220573s_ce_ne_
scenes84520353s_ce_nes
scented102811883s_cented
scored94621133s_cor_ed
scorner9259763s_corner
screed95718933s_c_reed
screened1137413screened
screwed135710663s_crewed
scried95817303s_c_ried
seared75232843se_ar_ed
seasoned948113seasoned
secede93311993sece_de_
seceder10329573sece_der
secedes103711983sece_des
secerning1246203secerning
secluded1233663secluded
second9411153sec_on_d
seconde1037413sec_onde
seconded1236353seconded
secret8325063sec_r_et
secrete9311073secrete_
secreter1038513secreter
secretes10410473secretes
sectioned1246523sectioned
sectored1138073sectored
secund937103sec_un_d
secure8513533secur_e_
securer958253secur_er
secures9613163secur_es
seedbed11246613se_edbed
seeded84520463se_e_ded
seeled73922093se_e_led
seemed95117613se_e_med
seeped94317523se_e_ped
seethed113410193se_ethed
seined74023063s__eined
selected1159783selected
sequined18105653sequined
sered65737293s__er_ed
serene63522353sere_ne_
serener73415763sere_ner
serenes73222903sere_nes
serged84118773s__erged
serried82513963se_rried
served104616813s__erved
severe94016083sever_e_
severer103511563sever_er
sheened113511703s_heened
sheered113515453sheer_ed
sickened1546783sickened
skeined1236773s_keined
skewered1634213skewer_ed
smerked14327283s_merked
sneered83113973sneer_ed
sobered102912433sober_ed
sorned74820043s__orned
speaned103411523s_peaned
speered103614813speer_ed
sphered133512313spher_ed
spiered104412463spier_ed
spurned10339263s_purned
steered83615253steer_ed
sterner7411913s_terner
suborned1137303suborned
suckered1537833sucker_ed
supered10316123super_ed
swerved1455703s_werved
ulcered1037973ulcer_ed
veered103612743ve_er_ed
weened104013733we_e_ned
yearned11327373ye_arned

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 Limit1461621716.56322270.6
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.03225411.1
 
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.