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

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

91 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
stich	10	41	1792	(None)
stichs	11	45	1165	1	stichs
stick	11	51	2156	1	stick
stitch	11	41	910	1	stitch
aitch	10	52	1616	2	aitch
bitch	12	50	1776	2	bitch
distich	13	3	1217	2	distich
ditch	11	50	1509	2	ditch
etch	9	54	1914	2	et_ch
etic	6	61	2395	2	etic_
fetich	14	7	969	2	fetich
fitch	13	48	1687	2	fitch
hitch	13	45	1547	2	hitch
ich	8	62	2774	2	__ich
itch	9	56	1917	2	it_ch
laich	10	59	2071	2	laich
lich	9	62	3084	2	_lich
ostrich	12	3	866	2	ostrich
otic	6	66	2482	2	otic_
pitch	12	50	1841	2	pitch
rich	9	70	2554	2	_rich
saice	7	54	2405	2	saice
saith	8	58	2655	2	saith
sauch	10	49	1877	2	sauch
seiche	11	8	1183	2	seiche
shtick	15	30	802	2	shtick
sic	5	58	4787	2	s_ic_
sice	6	55	4559	2	s_ice
sick	10	64	3557	2	s_ick
sics	6	52	3409	2	s_ics
sidh	8	62	2299	2	s_idh
sigh	8	56	2589	2	s_igh
sinh	7	62	3804	2	s_inh
sith	7	54	3515	2	s_ith
slice	7	49	2582	2	slice
slick	11	55	2052	2	slick
smirch	13	5	646	2	smirch
smith	10	78	1805	2	smith
snick	11	44	1601	2	snick
snitch	11	35	794	2	snitch
spic	8	52	2743	2	spic_
spica	9	47	1794	2	spica
spice	9	55	2881	2	spice
spick	13	45	1907	2	spick
spics	9	41	2324	2	spics
spicy	12	54	1771	2	spicy
stack	11	44	2169	2	stack
stanch	11	38	1237	2	stanch
staph	10	43	1465	2	staph
starch	11	30	1320	2	starch
stash	8	49	1697	2	stash
stench	11	41	1116	2	stench
stichic	14	4	624	2	stichic
sticks	12	51	1861	2	sticks
sticky	15	47	1134	2	sticky
stied	6	57	2303	2	stied
sties	5	51	3298	2	sties
stiff	11	42	1924	2	stiff
stile	5	49	3157	2	stile
still	5	49	2208	2	still
stilt	5	48	3198	2	stilt
stime	7	65	2180	2	stime
stimy	10	51	1474	2	stimy
sting	6	53	3024	2	sting
stink	9	51	2250	2	stink
stint	5	70	3766	2	stint
stipe	7	65	2337	2	stipe
stir	4	57	2325	2	sti_r
stirk	9	57	1741	2	stirk
stirp	7	68	1550	2	stirp
stirs	5	59	2162	2	stirs
stithy	12	39	821	2	stithy
stock	11	44	1756	2	stock
stoic	7	3	1725	2	stoic_
stoics	8	3	1111	2	stoics
strick	12	48	1320	2	strick
strict	8	48	2104	2	strict
stuck	11	45	1577	2	stuck
such	9	64	2481	2	s_uch
swish	11	51	1482	2	swish
switch	14	45	891	2	switch
swith	11	59	1740	2	swith
synch	13	50	1179	2	synch
tach	9	61	3275	2	_tach
tech	9	59	2544	2	_tech
tic	5	63	4346	2	_tic_
tick	10	62	3122	2	_tick
tics	6	57	2963	2	_tics
which	16	39	1008	2	which
wich	12	57	2474	2	_wich
witch	13	45	1756	2	witch

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	91	1.576	34137.1
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	1.919	93116.7