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

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

95 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
sleeks	10	45	1246	(None)
cleeks	12	50	1054	1	cleeks
gleeks	11	48	967	1	gleeks
leeks	9	53	1889	1	_leeks
seeks	9	47	2464	1	s_eeks
sleek	9	46	1904	1	sleek_
sleeky	13	39	896	1	sleeky
sleeps	8	39	1332	1	sleeps
sleets	6	43	1887	1	sleets
smeeks	12	42	843	1	smeeks
steeks	10	36	1370	1	steeks
bleaks	12	51	1243	2	bleaks
bleeds	9	52	1159	2	bleeds
bleeps	10	49	910	2	bleeps
breeks	12	53	1079	2	breeks
cheeks	15	47	1278	2	cheeks
cleek	11	55	1491	2	cleek_
clerks	12	45	884	2	clerks
creeks	12	48	1292	2	creeks
flecks	15	43	1080	2	flecks
fleers	9	60	1579	2	fleers
flees	8	58	2875	2	flee_s
fleets	9	69	1506	2	fleets
geeks	10	49	1584	2	_geeks
gleeds	8	47	1162	2	gleeds
gleek	10	53	1510	2	gleek_
glees	6	50	2759	2	glee_s
gleets	7	53	1505	2	gleets
keeks	8	47	1725	2	_keeks
leaks	9	59	2391	2	_leaks
leek	8	53	3173	2	_leek_
leers	5	48	2898	2	_leers
lees	4	54	5588	2	_lee_s
leets	5	49	2712	2	_leets
leks	8	54	2760	2	_l_eks
peeks	11	50	2111	2	_peeks
reeks	9	41	2403	2	_reeks
sameks	12	40	932	2	sameks
seeds	6	43	3006	2	s_eeds
seek	8	59	3548	2	s_eek_
seels	5	56	3282	2	s_eels
seems	7	55	2502	2	s_eems
seeps	7	48	2875	2	s_eeps
seers	5	51	3638	2	s_eers
sees	4	53	6105	2	s_ee_s
sheens	9	51	1699	2	sheens
sheers	9	43	2240	2	sheers
sheets	9	39	1849	2	sheets
sheiks	13	25	1001	2	sheiks
skeens	10	39	1291	2	skeens
skees	9	50	2312	2	skee_s
skeets	10	45	1325	2	skeets
slacks	12	44	1653	2	slacks
slakes	10	40	2188	2	slakes
sleds	6	44	1885	2	sl_eds
sleeked	12	35	1088	2	sleeked
sleeken	11	32	680	2	sleeken
sleekens	12	27	487	2	sleekens
sleeker	11	33	982	2	sleeker
sleekers	12	37	799	2	sleekers
sleekest	12	3	615	2	sleekest
sleekit	11	4	545	2	sleekit
sleekly	14	32	518	2	sleekly
sleep	7	49	2018	2	slee_p
sleepy	11	47	941	2	sleepy
sleet	5	56	3913	2	slee_t
sleety	9	41	1265	2	sleety
sleeve	9	34	1159	2	sleeve
sleeves	10	33	1134	2	sleeves
slews	8	62	2035	2	sl_ews
slicks	12	48	1611	2	slicks
slinks	10	43	1515	2	slinks
sloes	5	47	2887	2	sloe_s
slues	5	45	2717	2	slue_s
smeek	11	49	1235	2	smeek_
smerks	12	44	971	2	smerks
sneaks	10	43	1249	2	sneaks
snecks	12	44	1003	2	snecks
sneers	6	40	1617	2	sneers
speaks	12	51	1458	2	speaks
specks	14	43	1270	2	specks
speeds	9	43	1605	2	speeds
speels	8	51	1639	2	speels
speers	8	50	1995	2	speers
spleens	9	3	710	2	spleens
steaks	10	44	1585	2	steaks
steeds	7	38	1488	2	steeds
steek	9	54	1800	2	steek_
steels	6	41	1798	2	steels
steeps	8	52	1519	2	steeps
steers	6	38	2098	2	steers
streeks	11	37	871	2	streeks
sweeps	11	41	1051	2	sweeps
sweets	9	42	1443	2	sweets
weeks	12	50	1786	2	_weeks

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.126	1418182.5
2	DLD Change Limit	82551	95	6.436	12826.4
3	Display Results	95	95	0.063	1507.9
	(SQL Overall)	178691	95	6.625	26972.2