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

Here are the results of your fuzzy-string dictionary search for “electuaries” 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.

68 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
electuaries	13	5	423	(None)
actuaries	11	4	756	3	__actuaries
electorates	13	4	745	3	electorates
electrics	13	4	800	3	elect__rics
electrifies	16	4	574	3	electrifies
electuary	14	4	327	3	electuar__y
estuaries	9	4	621	3	__estuaries
lectures	10	13	1015	3	_lectu_r_es
nectaries	11	4	981	3	_nect_aries
sanctuaries	13	5	335	3	sanctuaries
sectaries	11	3	1224	3	_sect_aries
textuaries	17	4	362	3	_textuaries
bestiaries	12	4	597	4	_bestiaries
centauries	12	4	553	4	_centauries
centuries	11	3	1133	4	_centu_ries
decenaries	13	4	812	4	_decenaries
decuries	11	3	1222	4	_dec_u_ries
delectables	16	14	433	4	delect_ables
delectates	13	4	819	4	delect_a_tes
dietaries	10	4	1066	4	die_t_aries
effectuates	19	5	253	4	effectua_tes
electable	13	14	962	4	elect_able_
electees	10	23	872	4	elect___ees
electives	14	4	893	4	elect__ives
electorate	12	4	758	4	electorate_
electors	10	30	1384	4	elect_or__s
electress	11	4	611	4	elect__ress
electresses	13	4	596	4	electresses
electret	10	4	1199	4	elect__r_et
electrets	11	4	654	4	elect__rets
electric	12	4	918	4	elect__ri_c
electrified	17	5	460	4	electrified
electrify	17	4	467	4	elect__rify
electrodes	13	4	725	4	elect_rodes
electroed	12	4	697	4	elect__roed
electronics	15	5	721	4	electronics
electrons	11	24	1175	4	elect__rons
electros	10	28	1174	4	elect__r_os
electrums	13	4	448	4	elect__rums
eventuates	13	9	418	4	eventua_tes
executrices	22	5	190	4	exec_utrices
executrixes	19	5	128	4	exec_utrixes
fluctuates	15	4	307	4	fluctua_tes
hectares	13	3	885	4	_hect_ar_es
insectaries	13	5	489	4	insect_aries
lecheries	14	4	907	4	_lec_heries
lectionaries	14	5	477	4	_lectionaries
lecture	9	14	951	4	_lectu_r_e_
lectured	11	12	722	4	_lectu_r_ed
lecturer	10	13	602	4	_lectu_r_er
lecturers	11	12	423	4	_lectu_rers
lecturing	12	3	730	4	_lectu_ring
lethargies	14	6	314	4	_le_thargies
locutories	12	4	463	4	_locutories
mortuaries	12	4	537	4	_mortuaries
nectaried	12	4	544	4	_nect_aried
nectarines	12	4	689	4	_nect_arines
obituaries	12	4	334	4	_obituaries
peccaries	15	4	853	4	_pec_caries
plenaries	11	4	1038	4	ple__naries
rectories	11	3	1464	4	_rect_ories
refectories	16	4	642	4	refect_ories
reliquaries	20	5	336	4	rel_iquaries
statuaries	10	5	459	4	_statuaries
telecourses	13	5	234	4	telecou_rses
tertiaries	10	4	700	4	_tertiaries
vestiaries	13	4	537	4	_vestiaries
voluptuaries	17	6	155	4	voluptuaries

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	68	8.876	16766.4
3	Display Results	68	68	0.046	1478.3
	(SQL Overall)	178691	68	9.342	19127.7