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

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

64 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
adversative	18	5	324	(None)
adversatives	19	5	247	1	adversatives
adversatively	23	5	227	2	adversatively
advective	18	4	523	3	adve__ctive
adventive	16	4	581	3	adve__ntive
adversarial	15	5	170	3	adversarial
adversaries	15	5	323	3	adversaries
adversities	15	6	435	3	adversities
advertise	13	4	610	3	adver__tise
advertize	22	4	538	3	adver__tize
advocative	19	4	396	3	adv_ocative
alternative	14	5	468	3	alternative
aversive	14	4	744	3	a_vers__ive
deverbative	20	5	362	3	deverbative
versatile	12	4	516	3	__versatile
accusative	17	4	444	4	a_ccusative
adhesive	15	4	380	4	adhe_s__ive
adjective	22	4	481	4	adje__ctive
adjustive	20	4	324	4	ad_jus_tive
adsorptive	16	5	336	4	adsor_ptive
adumbrative	19	6	245	4	adumbrative
adventives	17	4	512	4	adve__ntives
adversariness	17	6	183	4	adversariness
adversary	16	4	248	4	adversa__ry
adverse	11	4	595	4	advers____e
adversity	16	4	381	4	advers__ity
adverting	14	3	722	4	adver__ting
advertised	15	4	409	4	adver__tised
advertiser	14	4	361	4	adver__tiser
advertises	14	4	591	4	adver__tises
advertized	24	4	379	4	adver__tized
advertizes	23	4	467	4	adver__tizes
affirmative	22	5	309	4	affirmative
aggregative	17	5	336	4	aggregative
alternatives	15	5	325	4	alternatives
appellative	18	5	307	4	appellative
arrestive	12	4	675	4	arre_s_tive
aspersive	14	4	589	4	aspers__ive
assertive	12	4	647	4	asser__tive
asseverative	18	5	233	4	assever_ative
assortative	14	7	395	4	assortative
aversives	15	4	591	4	a_vers__ives
derivative	17	4	668	4	_d_erivative
derogative	15	4	698	4	_d_erogative
devastative	18	5	343	4	_devastative
deverbatives	21	5	217	4	deverbatives
deviative	16	4	772	4	_d_eviative
durative	12	3	907	4	_d_ur_ative
ergative	12	3	897	4	___ergative
federative	17	4	616	4	feder_ative
generative	14	5	857	4	gener_ative
ideative	12	3	857	4	id_e__ative
imperative	17	4	856	4	imper_ative
inversive	15	5	719	4	invers__ive
iterative	12	4	1071	4	_iter_ative
lacerative	15	5	628	4	lacer_ative
malversation	17	5	272	4	malversation
operative	14	11	1055	4	_oper_ative
overactive	18	4	726	4	_overactive
oversave	14	3	1049	4	_oversa__ve
revertive	15	4	885	4	rever__tive
superlative	16	4	825	4	superlative
tolerative	13	4	625	4	toler_ative
ulcerative	15	4	517	4	ulcer_ative

Search took 9 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.453	394461.4
2	DLD Change Limit	148819	64	8.406	17703.9
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	8.889	20102.5