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

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

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

103 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
exertive	18	3	908	(None)
egestive	12	4	683	2	egestive
ejective	20	3	715	2	ejective
elective	13	3	1100	2	elective
erective	13	3	1183	2	erective
exaptive	20	4	525	2	exaptive
exceptive	23	4	568	2	exceptive
excretive	21	4	514	2	excretive
execrative	22	4	604	2	execrative
executive	21	6	474	2	executive
exemptive	23	4	383	2	exemptive
exercise	17	4	706	2	exercise
exerting	16	22	1115	2	exerting
exertion	15	3	1008	2	exertion
expertise	18	4	793	2	expertise
expertize	27	4	658	2	expertize
exsertile	16	4	459	2	exsertile
extortive	19	4	514	2	extortive
revertive	15	4	885	2	revertive
abortive	13	4	688	3	abortive
agentive	12	4	804	3	agentive
assertive	12	4	647	3	assertive
aversive	14	4	744	3	aversive
coercive	15	4	587	3	coercive
creative	13	28	1280	3	creative
deceptive	17	4	685	3	deceptive
decretive	15	4	749	3	decretive
defective	18	4	800	3	defective
derive	10	38	1704	3	_der_ive
detective	15	4	810	3	detective
detersive	13	4	634	3	detersive
eductive	14	7	686	3	eductive
eerie	5	52	2853	3	e_er_i_e
effective	20	7	619	3	effective
ejectives	21	4	544	3	ejectives
elative	10	3	1245	3	e_lative
electives	14	4	893	3	electives
emeritae	10	4	635	3	emeritae
emetine	9	7	1294	3	eme_tine
emotive	12	3	919	3	e_motive
enactive	13	3	851	3	enactive
energise	9	4	733	3	energise
energize	18	4	556	3	energize
erectile	10	3	951	3	erectile
ergative	12	3	897	3	ergative
eruptive	13	4	579	3	eruptive
eserine	7	4	1590	3	eser_ine
eternise	8	11	966	3	eternise
eternize	17	11	836	3	eternize
eventide	12	4	685	3	eventide
everting	12	22	1313	3	everting
excessive	21	4	504	3	excessive
excursive	21	4	393	3	excursive
executives	22	6	316	3	executives
exercised	19	4	463	3	exercised
exerciser	18	4	411	3	exerciser
exercises	18	4	646	3	exercises
exergue	15	4	419	3	exer_gue
exert	12	46	2414	3	exert___
exerted	15	22	1005	3	exert_ed
exertions	16	3	976	3	exertions
exerts	13	37	1229	3	exert__s
exonerative	21	5	539	3	exonerative
exorcise	17	4	593	3	exorcise
exorcize	26	4	489	3	exorcize
expensive	21	4	584	3	expensive
experting	19	3	805	3	experting
expertises	19	4	710	3	expertises
expertism	20	4	543	3	expertism
expertized	29	4	471	3	expertized
expertizes	28	10	601	3	expertizes
expletive	21	4	444	3	expletive
exserting	17	3	666	3	exserting
exsertion	16	4	685	3	exsertion
extensive	19	4	572	3	extensive
extermine	18	4	828	3	extermine
extractive	22	4	660	3	extractive
extrusive	19	4	480	3	extrusive
exudative	20	4	489	3	exudative
federative	17	4	616	3	federative
fertile	10	3	1173	3	_fertile
festive	13	3	977	3	_festive
furtive	13	3	717	3	_furtive
generative	14	5	856	3	generative
ideative	12	3	857	3	ideative
inertiae	8	4	1147	3	inertiae
iterative	12	4	1071	3	iterative
nemertine	11	4	707	3	nemertine
operative	14	11	1055	3	operative
orective	13	3	935	3	orective
overlive	14	22	1129	3	overlive
overtime	13	13	1227	3	overtime
overtire	11	14	1311	3	overtire
receptive	16	4	832	3	receptive
refective	17	4	911	3	refective
rejective	21	4	825	3	rejective
resentive	12	4	1072	3	resentive
restive	10	3	1593	3	_restive
retentive	12	4	985	3	retentive
secretive	14	4	693	3	secretive
selective	14	4	952	3	selective
sportive	13	4	833	3	sportive
vegetive	15	4	554	3	vege_tive

Search took 8 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	146162	0.436	409841.7
2	DLD Change Limit	146162	103	6.550	22314.8
3	Display Results	103	103	0.046	2239.1
	(SQL Overall)	178691	103	7.032	25411.1