Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “subsectors” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

159 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
subsectors	14	4	448	(None)
subsector	13	4	440	1	subsector_
subsections	15	9	710	2	subsections
subsects	12	26	790	2	subsect__s
bisectors	13	4	573	3	_bisectors
dissectors	13	4	536	3	dissectors
objectors	20	4	405	3	_objectors
prosectors	14	19	912	3	prosectors
sectors	9	31	1645	3	___sectors
selectors	11	4	896	3	s_electors
subcenters	14	4	616	3	subcenters
subdirectors	17	6	127	3	subdirectors
subechoes	16	4	456	3	sub_echoes
subeditors	13	6	331	3	subeditors
subjections	22	9	635	3	subjections
subjects	19	22	653	3	subject__s
sublessors	12	4	337	3	sublessors
subsect	11	26	1184	3	subsect___
subsection	14	9	678	3	subsection
subsets	9	28	1310	3	subse_t__s
subsisters	12	4	502	3	subsisters
subverters	15	4	461	3	subverters
trisectors	12	4	446	3	trisectors
abductors	14	4	327	4	_abductors
abettors	10	5	613	4	_ab_ettors
absenters	11	5	617	4	_absenters
assentors	9	5	565	4	_assentors
assertors	9	6	597	4	_assertors
augmentors	13	5	257	4	augmentors
bettors	9	33	1247	4	__b_ettors
bisector	12	4	519	4	_bisector_
collectors	14	4	659	4	collectors
connectors	14	4	818	4	connectors
convectors	17	6	831	4	convectors
correctors	14	4	749	4	correctors
defectors	15	23	788	4	_defectors
deflectors	16	5	477	4	deflectors
detectors	12	27	830	4	_detectors
directors	12	4	814	4	_directors
dissector	12	4	552	4	dissector_
effectors	17	5	503	4	_effectors
ejectors	17	32	866	4	__ejectors
electors	10	30	1384	4	__electors
erectors	10	35	1426	4	__erectors
functors	13	3	574	4	fu__nctors
hectors	12	35	1326	4	___hectors
infectors	14	21	855	4	_infectors
inflectors	15	4	522	4	inflectors
injectors	18	21	672	4	_injectors
inspectors	14	4	493	4	inspectors
lectors	9	34	1576	4	___lectors
lubricators	15	5	388	4	lubricators
neglectors	13	6	354	4	neglectors
nonvectors	15	5	628	4	nonvectors
nucleators	12	4	459	4	nucleators
objector	19	4	380	4	_objector_
obsessors	11	4	288	4	_obsessors
persecutors	15	5	315	4	persecutors
prelectors	14	4	787	4	prelectors
projectors	21	18	717	4	projectors
prosector	13	20	853	4	prosector_
prosecutors	15	6	446	4	prosecutors
prospectors	17	5	458	4	prospectors
protectors	14	20	1014	4	protectors
pulsators	11	7	537	4	puls_ators
quaestors	18	4	361	4	qu_aestors
questors	17	14	701	4	qu__estors
rectors	9	35	2052	4	___rectors
reflectors	15	4	550	4	reflectors
rejectors	18	24	761	4	_rejectors
rubricators	15	5	373	4	rubricators
secretors	11	4	584	4	secre_tors
sector	8	34	1593	4	___sector_
selector	10	4	861	4	s_elector_
sibilators	12	4	571	4	sibilators
specters	12	28	1106	4	s__pecters
stentors	8	3	974	4	s__tentors
stertors	8	3	1093	4	s__tertors
subarctics	16	5	331	4	subarctics
subatoms	12	4	588	4	sub__atoms
subcellars	14	5	285	4	subcellars
subcenter	13	4	707	4	subcenter_
subcools	12	4	575	4	sub__cools
subdeacons	15	5	265	4	subdeacons
subdealers	13	4	411	4	subdealers
subdepots	14	4	316	4	subde_pots
subdirector	16	5	135	4	subdirector_
subductions	16	4	450	4	subductions
subducts	13	10	609	4	subduct__s
subecho	14	4	507	4	sub_echo__
subeditor	12	6	308	4	subeditor_
subentry	13	4	469	4	sub_ent_ry
suberous	10	3	1179	4	sub_e_rous
subers	8	57	2264	4	sub_e___rs
subfloors	14	11	261	4	sub_floors
subject	18	25	863	4	subject___
subjected	21	4	477	4	subject_ed
subjecting	22	4	555	4	subjecting
subjection	21	6	597	4	subjection
subjective	24	4	496	4	subjective
subjectives	25	5	476	4	subjectives
subjectless	22	5	195	4	subjectless
subjugators	21	5	177	4	subjugators
sublessor	11	4	365	4	sublessor_
sublets	9	26	1670	4	suble_t__s
submitters	14	4	444	4	submitters
subnets	9	25	1208	4	subne_t__s
subnetwork	19	5	167	4	subnetwork
subnetworks	20	5	145	4	subnetworks
subperiods	15	4	460	4	subperiods
subregions	13	4	442	4	subregions
subrents	10	3	1029	4	subrent__s
subreptions	15	4	588	4	subreptions
subscales	13	4	734	4	subs_cales
subsecretary	19	6	127	4	subsecretary
subseizure	21	5	177	4	subseizure
subseizures	22	5	157	4	subseizures
subsenses	11	4	747	4	subse_nses
subsere	9	3	1144	4	subse___re
subseres	10	3	1242	4	subse__res
subseries	11	3	1293	4	subse_ries
subserves	14	4	718	4	subse_rves
subset	8	31	2258	4	subse_t___
subsiders	12	4	605	4	subs_iders
subsister	11	4	598	4	subsister_
subsists	10	3	799	4	subsist__s
subsites	10	3	1278	4	subs_it_es
subsoilers	12	4	406	4	subsoilers
subspecies	16	4	474	4	subspec_ies
substates	11	14	1033	4	substat_es
substations	13	4	824	4	substations
subsystems	17	5	183	4	subsystems
subtests	10	3	753	4	subtest__s
subtexts	17	4	490	4	subtext__s
subtracters	15	7	380	4	subtracters
subventions	16	7	484	4	subventions
subverter	14	4	527	4	subverter_
subverts	13	3	697	4	subvert__s
subvicars	16	4	383	4	subvic_ars
subwriters	15	4	441	4	subwriters
successors	14	5	301	4	successors
succors	11	3	741	4	su___ccors
sudsers	8	33	1042	4	sudse___rs
suggesters	12	4	343	4	suggesters
suitors	7	30	1249	4	su___itors
sunseekers	14	4	221	4	sunseekers
sunsets	7	29	1157	4	sunse_t__s
superiors	11	4	1096	4	su_periors
supinators	12	4	564	4	supinators
surfeiters	13	4	363	4	surfeiters
surjections	20	7	528	4	surjections
surveyors	15	4	229	4	surve_yors
suspects	12	5	486	4	suspect__s
suspensors	12	8	366	4	suspensors
trisector	11	4	432	4	trisector_
tubulators	12	4	451	4	tubulators
upsetters	11	4	365	4	_upsetters
vectors	12	32	1259	4	___vectors
vivisectors	19	5	175	4	vivisectors

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	161450	0.436	409841.7
2	DLD Change Limit	161450	159	9.390	17193.8
3	Display Results	159	159	0.080	1987.5
	(SQL Overall)	178691	159	9.906	18038.7