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 “sectored” 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
sectored113808(None) 
hectored1436891hectored
vectored1435641vectored
doctored1245622doctored
factored1436232factored
lectured11127232lectured
mentored1138002mentored
restored96417192restored
scored94621132s_c_ored
sectioned1246522sectioned
sector83415932sector__
sectoral10109542sectoral
sectors93116452sector_s
secured1059722sec_ured
stored75524212s__tored
succored13135172succored
anchored1438603anchored
beckoned1735793beckoned
bestowed14156623bestowed
bettered113011843bettered
censored11197953censored
centered112513523centered
centred103411683cent_red
chored125321883__chored
cored85044223__c_ored
declared1248753declared
decoded123212393dec_oded
decolored1345673decolored
decoyed14358343dec_oyed
deplored1237233deplored
detoured1036513de_toured
detoxed1636103de_toxed
echoed125211163_echo_ed
electroed1247003electroed
encored10412113_encored
entered82718883_entered
escorted1136703esc_orted
escoted1038183esc_oted
escrowed1434673escrowed
extorted1636233_extorted
featured1237683featured
festered122512113festered
fettered12259493fettered
gestured1036993gestured
gettered10258613gettered
hectare1238473hectare_
hectares1338863hectares
hector113312653hector__
hectors123513263hector_s
lechered1437523lechered
lector83514993lector__
lectors93415773lector_s
lecture9149523lecture_
lecturer10136033lecturer
lectures101310163lectures
lettered92910783lettered
metered103514013me_tered
metred95315143me_t_red
motored1039933_motored
necrosed1137223necrosed
nectaried1245453nectaried
neutered937423neutered
pastored1139973pastored
pectized22257593pectized
pectoral121210503pectoral
peltered112510453peltered
pestered112814973pestered
petered103314973pe_tered
pictured1346573pictured
prestored125111673prestored
proctored1446423proctored
rebored105015883re_bored
reckoned1546963reckoned
recoded113115043rec_oded
recolored1246863recolored
recooked15268253recooked
record96117433rec_or_d
recorded122511073rec_orded
recorked15239863rec_orked
rector84019753rector__
rectories11314663rectories
rectors93520523rector_s
rectory123512733rector_y
recurred1137093recurred
rescored114513103rescored
restoked135710533restoked
restore75822983restore_
restorer84813723restorer
restores85222993restores
retired84620143re_tired
retore67630773re_tore_
retorted9312333re_torted
sacred94917103sac__red
savored1158343s_avored
scared95227293s_c_ared
scarred104512633s_carred
sceptered1444723sceptered
sceptred1343653sceptred
scooped124611753s_cooped
scooted103612283s_cooted
scoped115116663s_c_oped
score75526743s_c_ore_
scorer84818263s_c_orer
scores84725923s_c_ores
scorned10229953s_c_orned
scoured103811153s_coured
scowed124413833s_c_owed
seared75232843se__ared
seasoned948113seasoned
seated75131063seat__ed
seceded11319203sec_eded
secerned1136103secerned
secluded1233663secluded
second9411153sec_o_nd
seconde1037413sec_onde
seconded1236363seconded
secret8325063sec__ret
secreted1138643secreted
sectaries11312243sectaries
sectary1238273sectar_y
sectile9311973sectile_
sectorial111110013sectorial
sectoring1239583sectoring
secure8513533sec_ure_
securer958253sec_urer
secures9613163sec_ures
seethed113410193seet_hed
senhores112810993senhores
senores73218113se_nores
sered65737293se___red
setose65114773se_tose_
settled83210873se_ttled
severed113513863se_vered
sewered112911243se_wered
sheltered1335583sheltered
shored105723653s__hored
sintered92213903sintered
sistered92612803sistered
skeltered1443873skeltered
snored74819543s__nored
sored66141783s___ored
spectated14236593spectated
spectre11297773spect_re_
spectres12268683spect_res
spoored104411293s_poored
spored94821793s__pored
stared75429873s__tared
stoked114718293s__toked
stoled74521593s__toled
stoned75923143s__toned
stoped94721013s__toped
store56333813s__tore_
storer64721673s__torer
stores65533663s__tores
storey95217613s__torey
storied8515163s__toried
stormed1039043s__tormed
stowed105817203s__towed
succorer12124683succorer
succoured1443563succoured
suckered1537833suckered
suctioned1245283suctioned
sutured8310373s_utured
sweltered1344453sweltered
teetered9258303teetered
tentered96412103tentered
textured1695483textured
tutored837553_tutored
vector113212063vector__
vectors123212593vector_s
ventured1238273ventured
vestured1237463vestured
vetoed10359823ve_to_ed
weltered12238443weltered
westered122511873westered

Search took 10 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 Limit1461621758.61016975.8
3Display Results1751750.0802187.5
 (SQL Overall)1786911759.11019614.8
 
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.