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

214 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
secreted113863(None) 
secrete9311071secrete_
secreter1038511secreter
secretes10410471secretes
accreted1336332accreted
decreed112710252decre_ed
excreted1846152excreted
ferreted1236332ferreted
recrated112918602recrated
recreated12412532recreated
sacheted14127832sacheted
screed95718932s_cre_ed
screwed135710662s_crewed
seceded11319202sec_eded
secerned1136102secerned
secret8325062secret__
secretest1147032secretest
secretin10108342secretin
secretly1345182secretly
secretor1045682secretor
secrets9311772secret_s
serrated92513432serrated
socketed15177342socketed
accrete1137843accrete_
accretes1238113accretes
acerated113113983acerated
aerated85322373ae_rated
becarpeted1742263becarpeted
becrimed1565513becrimed
becrusted1443943becrusted
befretted1544373befretted
berated104422133be_rated
bucketed1736763bucketed
cacheted16148233cacheted
cerated103922473ce_rated
cocreated142710093cocreated
concreted1439413concreted
crated94827773__crated
created104323453__created
creed85727393__cre_ed
creped114115703__creped
crested103416533__crested
crewed125316563__crewed
decanted122310493decanted
decerned1237263decerned
decocted1437683decocted
decorated13312203decorated
decreased1345453decreased
decree93117783decre_e_
decreer10269123decre_er
decrees102513123decre_es
decretal1146353decretal
decried112612853decr_ied
decrypted1842763decrypted
degreed10258883degre_ed
deleted93314913de_leted
depleted12258723depleted
derated93623503de_rated
desecrated1447953desecrated
deserted101012203deserted
docketed16156583docketed
erected103213993_e_rected
escheated1546273escheated
eschewed1743443eschewed
escorted1136703escorted
escoted1038183esc_oted
escrowed1434653escrowed
estreated1039563estreated
everted112711853_everted
excrete1667163excrete_
excreter1766123excreter
excretes1787573excretes
execrated1938353execrated
exerted152210053_exerted
faceted13509563fac_eted
ferreled1234843ferreled
ferreter1136543ferreter
garreted1057523garreted
hearted113314023hear_ted
helmeted1435833helmeted
jacketed22146533jacketed
jereed144012073je_re_ed
jerreed1535213jerre_ed
lechered1437523lechered
merited10313853me_rited
necrosed1137213necrosed
obsecrated1543733obsecrated
oersted839553oe_rsted
packeted17148283packeted
pelleted1138203pelleted
picketed17167383picketed
picrated132110113picrated
pocketed17147143pocketed
racheted14149503racheted
racketed15169123racketed
rebreed104611073rebre_ed
recanted112513513recanted
recarpeted1543703recarpeted
receded112713043rec_eded
rechewed1735633rechewed
recited104319103rec_ited
recoated113416783recoated
recrate92621663recrate_
recrates102420373recrates
recreate10313603recreate_
recreates11313363recreates
recruited1236453recruited
reerected1238613reerected
regrated102816333regrated
regreeted1136173regreeted
regretted1137233regretted
rerented92516163re_rented
retreated10312623retreated
reverted122714713reverted
rocketed15157793rocketed
sacred94917103sacr__ed
scanted104114393s_canted
scarted104816123s_carted
scatted103512773s_catted
scented102811883s_cented
schemed1577753s_chemed
scooted103612283s_cooted
scouted104112033s_couted
scraped124313133s_craped
screaked15246983s_creaked
screamed13277603s_creamed
scree720031713s_cre_e_
screeded1235643s_creeded
screeds106210293s_cre_eds
screen85216023s_cre_en
screened1137413s_creened
screes85023973s_cre_es
screwer124410073s_crewer
scribed124510643s_cribed
scried95817303s_cr_ied
scrieved14366203s_crieved
scripted13117553s_cripted
scrived134511113s_crived
searched14209253searched
seared75232843sear__ed
seated75131063se__ated
seaweed11108813seawe_ed
secede93311993sec_ede_
seceder10329573sec_eder
secedes103711983sec_edes
secluded1233663secluded
seconded1236353seconded
secrecies1346913secrecies
secrecy1444743secre_cy
secretary1444203secretary
secreting1279823secreting
secretins11108463secretins
secretion11118303secretion
secretive1446933secretive
secretors1145843secretors
secretory1444603secretory
sectored1138063sectored
secured1059723sec_ured
sedated93714353se_dated
seeded84520463se__eded
seeled73922093se__eled
seemed95117613se__emed
seeped94317523se__eped
seethed113410193se__ethed
segmented1345063segmented
segregated1344523segregated
selected1159783selected
sensated938193sensated
separated1237713separated
sered65737293se_r__ed
serene63522353se_rene_
serener73415763se_rener
serenes73222903se_renes
serged84118773se_r_ged
seriated92717023seriated
serifed11811463se_rifed
serrate73017543serrate_
serrates82617023serrates
serried82513963se_rried
served104616813se_r_ved
severed113513863se_vered
sewered112911243se_wered
sheeted113813043s_heeted
shorted113614403shor_ted
shrewed14589853s_hrewed
sickened1546783sickened
signeted1035973signeted
skirted12388613skir_ted
sleeted83113223s_leeted
smarted105012613smar_ted
snorted83813493snor_ted
sonneted936183sonneted
sorted74523713s_or_ted
speciated14207543speciated
spectated14236593spectated
spirited1148973spirited
spirted103913073spir_ted
sported104015433spor_ted
spurted103111973spur_ted
started84217323star_ted
stereoed937883stereoed
storeyed1234643storeyed
strewed115811343s_trewed
succeed1235983succe_ed
suckered1537833suckered
telneted935073telneted
terete6319333te_rete_
ticketed15146643ticketed
turreted935373turreted
uncrated11416313uncrated
uncreated12312303uncreated
uncrewed1456763uncrewed
velveted1533833velveted
weeted103913793we__eted

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.403443402.0
2DLD Change Limit1461622146.81321453.4
3Display Results2142140.0932301.1
 (SQL Overall)1786912147.30924448.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.