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

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

91 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
verged	11	48	1515	(None)
merged	10	42	1494	1	merged
serged	8	41	1876	1	serged
vegged	12	49	1001	1	vegged
venged	11	40	1198	1	venged
verge	9	34	1983	1	verge_
verger	10	43	1569	1	verger
verges	10	43	2017	1	verges
versed	10	45	1551	1	versed
aeried	7	42	2186	2	aeried
avenged	12	4	550	2	avenged
averaged	13	5	621	2	averaged
averred	11	23	759	2	averred
averted	11	22	1161	2	averted
barged	10	58	2264	2	barged
begged	11	50	1380	2	begged
bermed	11	52	1772	2	bermed
cered	8	52	2744	2	cer_ed
diverged	14	25	688	2	diverged
edged	8	55	1451	2	_edged
egged	8	51	1438	2	_egged
emerged	11	15	821	2	emerged
erred	6	59	1567	2	_erred
everted	11	27	1185	2	everted
forged	11	55	1932	2	forged
gorged	9	50	1698	2	gorged
gurged	9	55	1336	2	gurged
hedged	12	52	1179	2	hedged
herbed	12	35	1345	2	herbed
herded	11	42	1564	2	herded
jereed	14	40	1206	2	jereed
jerked	18	47	959	2	jerked
kedged	13	43	971	2	kedged
kegged	13	46	924	2	kegged
kerbed	13	33	969	2	kerbed
kerfed	14	35	822	2	kerfed
kerned	11	41	1292	2	kerned
legged	9	57	1308	2	legged
merge	8	45	2368	2	merge_
mergee	9	40	1813	2	mergee
merger	9	50	1647	2	merger
merges	9	41	2248	2	merges
nerved	10	41	1168	2	nerved
overaged	13	5	1167	2	overaged
overbed	13	28	1184	2	overbed
overed	10	22	1662	2	over_ed
overfed	14	25	1025	2	overfed
parged	10	49	2203	2	parged
pegged	11	48	1190	2	pegged
perked	13	46	1768	2	perked
permed	11	52	1734	2	permed
purged	10	49	1826	2	purged
sered	6	57	3729	2	ser_ed
serge	6	47	2746	2	serge_
serger	7	38	1973	2	serger
serges	7	42	2596	2	serges
served	10	46	1681	2	served
surged	8	41	1888	2	surged
termed	9	48	1670	2	termed
urged	7	53	1603	2	_urged
varied	10	48	1786	2	varied
varved	13	41	1060	2	varved
vealed	10	39	1632	2	vealed
veered	10	36	1274	2	veered
veges	9	41	1886	2	ve_ges
veiled	10	37	1454	2	veiled
veined	10	44	1391	2	veined
vended	11	44	1635	2	vended
venge	9	51	1798	2	venge_
venges	10	40	1514	2	venges
vented	10	46	1792	2	vented
verbid	12	23	1131	2	verbid
vergers	11	44	1262	2	vergers
verier	9	46	2096	2	verier
vermes	11	50	1914	2	vermes
verse	8	47	2358	2	verse_
verser	9	45	1696	2	verser
verses	9	42	2376	2	verses
verset	9	43	2732	2	verset
vertex	16	3	737	2	vertex
verve	11	54	1772	2	verve_
verves	12	46	1788	2	verves
vervet	12	46	1906	2	vervet
vested	10	42	1735	2	vested
vetoed	10	35	982	2	vetoed
vetted	10	43	1632	2	vetted
vexed	16	57	1311	2	ve_xed
wedged	12	51	1027	2	wedged
wergeld	12	3	318	2	wergeld
yerked	14	50	937	2	yerked
zeroed	16	40	941	2	zeroed

Search took 3 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	82551	0.110	1624463.6
2	DLD Change Limit	82551	91	2.610	31628.7
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	2.750	64978.5