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

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

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.

87 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
execration	19	4	983	(None)
execrations	20	4	892	1	execrations
desecration	14	4	1007	2	desecration
excerption	21	4	506	2	excerption
excretion	18	4	671	2	ex_cretion
execrating	20	4	788	2	execrating
execrative	22	4	604	2	execrative
execrator	18	4	656	2	execrat_or
execution	18	4	630	2	exec_ution
exertion	15	3	1008	2	exe_r_tion
expectation	22	6	648	2	expectation
expiration	19	6	1071	2	expiration
aberration	12	6	720	3	aberration
aeration	8	3	1993	3	_ae_ration
celebration	15	4	646	3	celebration
cerebration	15	4	792	3	cerebration
deaeration	11	3	1301	3	deae_ration
decoration	13	3	1442	3	_decoration
defecation	16	7	980	3	defec_ation
delectation	14	4	855	3	delectation
desecrations	15	5	921	3	desecrations
education	12	3	1020	3	educ_ation
ejection	17	25	1004	3	ejec__tion
election	10	20	1535	3	elec__tion
elevation	12	3	923	3	ele_vation
emaciation	14	4	928	3	emaciation
emendation	13	4	655	3	emendation
emigration	13	22	821	3	emigration
enervation	13	6	947	3	enervation
erection	10	21	1551	3	erec__tion
eructation	12	4	833	3	eructation
evacuation	15	4	716	3	evacuation
evection	13	19	1083	3	evec__tion
evocation	14	20	1029	3	evoc_ation
exacerbation	23	5	295	3	exacerbation
exaction	17	3	895	3	exac__tion
exaltation	17	4	849	3	exaltation
excavation	22	4	543	3	excavation
exception	20	4	685	3	ex_ception
excerptions	22	4	498	3	excerptions
excitation	19	4	1017	3	excitation
excoriation	20	4	843	3	excoriation
excretions	19	4	662	3	ex_cretions
execrate	17	3	965	3	execrat__e
execrated	19	3	835	3	execrat_ed
execrates	18	3	956	3	execrat_es
execrators	19	4	602	3	execrators
executions	19	4	639	3	exec_utions
exemption	20	6	494	3	exe_mption
exenteration	19	5	529	3	exenteration
exercitation	21	5	538	3	exercitation
exertions	16	3	976	3	exe_r_tions
exhalation	20	4	665	3	exhalation
exhortation	21	4	502	3	exhortation
exhumation	22	4	469	3	exhumation
exoneration	18	4	765	3	exoneration
expectations	23	6	584	3	expectations
expectoration	24	5	256	3	expectoration
expiation	18	7	1042	3	ex_piation
expirations	20	6	958	3	expirations
exploration	20	6	671	3	exploration
exportation	20	4	744	3	exportation
expurgation	21	5	455	3	expurgation
exsection	18	4	749	3	exsec__tion
exsertion	16	4	685	3	exser_tion
exsiccation	22	4	362	3	exsiccation
extenuation	18	4	518	3	extenuation
extirpation	20	8	492	3	extirpation
extortion	16	4	672	3	extor_tion
extraction	19	6	798	3	ex_traction
exudation	17	8	769	3	ex_udation
exultation	17	4	753	3	exultation
exuviation	20	11	634	3	exuviation
federation	14	4	957	3	fede_ration
generation	11	3	1242	3	gene_ration
iteration	9	5	1503	3	ite_ration
laceration	12	4	957	3	laceration
maceration	14	4	961	3	maceration
operation	11	3	1400	3	ope_ration
penetration	13	4	989	3	penetration
recreation	12	4	1361	3	_recreation
redecoration	15	4	601	3	redecoration
secretion	11	11	830	3	_secretion
serration	9	4	1406	3	_serration
speciation	14	4	939	3	speciation
ulceration	12	4	726	3	ulceration
veneration	13	4	1234	3	vene_ration

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	87	6.483	21688.0
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	6.935	25766.5