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

Here are the results of your fuzzy-string dictionary search for “lichtly” with Change Limit: [1] [2] [3] [4]

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.

94 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
lichtly	15	25	552	(None)
licitly	12	27	667	1	licitly
lightly	14	36	902	1	lightly
licht	10	47	2349	2	licht__
lichted	13	26	880	2	lichted
lichts	11	37	1238	2	licht_s
lithely	13	5	664	2	lithely
nightly	14	44	903	2	nightly
richly	14	3	800	2	rich_ly
rightly	14	38	904	2	rightly
sightly	14	40	827	2	sightly
slightly	15	4	460	2	slightly
tightly	14	32	761	2	tightly
archly	14	3	735	3	arch_ly
bitchily	18	4	453	3	bitchily
blighty	16	35	684	3	blight_y
blithely	16	10	403	3	blithely
brightly	17	6	455	3	brightly
cicely	13	3	883	3	cic_ely
dicotyl	13	4	440	3	dicotyl
dicty	11	51	1629	3	dic_t_y
dicycly	18	4	327	3	dicycly
eighthly	18	4	370	3	eighthly
eighty	13	37	1160	3	eight_y
fickly	18	31	853	3	fic_kly
fifthly	19	4	309	3	fifthly
firstly	13	3	564	3	firstly
fishily	16	3	764	3	fishily
fitly	11	51	1497	3	fi__tly
flichter	16	6	496	3	flichter
flightily	19	4	335	3	flightily
flighty	17	34	743	3	flight_y
highly	16	3	682	3	high_ly
icily	10	12	1169	3	_ic_ily
ickily	15	3	575	3	_ickily
illicitly	14	4	355	3	illicitly
itchily	15	7	449	3	itchily
knightly	19	5	301	3	knightly
lacily	11	6	1276	3	lac_ily
laically	13	3	898	3	laically
laithly	13	3	565	3	laith_ly
lastly	9	33	1087	3	l_astly
lechery	15	25	764	3	lechery
lich	9	62	3084	3	lich___
lichee	11	40	1797	3	lich_ee
lichees	12	35	1278	3	lichees
lichen	11	40	1274	3	lich_en
lichens	12	35	1068	3	lichens
liches	11	47	2429	3	lich_es
lichi	10	44	1295	3	lich__i
lichis	11	52	1259	3	lich_is
lichting	14	26	851	3	lichting
licit	7	43	2768	3	licit__
lictor	8	36	1086	3	lic_tor
liefly	12	6	636	3	li_efly
light	9	44	2960	3	light__
lighted	12	29	1350	3	lighted
lighten	11	28	1152	3	lighten
lighter	11	31	1344	3	lighter
lights	10	45	1991	3	light_s
likely	13	32	813	3	li_kely
lily	7	67	3018	3	li___ly
limply	13	38	1003	3	li_mply
linty	8	71	2656	3	li_nt_y
lithify	16	4	476	3	lithify
little	6	33	1216	3	li_ttle
lively	12	33	1081	3	li_vely
lividly	14	3	478	3	lividly
loathly	13	3	471	3	loathly
locally	12	17	972	3	locally
lucently	13	4	497	3	lucently
lucidly	13	12	521	3	lucidly
luckily	16	29	708	3	luckily
lushly	12	24	734	3	lush_ly
mightily	17	4	462	3	mightily
mighty	15	43	1021	3	might_y
muchly	16	8	620	3	much_ly
nicely	11	3	949	3	nic_ely
nicety	11	3	843	3	nicet_y
nighty	13	56	1127	3	night_y
ninthly	13	4	421	3	ninthly
pitchily	18	5	501	3	pitchily
pithily	15	6	703	3	pithily
pliantly	13	4	578	3	pliantly
plicately	16	4	456	3	plicately
riantly	10	3	761	3	riantly
righty	13	50	1183	3	right_y
sickly	15	31	1048	3	sic_kly
sixthly	20	4	287	3	sixthly
slickly	16	3	585	3	slic_kly
tacitly	12	3	622	3	tacitly
techily	15	3	712	3	techily
vicarly	15	3	646	3	vicarly
vichy	16	3	904	3	vich__y

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	134027	0.406	440125.6
2	DLD Change Limit	134027	94	5.733	23378.2
3	Display Results	94	94	0.033	2848.5
	(SQL Overall)	178691	94	6.172	28951.9