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

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

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.

45 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
counterprotests	19	6	242	(None)
counterprotest	18	6	443	1	counterprotest_
counterprojects	28	6	215	2	counterprojects
counterproject	27	6	319	3	counterproject_
counterpickets	24	6	331	4	counterpicke_ts
counterplots	16	10	623	4	counterplo___ts
counterpoints	17	5	562	4	counterp_o_ints
counterpoises	17	5	641	4	counterp_o_ises
counterposes	16	4	762	4	counterp_o__ses
counterpowers	20	6	482	4	counterp_owe_rs
counterproposal	21	10	133	4	counterproposal
counteragents	16	5	517	5	counte__ragents
counterargues	16	8	504	5	counterargue__s
counterblasts	17	5	400	5	counte__rblasts
countercries	16	4	899	5	countercr_ie__s
countercurrents	19	6	233	5	countercurrents
counterfeiters	19	10	374	5	counterfeite_rs
counterfeits	17	5	621	5	counte__r_feits
counterforces	20	8	555	5	counterforce__s
countermoves	19	5	601	5	counter_move__s
counterorders	16	5	447	5	counteror_de_rs
counterpanes	16	4	930	5	counterp_ane__s
counterparts	16	4	671	5	counterp___arts
counterpicket	23	5	516	5	counterpicke_t_
counterplayers	21	5	380	5	counterplaye_rs
counterpleas	16	5	580	5	counterp__le_as
counterplot	15	9	681	5	counterplo___t_
counterplotted	19	6	341	5	counterplot_ted
counterplotting	20	6	280	5	counterplotting
counterploys	19	9	535	5	counterplo___ys
counterpoint	16	5	817	5	counterp_o_int_
counterpoise	16	5	735	5	counterp_o_is_e
counterpoised	18	5	530	5	counterp_o_ised
counterpose	15	4	750	5	counterp_o__s_e
counterposed	17	5	632	5	counterp_o__sed
counterpower	19	6	586	5	counterp_owe__r
countershots	17	5	593	5	countersho___ts
counterstates	15	8	664	5	counterstate__s
countersteps	16	5	588	5	counte__rste_ps
counterstrokes	20	6	462	5	counterstroke__s
counterthreats	19	6	287	5	counter_threats
counterthrusts	19	8	246	5	counter_thrusts
countertrades	16	5	589	5	countertrade__s
countertrends	16	7	435	5	countertr__ends
overprotects	19	5	303	5	_o__verprotects

Search took 6 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	65874	0.093	1921408.6
2	DLD Change Limit	65874	45	4.970	13254.3
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	5.093	35085.6