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

Here are the results of your fuzzy-string dictionary search for “counterbalanced” 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
counterbalanced	22	14	257	(None)
counterbalance	20	12	324	1	counterbalance_
counterbalances	21	12	282	1	counterbalances
countenanced	17	5	420	4	counte___nanced
counterchanged	23	10	377	4	counter_changed
counterclaimed	21	6	352	4	counter_claimed
countermanded	19	7	468	4	counter__manded
counterrallied	17	6	325	4	counterral_lied
outbalanced	16	5	207	4	_ou_t__balanced
overbalanced	20	5	269	4	_o__verbalanced
countenance	15	5	587	5	counte___nance_
countenancer	16	5	422	5	counte___nancer
countenances	16	5	573	5	counte___nances
counteracted	17	4	736	5	counter___acted
counterargued	17	5	422	5	counter_a_rgued
counterattacked	24	7	195	5	counterattacked
counterblast	16	5	540	5	counterb_la__st
counterblasts	17	5	400	5	counterb_la_sts
counterchange	21	9	486	5	counter_change_
counterchanges	22	12	422	5	counter_changes
countercharged	23	11	361	5	counter_charged
counterdemand	19	6	321	5	counterdeman__d
counterinstance	19	10	179	5	counterinstance_
countermand	16	4	712	5	counter__man__d
countermarched	24	8	318	5	counterma_rched
counterpane	15	4	931	5	counter__pan_e_
counterpanes	16	4	930	5	counter__pan_es
counterplan	15	8	677	5	counter_plan___
counterplans	16	8	714	5	counter_plan__s
counterplayer	20	5	504	5	counter_pla_yer
counterplotted	19	6	341	5	counter_plotted
counterpointed	19	5	359	5	counter_pointed
counterpunched	24	9	271	5	counter__punched
counterrallies	16	8	395	5	counterral_lies
countersigned	17	8	435	5	counter_sign_ed
counterstained	17	5	484	5	counter_stained
counterstated	16	6	563	5	counter_sta_ted
countervailed	19	15	489	5	counter__vailed
counterviolence	22	7	156	5	counterviolence_
mountebanked	21	8	159	5	mounte_b__anked
outbalance	14	5	294	5	_ou_t__balance_
outbalances	15	5	272	5	_ou_t__balances
overbalance	18	5	335	5	_o__verbalance_
overbalances	19	5	315	5	_o__verbalances
unbalanced	15	4	294	5	__un___balanced

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.326	548131.9
2	DLD Change Limit	65874	45	4.940	13334.8
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	5.296	33740.7