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

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

82 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
kerned	11	41	1292	(None)
keened	11	40	1362	1	keened
kenned	11	44	1126	1	kenned
kerbed	13	33	969	1	kerbed
kerfed	14	35	822	1	kerfed
kerne	9	47	1821	1	kerne_
kernel	10	40	1058	1	kernel
kernes	10	47	1752	1	kernes
kirned	11	40	862	1	kirned
aeried	7	42	2186	2	aeried
barned	9	56	2358	2	barned
beaned	9	56	2147	2	beaned
bermed	11	52	1772	2	bermed
burned	9	58	1896	2	burned
cered	8	52	2744	2	cer_ed
corned	9	52	2452	2	corned
darned	8	50	1848	2	darned
deaned	8	46	2045	2	deaned
denned	8	42	1563	2	denned
durned	8	41	1317	2	durned
earned	7	48	1833	2	earned
erne	4	67	2742	2	_erne_
ernes	5	52	2481	2	_ernes
erred	6	59	1567	2	_erred
girned	8	40	1051	2	girned
herbed	12	35	1345	2	herbed
herded	11	42	1564	2	herded
horned	10	57	1870	2	horned
jeaned	14	38	1346	2	jeaned
jereed	14	40	1206	2	jereed
jerked	18	47	959	2	jerked
kecked	12	51	1316	2	kecked
kedged	13	43	971	2	kedged
keeked	10	48	1011	2	keeked
keeled	11	44	1426	2	keeled
keener	10	40	1283	2	keener
kegged	13	46	924	2	kegged
kelped	13	44	954	2	kelped
kennel	10	36	921	2	kennel
kepped	15	30	953	2	kepped
kermes	12	46	1612	2	kermes
kern	8	53	2621	2	kern__
kerneled	13	4	402	2	kerneled
kernels	11	41	795	2	kernels
kerns	9	47	1956	2	kern_s
kersey	13	3	678	2	kersey
keyed	13	6	938	2	ke_yed
kilned	11	36	839	2	kilned
leaned	7	34	2254	2	leaned
learned	8	32	930	2	learned
merged	10	42	1494	2	merged
neoned	7	3	1148	2	neoned
nerved	10	41	1168	2	nerved
peened	9	43	1815	2	peened
peined	9	49	1884	2	peined
penned	9	42	1761	2	penned
perked	13	46	1768	2	perked
permed	11	52	1734	2	permed
pernod	9	3	1045	2	pernod
reined	7	44	2552	2	reined
seined	7	40	2306	2	seined
sered	6	57	3729	2	ser_ed
serged	8	41	1876	2	serged
served	10	46	1681	2	served
skeined	12	3	677	2	skeined
sorned	7	48	2004	2	sorned
termed	9	48	1670	2	termed
terne	5	64	2615	2	terne_
ternes	6	54	2290	2	ternes
turned	7	39	1447	2	turned
veined	10	44	1391	2	veined
verged	11	48	1515	2	verged
versed	10	45	1551	2	versed
warned	10	40	1891	2	warned
weaned	10	38	1615	2	weaned
weened	10	40	1373	2	weened
yarned	10	55	1402	2	yarned
yeaned	10	38	1390	2	yeaned
yearned	11	32	737	2	yearned
yenned	10	40	938	2	yenned
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.126	1418182.5
2	DLD Change Limit	82551	82	2.813	29346.2
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	2.969	60185.6