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

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

80 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
alkies	10	45	1809	(None)
alkie	9	55	2003	1	alkie_
alkines	11	44	1573	1	alkines
allies	6	38	2767	1	allies
talkies	11	34	1573	1	talkies
ackees	12	49	1458	2	ackees
aeries	6	47	3778	2	aeries
aggies	8	35	1551	2	aggies
akees	9	61	1924	2	a_kees
alates	6	48	3397	2	alates
albites	9	3	1320	2	albites
alcids	9	48	1229	2	alcids
ales	4	70	6710	2	al__es
algins	7	48	1643	2	algins
alias	5	58	3460	2	al_ias
alibies	9	3	1332	2	alibies
alien	5	64	2558	2	al_ien
aliens	6	56	1921	2	al_iens
alifs	8	61	2126	2	al_ifs
alike	9	55	2396	2	alike_
alines	6	57	3522	2	alines
alkalies	12	15	854	2	alkalies
alkanes	11	38	1293	2	alkanes
alkenes	11	42	1275	2	alkenes
alkine	10	49	1680	2	alkine
alkyds	14	40	436	2	alkyds
alkyls	13	46	572	2	alkyls
alkynes	14	33	646	2	alkynes
allees	6	45	2148	2	allees
allied	7	42	1715	2	allied
almes	7	51	2654	2	al_mes
aloes	5	49	3367	2	al_oes
aloins	6	50	2220	2	aloins
alpines	9	40	1619	2	alpines
alsikes	11	3	726	2	alsikes
amies	7	68	3769	2	a_mies
ankles	10	48	1838	2	ankles
armies	8	51	2369	2	armies
baldies	10	53	1770	2	baldies
balkier	13	41	1198	2	balkier
balkiest	14	41	1245	2	balkiest
ballies	9	37	2574	2	ballies
bikies	12	45	1516	2	bikies
calkins	13	38	1487	2	calkins
dallies	8	40	2319	2	dallies
darkies	12	40	1575	2	darkies
falsies	10	35	1501	2	falsies
flies	8	56	3071	2	fl_ies
folkies	14	36	1225	2	folkies
gallies	8	41	2271	2	gallies
gawkies	15	42	912	2	gawkies
hackies	16	34	1824	2	hackies
hankies	14	36	1776	2	hankies
hawkies	17	33	1124	2	hawkies
jackies	20	29	1262	2	jackies
ladies	7	51	2488	2	ladies
lakes	9	57	3765	2	lak_es
lakier	10	47	1627	2	lakier
lakiest	11	35	1727	2	lakiest
lazies	15	44	1878	2	lazies
lies	4	64	5419	2	_l_ies
likes	9	62	3190	2	_likes
malkins	13	33	1180	2	malkins
oldies	7	3	1442	2	oldies
palsies	9	44	2027	2	palsies
plies	7	45	2651	2	pl_ies
pokies	12	59	2133	2	pokies
rallies	7	38	2334	2	rallies
sallies	7	32	2781	2	sallies
salties	7	37	2577	2	salties
selkies	11	35	1335	2	selkies
silkies	11	37	1569	2	silkies
skies	9	50	2683	2	_skies
sulkies	11	43	1576	2	sulkies
talkie	10	39	1444	2	talkie_
talkier	11	40	1184	2	talkier
talkiest	12	36	1122	2	talkiest
tallies	7	36	2460	2	tallies
walies	9	53	2452	2	wal_ies
wallies	10	33	2074	2	wallies

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.343	520965.0
2	DLD Change Limit	82551	80	2.500	33020.4
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	2.873	62196.7