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

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

70 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
avalanched	19	12	171	(None)
avalanche	17	11	251	1	avalanche_
avalanches	18	10	284	1	avalanches
valanced	14	7	546	2	_valanc_ed
avalanching	20	5	158	3	avalanching
balanced	13	5	651	3	_balanc_ed
blanched	16	30	860	3	__blanched
valance	12	6	925	3	_valanc_e_
valances	13	9	876	3	_valanc_es
adamance	13	4	554	4	adamanc_e_
adamances	14	4	503	4	adamanc_es
adamancies	15	4	377	4	adamancies
advanced	15	4	331	4	a_dvanc_ed
affianced	18	4	303	4	affianc_ed
anabranches	18	5	216	4	anabranches
attached	14	16	570	4	a_tta_ched
avianized	22	4	508	4	av_ianized
avouched	17	4	358	4	av__ouched
balance	11	5	1026	4	_balanc_e_
balancer	12	4	660	4	_balanc_er
balances	12	7	997	4	_balanc_es
blancher	15	33	863	4	__blancher
blanches	15	33	1161	4	__blanches
blenched	16	35	805	4	__blenched
branched	16	32	1045	4	__branched
clenched	16	25	776	4	__clenched
clinched	16	34	738	4	__clinched
cranched	16	32	1041	4	__cranched
craunched	17	6	402	4	cra_unched
flenched	17	26	796	4	__flenched
flinched	17	31	670	4	__flinched
glanced	11	43	923	4	__glanc_ed
glunched	15	4	426	4	__glunched
haunched	17	4	481	4	_ha_unched
imbalanced	17	5	248	4	imbalanc_ed
kalanchoe	18	5	186	4	_kalanchoe
kalanchoes	19	5	185	4	_kalanchoes
lanced	9	37	1772	4	___lanc_ed
latched	13	39	1407	4	___latched
launched	14	7	540	4	_la_unched
lunched	13	39	1182	4	___lunched
lynched	16	37	675	4	___lynched
overarched	19	4	609	4	overarched
palaced	12	41	1078	4	_pala_c_ed
paunched	16	4	552	4	_pa_unched
planche	14	29	976	4	__planche_
planches	15	31	1187	4	__planches
planchet	15	25	1197	4	__planchet
potlatched	18	11	245	4	potlatched
prelaunched	19	5	192	4	prelaunched
ranched	13	31	1360	4	___ranched
rebalanced	15	4	358	4	rebalanc_ed
rebranched	18	4	367	4	rebranched
relaunched	16	4	268	4	relaunched
stanched	14	20	890	4	__stanched
staunched	15	5	347	4	sta_unched
unbalanced	15	4	294	4	unbalanc_ed
unblenched	18	4	256	4	unblenched
unbranched	18	4	353	4	unbranched
unclenched	18	4	335	4	unclenched
unclinched	18	4	265	4	unclinched
unlatched	15	4	422	4	_unlatched
vacancies	16	4	549	4	_vacancies
valancing	15	4	474	4	_valancing
valence	12	6	877	4	_valenc_e_
valences	13	8	851	4	_valenc_es
valencies	14	4	641	4	_valencies
valiance	13	9	739	4	_valianc_e_
valiances	14	8	720	4	_valianc_es
valiancies	15	4	528	4	_valiancies

Search took 10 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	161450	0.453	394461.4
2	DLD Change Limit	161450	70	9.390	17193.8
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	9.876	18093.5