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

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

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.

23 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
avenger	11	3	549	(None)
avenge	10	8	755	1	avenge_
avenged	12	4	550	1	avenged
avengers	12	3	558	1	avengers
avenges	11	5	754	1	avenges
amender	10	34	961	2	amender
anger	6	62	2588	2	a__nger
avenses	10	4	964	2	avenses
avenue	9	5	795	2	avenue_
avenues	10	5	718	2	avenues
averter	10	24	1055	2	averter
evener	9	10	1062	2	even_er
lavender	12	3	514	2	lavender
ravener	10	41	1074	2	raven_er
revenger	12	3	730	2	revenger
scavenger	15	4	219	2	scavenger
vender	10	34	1842	2	_vender
veneer	9	45	1169	2	_veneer
venge	9	51	1799	2	_venge_
venged	11	40	1199	2	_venged
venges	10	40	1515	2	_venges
venter	9	42	1872	2	_venter
verger	10	43	1570	2	_verger

Search took 4 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	107671	0.390	458182.1
2	DLD Change Limit	107671	23	3.406	31612.2
3	Display Results	23	23	0.013	1769.2
	(SQL Overall)	178691	23	3.809	46912.8