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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
steeks	10	36	1370	(None)
seeks	9	47	2464	1	s_eeks
sleeks	10	45	1246	1	sleeks
smeeks	12	42	843	1	smeeks
steaks	10	44	1585	1	steaks
steeds	7	38	1488	1	steeds
steek	9	54	1800	1	steek_
steels	6	41	1798	1	steels
steeps	8	52	1519	1	steeps
steers	6	38	2098	1	steers
streeks	11	37	871	1	streeks
breeks	12	53	1079	2	breeks
cheeks	15	47	1278	2	cheeks
cleeks	12	50	1054	2	cleeks
creeks	12	48	1292	2	creeks
esteems	9	3	524	2	esteems
geeks	10	49	1584	2	_geeks
gleeks	11	48	967	2	gleeks
keeks	8	47	1725	2	_keeks
leeks	9	53	1889	2	_leeks
peeks	11	50	2111	2	_peeks
reeks	9	41	2403	2	_reeks
sameks	12	40	932	2	sameks
sateens	7	37	1075	2	sateens
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	1850	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
sleek	9	46	1904	2	sleek_
sleeky	13	39	896	2	sleeky
sleeps	8	39	1332	2	sleeps
sleets	6	43	1887	2	sleets
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
stacks	12	43	1726	2	stacks
stakes	10	39	2729	2	stakes
stalks	10	46	1455	2	stalks
stanks	10	49	1770	2	stanks
steads	7	41	1622	2	steads
steak	9	52	1980	2	steak_
steals	6	40	2006	2	steals
steams	8	49	1690	2	steams
steed	6	60	2494	2	stee_d
steeked	12	40	1047	2	steeked
steel	5	57	2199	2	stee_l
steely	9	36	1257	2	steely
steep	7	60	2070	2	stee_p
steer	5	54	2386	2	stee_r
steeve	9	37	1090	2	steeve
steeves	10	34	1090	2	steeves
steins	6	48	1834	2	steins
steles	6	37	2566	2	steles
stems	7	52	1995	2	st_ems
stenos	6	39	1577	2	stenos
stents	6	50	1945	2	stents
steps	7	66	1988	2	st_eps
stereos	7	43	1497	2	stereos
steres	6	39	2953	2	steres
sterns	6	46	1676	2	sterns
stets	5	54	2391	2	st_ets
stews	8	55	1914	2	st_ews
sticks	12	51	1861	2	sticks
sties	5	51	3298	2	stie_s
stinks	10	56	1683	2	stinks
stirks	10	49	1424	2	stirks
stocks	12	47	1563	2	stocks
stokes	10	48	2179	2	stokes
stooks	10	51	1537	2	stooks
storks	10	61	1595	2	storks
streaks	11	44	1127	2	streaks
streek	10	41	1141	2	streek_
streels	7	38	1134	2	streels
streets	7	33	1261	2	streets
streps	8	62	1806	2	streps
stress	6	66	1667	2	stress
strews	9	68	1710	2	strews
styes	8	63	1652	2	stye_s
sweeps	11	41	1051	2	sweeps
sweets	9	42	1443	2	sweets
teaks	9	42	2290	2	_teaks
teels	5	57	2637	2	_teels
teems	7	60	1978	2	_teems
teens	5	62	2748	2	_teens
tees	4	53	5358	2	_tee_s
treks	9	60	1685	2	_treks
weeks	12	50	1786	2	_weeks

Search took 6 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.360	496363.9
2	DLD Change Limit	82551	104	5.063	16304.8
3	Display Results	104	104	0.063	1650.8
	(SQL Overall)	178691	104	5.486	32572.2