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

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

66 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
counterstated	16	6	563	(None)
counterstate	14	5	703	1	counterstate_
counterstates	15	8	664	1	counterstates
counterstained	17	5	484	2	counterstained
counteracted	17	4	736	3	counter_acted
counterfeited	19	7	477	3	counterfeited
countersigned	17	8	435	3	countersigned
counterstain	14	15	678	3	countersta_in
counterstains	15	15	662	3	counterstains
counterstating	17	5	519	3	counterstating
counterstep	15	4	711	3	counters__tep
counterstrategy	21	8	213	3	counterstrategy
counterstyle	17	5	505	3	counterstyle_
counterstyles	18	5	478	3	counterstyles
countersued	14	4	707	3	counters__ued
understated	13	4	783	3	__understated
consternated	15	5	411	4	conster_nated
contemplated	19	5	444	4	co_ntemplated
contested	12	3	1069	4	co_nte_s__ted
counterargued	17	5	422	4	counterargued
counterattack	21	7	273	4	counterattack
counterattacked	24	7	195	4	counterattacked
counterchanged	23	10	377	4	counterchanged
countercharged	23	11	361	4	countercharged
counterclaimed	21	6	352	4	counterclaimed
countered	12	3	1300	4	counter____ed
counterfeiter	18	7	474	4	counterfeiter
counterimage	17	5	498	4	counterimage_
counterimages	18	5	461	4	counterimages
countermand	16	4	712	4	counter_ma_nd
countermanded	19	7	468	4	countermanded
countermoved	20	5	499	4	counter_moved
counterpane	15	4	931	4	counter_pane_
counterpanes	16	4	930	4	counter_panes
counterplayer	20	5	504	4	counterplayer
counterplotted	19	6	341	4	counterplotted
counterpointed	19	5	359	4	counterpointed
counterpoised	18	5	530	4	counterpoised
counterposed	17	5	632	4	counter_posed
counterraid	14	4	675	4	counter_ra_id
countershot	16	5	663	4	countershot__
countershots	17	5	593	4	countershot_s
countersniper	17	10	455	4	countersniper
counterspies	16	4	831	4	counters_pies
countersteps	16	5	588	4	counterst_eps
counterstream	17	7	373	4	counterstream
counterstrike	19	6	529	4	counterstrike
counterstrikes	20	9	474	4	counterstrikes
counterstroke	19	5	478	4	counterstroke
counterstrokes	20	6	462	4	counterstrokes
counterstruck	21	6	319	4	counterstruck
countersue	12	4	774	4	counters__ue_
countersues	13	4	853	4	counters__ues
countersuit	13	13	750	4	countersuit__
countersuits	14	12	659	4	countersuit_s
countertactic	16	6	391	4	counter_tactic
countertrade	15	5	629	4	countertrade_
countertrades	16	5	589	4	countertrades
countertrend	15	7	594	4	counter_trend
countervailed	19	15	489	4	countervailed
interstate	10	7	1097	4	__interstate_
interstates	11	7	1020	4	__interstates
outstated	10	16	981	4	_ou_t__stated
overstated	14	11	944	4	_o__verstated
understate	11	4	886	4	__understate_
understates	12	4	770	4	__understates

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	95024	0.360	496363.9
2	DLD Change Limit	95024	66	5.343	17784.8
3	Display Results	66	66	0.046	1434.8
	(SQL Overall)	178691	66	5.749	31082.1