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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

73 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
secondaries	14	5	404	(None)
secondarily	17	5	208	2	secondarily
secondariness	16	6	199	2	secondariness
decenaries	13	4	812	3	decen_aries
decennaries	14	5	426	3	decennaries
feodaries	13	4	637	3	fe_o_daries
legendaries	13	5	309	3	legendaries
secondary	15	4	319	3	secondar__y
seconders	12	3	695	3	seconder__s
secondes	11	3	813	3	second___es
secretaries	13	4	542	3	secretaries
sectaries	11	3	1224	3	sec__taries
seminaries	12	4	1000	3	semin_aries
zemindaries	23	5	302	3	zemindaries
boundaries	13	4	511	4	_boundaries
canaries	10	3	1894	4	__can_aries
condores	11	33	1564	4	__condor_es
congeries	12	3	1640	4	__congeries
contraries	12	7	1193	4	__contraries
coronaries	12	4	1023	4	coron_aries
covaries	13	4	1325	4	__co_varies
deaconries	13	4	516	4	deacon__ries
economies	13	4	862	4	_econ_omies
fecundates	16	4	230	4	fecunda_tes
fecundities	17	5	333	4	fecundities
felonries	12	4	620	4	felon__ries
feudaries	13	4	588	4	fe__udaries
gendarmes	13	4	392	4	ge__ndarmes
heronries	12	4	848	4	heron__ries
incendiaries	15	5	269	4	incendiaries
lectionaries	14	5	477	4	lection_aries
legendries	12	4	382	4	legend_ries
legionaries	12	7	456	4	legion_aries
mercenaries	15	5	544	4	mercen_aries
necessaries	13	5	309	4	necessaries
nectaries	11	4	981	4	nec__taries
octonaries	12	4	600	4	octon_aries
peccaries	15	4	853	4	pec__caries
prebendaries	17	5	281	4	prebendaries
quandaries	20	6	441	4	_quandaries
recodifies	16	10	632	4	reco_difies
recondenses	14	4	496	4	recondenses
recoveries	15	4	746	4	reco_veries
scandalise	13	4	489	4	s_candalise
scandalises	14	4	480	4	s_candalises
scandalizes	23	4	453	4	s_candalizes
scenarios	11	4	481	4	s_cen_arios
sceneries	11	4	939	4	s_cen_eries
seconals	10	4	705	4	secon_a__ls
secondarinesses	18	6	156	4	secondari~~ness~~es
seconde	10	3	741	4	second___e_
seconded	12	3	635	4	second___ed
seconder	11	3	718	4	second___er
secondi	10	4	494	4	second__i__
seconding	13	3	761	4	second__ing
seconds	10	3	828	4	second____s
secretories	13	4	594	4	secretories
secularise	12	14	659	4	sec_ularise
secularises	13	15	587	4	sec_ularises
secularizes	22	19	675	4	sec_ularizes
seigneuries	12	5	257	4	seigneuries
seigniories	12	5	283	4	seigniories
seignories	11	4	497	4	seign_ories
senarius	8	3	1010	4	se__n_arius
sentries	8	13	1805	4	se__n_tries
septenaries	13	7	535	4	septenaries
spondaics	14	4	220	4	s_ponda_ics
stannaries	10	4	577	4	s_tannaries
subcontraries	17	7	213	4	subcontraries
sudaries	9	3	1275	4	s___udaries
sundries	9	3	1202	4	s__und_ries
ternaries	9	3	1164	4	te_rn_aries
zedoaries	19	4	432	4	zedo__aries

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	148819	0.420	425454.8
2	DLD Change Limit	148819	73	8.750	17007.9
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	9.216	19389.2