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

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

92 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
likens	10	56	1370	(None)
liens	5	65	2550	1	li_ens
liken	9	118	1884	1	liken_
likers	10	46	2091	1	likers
likes	9	62	3190	1	like_s
limens	8	46	1803	1	limens
linens	6	48	1839	1	linens
livens	9	43	1489	1	livens
aliens	6	56	1921	2	ali_ens
bikers	12	45	1755	2	bikers
bikes	11	75	2947	2	bike_s
dickens	14	44	1013	2	dickens
dikers	11	44	1879	2	dikers
dikes	10	58	3133	2	dike_s
dizens	16	49	1139	2	dizens
eikons	10	3	850	2	eikons
givens	10	37	973	2	givens
hikers	13	50	1435	2	hikers
hikes	12	54	2698	2	hike_s
ikons	9	63	1101	2	_ikons
kens	8	54	3523	2	__kens
kikes	8	51	2255	2	kike_s
ladens	7	45	1623	2	ladens
lakers	10	52	2515	2	lakers
lakes	9	57	3765	2	lake_s
latens	6	46	2021	2	latens
lebens	8	3	1009	2	lebens
lens	4	61	4649	2	l__ens
lianes	6	38	1932	2	lianes
libels	8	51	1269	2	libels
libers	8	47	2144	2	libers
license	9	14	842	2	license
lichens	12	35	1068	2	lichens
lickers	13	41	1825	2	lickers
lien	4	53	3980	2	li_en_
liers	5	51	3040	2	li_ers
lies	4	64	5419	2	li_e_s
lieus	5	62	1848	2	li_eus
lifers	9	56	1784	2	lifers
ligans	7	68	1773	2	ligans
ligers	7	50	2203	2	ligers
like	8	60	4084	2	like__
liked	10	45	2381	2	like_d
likely	13	32	813	2	likely
likened	12	26	735	2	likened
likeness	12	22	986	2	likeness
liker	9	56	2706	2	like_r
likest	10	49	1438	2	likest
liking	11	43	1958	2	liking
likings	12	53	941	2	likings
limans	8	48	1630	2	limans
limen	7	54	2603	2	limen_
limes	7	56	3650	2	lime_s
limeys	11	42	927	2	limeys
limns	7	57	1839	2	li_mns
lindens	8	3	941	2	lindens
linen	5	57	2872	2	linen_
lineny	9	40	1144	2	lineny
liners	6	54	2885	2	liners
lines	5	70	5457	2	line_s
linins	6	59	2214	2	linins
linkers	11	43	1771	2	linkers
linns	5	61	2333	2	li_nns
lins	4	70	5905	2	li__ns
lions	5	59	2321	2	li_ons
lipins	8	50	1688	2	lipins
lippens	11	32	853	2	lippens
listens	7	40	1413	2	listens
liters	6	54	2987	2	liters
liven	8	50	2173	2	liven_
livers	9	49	2782	2	livers
lives	8	61	3319	2	live_s
lodens	7	43	1506	2	lodens
lumens	8	50	1397	2	lumens
miens	7	61	1830	2	mi_ens
mikes	11	51	2989	2	mike_s
mizens	17	46	1025	2	mizens
pikers	12	47	1739	2	pikers
pikes	11	50	3103	2	pike_s
pinkens	13	41	964	2	pinkens
ripens	8	50	1217	2	ripens
sickens	13	44	1148	2	sickens
sikes	9	62	3608	2	sike_s
sirens	6	53	1815	2	sirens
slickens	14	31	726	2	slickens
tikes	9	56	2890	2	tike_s
tokens	10	47	1156	2	tokens
vixens	16	28	620	2	vixens
wakens	13	50	1204	2	wakens
widens	10	62	1272	2	widens
wizens	18	61	1026	2	wizens
yikes	12	51	1775	2	yike_s

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.110	1624463.6
2	DLD Change Limit	82551	92	2.813	29346.2
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	2.953	60511.7