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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
egger	7	44	1441	(None)
agger	7	64	2089	1	agger
eager	6	55	2697	1	eager
edger	7	52	1595	1	edger
eger	5	59	2357	1	e_ger
eggar	7	45	888	1	eggar
egged	8	51	1439	1	egged
eggers	8	46	1258	1	eggers
kegger	12	38	808	1	kegger
ager	5	59	3584	2	_ager
aggers	8	58	1779	2	aggers
anger	6	62	2587	2	anger
auger	6	49	2247	2	auger
bagger	10	46	1920	2	bagger
beggar	10	32	822	2	beggar
begged	11	50	1381	2	begged
bigger	10	43	1506	2	bigger
bugger	10	44	1872	2	bugger
cager	8	52	2922	2	cager
dagger	9	50	1730	2	dagger
digger	9	46	1608	2	digger
dogger	9	52	1678	2	dogger
eagers	7	45	2368	2	eagers
eagre	6	43	1532	2	eagre
eater	5	46	3984	2	eater
edge	6	57	1968	2	edge_
edged	8	55	1453	2	edged
edgers	8	44	1392	2	edgers
edges	7	57	1874	2	edges
edgier	8	46	973	2	edgier
egers	6	51	2037	2	e_gers
egg	5	69	1867	2	egg__
eggars	8	39	897	2	eggars
eggs	6	65	1615	2	egg_s
eggy	9	66	1185	2	egg_y
egret	6	33	2731	2	egret
eider	6	46	2474	2	eider
elder	6	40	2002	2	elder
elver	8	52	1624	2	elver
ember	9	55	1680	2	ember
emeer	7	48	1536	2	emeer
emmer	9	43	1446	2	emmer
ender	6	43	2586	2	ender
engager	9	27	860	2	engager
enter	5	47	2638	2	enter
esker	9	44	1298	2	esker
ester	5	47	2771	2	ester
ether	8	45	1877	2	ether
ever	7	70	2769	2	e_ver
ewer	7	75	2398	2	e_wer
eyer	7	61	2728	2	e_yer
fogger	11	44	1478	2	fogger
gager	7	47	2629	2	gager
gagger	9	50	1651	2	gagger
goer	5	68	2710	2	_goer
hedger	11	49	1265	2	hedger
hogger	11	46	1508	2	hogger
huger	9	49	1487	2	huger
hugger	11	47	1312	2	hugger
igged	8	60	1276	2	igged
jager	13	43	1813	2	jager
jagger	15	40	1600	2	jagger
jigger	15	53	1305	2	jigger
jogger	15	47	1316	2	jogger
kegged	13	46	926	2	kegged
keggers	13	35	704	2	keggers
kegler	11	39	824	2	kegler
lager	6	51	3286	2	lager
lagger	8	59	1983	2	lagger
ledger	8	59	1439	2	ledger
leger	6	57	2151	2	leger
legged	9	57	1309	2	legged
leggier	9	36	823	2	leggier
liger	6	50	2447	2	liger
logger	8	64	2000	2	logger
luger	6	53	2208	2	luger
lugger	8	39	1655	2	lugger
meager	9	45	1520	2	meager
merger	9	50	1648	2	merger
mugger	10	39	1470	2	mugger
nagger	8	40	1612	2	nagger
nigger	8	97	1357	2	nigger
ogler	6	59	1744	2	ogler
pager	8	47	2820	2	pager
pegged	11	48	1191	2	pegged
rigger	8	56	1671	2	rigger
roger	6	45	2141	2	roger
rugger	8	44	1451	2	rugger
sager	6	54	3205	2	sager
sagger	8	43	2107	2	sagger
seggar	8	35	781	2	seggar
serger	7	38	1974	2	serger
tagger	8	40	1770	2	tagger
tiger	6	57	1863	2	tiger
tugger	8	40	1310	2	tugger
urger	6	41	1647	2	urger
vegged	12	49	1002	2	vegged
verger	10	43	1570	2	verger
wager	9	59	2505	2	wager
wagger	11	36	1601	2	wagger
yager	9	56	1675	2	yager

Search took 5 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	53800	0.640	279204.7
2	DLD Change Limit	53800	101	3.563	15099.6
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	4.233	42213.8