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

Here are the results of your fuzzy-string dictionary search for “counteragent” 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
counteragent	15	5	769	(None)
counteragents	16	5	517	1	counteragents
convergent	16	4	803	3	co_nver_gent
counteract	14	4	960	3	countera__ct
counterargument	20	7	202	3	counterargument
counterfeit	16	5	773	3	counter_feit
countermen	14	4	929	3	counter_men_
counterpoint	16	5	817	3	counterpoint
countertrend	15	7	594	3	countertrend
cauterant	11	4	853	4	cau_tera__nt
concernment	17	6	621	4	co_ncernment
conferment	17	4	1037	4	co_nfer_ment
contentment	15	5	666	4	co_ntentment
contingent	13	4	908	4	co_nt_ingent
contravene	15	4	509	4	co_nt_ravene
counteracted	17	4	736	4	counteracted
counteracting	18	5	628	4	counteracting
counteracts	15	4	751	4	countera_cts
counterargue	15	5	530	4	counterargue
counterargued	17	5	422	4	counterargued
counterargues	16	8	504	4	counterargues
counterarguing	18	11	340	4	counterarguing
counterblast	16	5	540	4	counterblast
countercheck	22	5	411	4	countercheck
countercurrent	18	6	346	4	countercurrent
countered	12	3	1300	4	counter__e_d
counterfeits	17	5	621	4	counter_feits
counterimage	17	5	498	4	counterimage__
counterimages	18	5	461	4	counterimage_s
countering	13	3	1447	4	counter__ing
counterion	12	4	953	4	counter_ion_
counterions	13	4	982	4	counter_ions
counterman	14	4	855	4	counter_man_
countermand	16	4	712	4	counter_mand
countermemo	17	5	472	4	counter_memo
countermine	15	4	974	4	counter_mine
countermines	16	4	915	4	countermines
counterpane	15	4	931	4	counter_pane
counterpanes	16	4	930	4	counterpane_s
counterpart	15	4	780	4	counter_part
counterplan	15	8	677	4	counterplan_
counterplans	16	8	714	4	counterplans
counterplea	15	4	703	4	counterple_a
counterpleas	16	5	580	4	counterpleas
counterplot	15	9	681	4	counter_plot
counterpoints	17	5	562	4	counterpoints
countershot	16	5	663	4	counter_shot
countersign	14	4	724	4	countersign_
countersigned	17	8	435	4	countersigned
countersigns	15	4	642	4	countersigns
countersink	17	4	806	4	counter_sink
counterspell	16	5	391	4	counterspell
counterstep	15	4	711	4	counterste_p
countersteps	16	5	588	4	countersteps
countersue	12	4	774	4	countersue__
countersued	14	4	707	4	countersue_d
countersues	13	4	853	4	countersue_s
countersuing	15	4	708	4	countersuing
countersuit	13	13	750	4	counter_suit
countersunk	17	5	526	4	counter_sunk
countertenor	14	5	475	4	counter_tenor
counterthreat	18	5	405	4	counterthreat
countertrends	16	7	435	4	countertrends
counterview	19	11	668	4	countervie_w
counterviews	20	13	487	4	counterviews
countrymen	17	5	389	4	count_rymen_
countryseat	16	5	263	4	count_ryseat
superagent	13	11	1041	4	_su_peragent

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	124790	0.406	440125.6
2	DLD Change Limit	124790	68	6.670	18709.1
3	Display Results	68	68	0.050	1360.0
	(SQL Overall)	178691	68	7.126	25075.9