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

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

45 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
lichee	11	40	1797	(None)
lichees	12	35	1278	1	lichees
lichen	11	40	1274	1	lichen
liches	11	47	2429	1	liches
lychee	14	37	1089	1	lychee
cliche	13	37	1245	2	clich_e
cliched	15	37	1102	2	cliched
cliches	14	42	1374	2	cliches
fiche	13	46	1674	2	fich_e
fiches	14	52	1953	2	fiches
fitchee	15	27	1078	2	fitchee
kimchee	18	4	560	2	kimchee
laches	11	65	2834	2	laches
leched	12	37	1600	2	leched
lecher	11	34	1585	2	lecher
leches	11	54	2131	2	leches
lechwe	14	3	511	2	lechwe
lice	6	60	4506	2	lic__e
lich	9	62	3084	2	lich__
lichened	14	3	575	2	lichened
lichens	12	35	1068	2	lichens
lichi	10	44	1295	2	lich_i
lichis	11	52	1259	2	lichis
licht	10	47	2349	2	lich_t
lichted	13	26	880	2	lichted
lichts	11	37	1238	2	lichts
licked	13	46	2156	2	licked
licker	12	52	2204	2	licker
listee	6	42	2306	2	listee
lithe	8	49	2201	2	lith_e
lither	9	45	2095	2	lither
lycee	10	47	1674	2	lyc_ee
lychees	15	51	678	2	lychees
lyches	14	42	1361	2	lyches
miche	12	62	1924	2	mich_e
miched	14	39	1339	2	miched
miches	13	43	2073	2	miches
niche	10	50	1679	2	nich_e
niched	12	55	1406	2	niched
niches	11	44	1914	2	niches
richen	11	38	1251	2	richen
richer	11	40	1504	2	richer
riches	11	50	2208	2	riches
sickee	12	46	2222	2	sickee
wiches	14	44	1875	2	wiches

Search took 7 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.250	714764.0
2	DLD Change Limit	82551	45	5.986	13790.7
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	6.266	28517.6