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

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

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
counterspells	17	5	346	(None)
counterspell	16	5	391	1	counterspell_
counterpleas	16	5	580	3	counter_pleas
counterspies	16	4	831	3	countersp_ies
countersteps	16	5	588	3	counterste_ps
counterstyles	18	5	478	3	counterstyles
countersues	13	4	853	3	countersue__s
counteragents	16	5	517	4	counteragents
counterchecks	23	5	332	4	counterchecks
counterfeits	17	5	621	4	counter_feits
counterfoils	17	5	539	4	counter_foils
countermemos	18	5	443	4	counter_memos
counterpanes	16	4	930	4	counter_panes
counterparts	16	4	671	4	counter_parts
counterplan	15	8	677	4	counter_p_lan
counterplans	16	8	714	4	counter_plans
counterplay	18	10	560	4	counter_p_lay
counterplays	19	9	560	4	counter_plays
counterplea	15	4	703	4	counter_p_lea
counterplot	15	9	681	4	counter_p_lot
counterplots	16	10	623	4	counter_plots
counterploy	18	10	520	4	counter_p_loy
counterploys	19	9	535	4	counter_ploys
counterposes	16	4	762	4	counter_poses
counterrally	17	5	552	4	counter_rally
countershots	17	5	593	4	counters_hots
countersigns	15	4	642	4	counters_igns
countersinks	18	4	616	4	counters_inks
countersnipers	18	9	327	4	countersnipe_rs
counterspy	17	4	466	4	countersp___y
counterstains	15	15	662	4	counterstains
counterstates	15	8	664	4	counterstates
counterstep	15	4	711	4	counterste__p
counterstreams	18	10	280	4	counterstreams
counterstyle	17	5	505	4	counters_tyle
countersue	12	4	774	4	countersue___
countersued	14	4	707	4	countersue__d
countersuits	14	12	659	4	counters_uits
countertrends	16	7	435	4	countertrends
countervails	17	5	599	4	counter_vails
counterviews	20	13	487	4	countervie_ws
counterworlds	19	5	346	4	counterworlds
countesses	12	4	884	4	counte_sse__s
outspells	11	10	460	4	_ou_t__spells
undersells	11	4	473	4	__unders_ells

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.343	520965.0
2	DLD Change Limit	95024	45	5.500	17277.1
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	5.873	30425.8