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

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

49 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
stricks	13	43	1069	(None)
sticks	12	51	1861	1	st_icks
strick	12	48	1320	1	strick_
tricks	12	53	1901	1	_tricks
astricts	10	4	946	2	astricts
bricks	14	46	1462	2	_bricks
cricks	14	43	1605	2	_cricks
pricks	14	44	1426	2	_pricks
ricks	11	51	2613	2	__ricks
shrieks	14	37	767	2	shrieks
shrinks	14	39	791	2	shrinks
shticks	16	35	696	2	shticks
sicks	11	51	2762	2	s__icks
slicks	12	48	1611	2	s_licks
snicks	12	43	1247	2	s_nicks
spicks	14	48	1499	2	s_picks
stacks	12	43	1726	2	st_acks
stichs	11	45	1165	2	st_ichs
stick	11	51	2156	2	st_ick_
sticky	15	47	1134	2	st_icky
stinks	10	56	1683	2	st_inks
stirks	10	49	1424	2	st_irks
stocks	12	47	1563	2	st_ocks
stoics	8	3	1111	2	stoic_s
streaks	11	44	1127	2	streaks
streeks	11	37	871	2	streeks
stricken	14	3	689	2	stricken
strickle	14	6	779	2	strickle
strickles	15	6	781	2	strickles
strict	8	48	2104	2	stric_t
strides	8	45	2039	2	strides
strifes	10	47	1658	2	strifes
strike	10	56	1973	2	stri_ke
strikes	11	47	1909	2	strikes
strings	8	46	1713	2	strings
stripes	9	53	2057	2	stripes
strips	8	57	1965	2	stri_ps
strives	10	41	1937	2	strives
struck	12	48	926	2	struck_
thicks	15	45	1199	2	_thicks
ticks	11	58	2329	2	_t_icks
tracks	12	48	1884	2	_tracks
trices	8	48	2633	2	_trices
trick	11	54	2069	2	_trick_
tricksy	16	43	658	2	_tricksy
tricky	15	42	1147	2	_tricky
trocks	12	36	1463	2	_trocks
trucks	12	47	1197	2	_trucks
wricks	15	46	1062	2	_wricks

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	49	3.440	31299.7
3	Display Results	49	49	0.013	3769.2
	(SQL Overall)	178691	49	3.826	46704.4