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

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

58 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
lichts	11	37	1238	(None)
liches	11	47	2429	1	liches
lichis	11	52	1259	1	lichis
licht	10	47	2349	1	licht_
lights	10	45	1991	1	lights
alights	11	32	1143	2	alights
bights	12	44	1796	2	bights
blights	13	31	1021	2	blights
cliches	14	42	1374	2	cliches
dicots	9	49	1579	2	dicots
dights	11	40	1696	2	dights
eights	10	36	1898	2	eights
elicits	9	3	1123	2	elicits
fiches	14	52	1953	2	fiches
fichus	14	38	811	2	fichus
fights	13	38	1655	2	fights
flights	14	33	1098	2	flights
hights	13	37	1689	2	hights
ichs	9	62	1471	2	_ich_s
laches	11	65	2835	2	laches
laichs	11	51	1089	2	laich_s
leches	11	54	2131	2	leches
lich	9	62	3085	2	lich__
lichee	11	40	1797	2	lichee
lichees	12	35	1278	2	lichees
lichen	11	40	1274	2	lichen
lichens	12	35	1068	2	lichens
lichi	10	44	1295	2	lich_i
lichted	13	26	880	2	lichted
lichtly	15	25	552	2	lichtly
licit	7	43	2768	2	licit_
licks	11	53	2539	2	lic_ks
lifts	8	57	1906	2	li_fts
light	9	44	2960	2	light_
lilts	5	58	2280	2	li_lts
limits	8	25	1414	2	limits
lints	5	71	3719	2	li_nts
lists	5	66	2869	2	li_sts
litchis	12	3	837	2	litchis
lithos	9	42	1255	2	lithos
lits	4	62	5250	2	li__ts
lochs	10	67	1551	2	loch_s
lyches	14	42	1361	2	lyches
miches	13	43	2073	2	miches
mights	12	35	1625	2	mights
niches	11	44	1914	2	niches
nights	10	41	1772	2	nights
picots	10	46	1644	2	picots
plights	13	29	931	2	plights
riches	11	50	2208	2	riches
rights	10	40	1933	2	rights
sights	10	38	1801	2	sights
slights	11	28	1072	2	slights
tights	10	40	1585	2	tights
wechts	14	4	625	2	wechts
wiches	14	44	1875	2	wiches
wights	13	33	1578	2	wights
yachts	14	3	702	2	yachts

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	82551	0.343	520965.0
2	DLD Change Limit	82551	58	3.390	24351.3
3	Display Results	58	58	0.016	3625.0
	(SQL Overall)	178691	58	3.749	47663.6