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

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

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

111 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
stickseeds	17	7	238	(None)
stickseed	16	8	348	1	stickseed_
stickweeds	20	8	244	1	stickweeds
tickseeds	16	7	322	1	_tickseeds
stickweed	19	8	338	2	stickweed_
stinkweeds	18	8	193	2	stinkweeds
tickseed	15	8	451	2	_tickseed_
chickweeds	25	4	212	3	chickweeds
sickbeds	17	25	421	3	s_ick_beds
sickees	13	45	1421	3	s_ick_ee_s
silkweeds	17	4	260	3	s_ilkweeds
slicksters	16	4	338	3	slicksters
sticked	14	41	1463	3	stick__ed_
stickers	14	29	1303	3	stick__ers
stickies	14	22	1197	3	stick_ie_s
stickiness	16	3	590	3	stickiness
stickled	15	29	897	3	stick_led_
sticklers	15	22	739	3	stick_lers
stickles	14	25	1210	3	stick_le_s
stinkweed	17	6	248	3	stinkweed_
aniseeds	9	4	439	4	ani__seeds
birdseeds	13	4	224	4	_birdseeds
chickees	19	25	851	4	chick_ee_s
chickweed	24	4	316	4	chickweed_
dickheads	20	4	363	4	_dickheads
duckweeds	20	4	240	4	_duckweeds
linseeds	9	4	473	4	_li_nseeds
milksheds	19	4	173	4	_milksheds
milkweeds	19	4	278	4	_milkweeds
oilseeds	9	4	370	4	_oi_lseeds
pickeers	16	34	724	4	_pick_eers
quicksands	26	5	161	4	quicksands
quicksets	24	4	238	4	quicks_ets
quicksteps	27	5	148	4	quicksteps
richweeds	18	13	281	4	_richweeds
rockweeds	19	4	283	4	_rockweeds
screeds	10	62	1029	4	s__c_reeds
shickered	19	11	572	4	shickered_
shickers	17	30	1282	4	shick__ers
shicksas	17	4	352	4	shicks__as
shiksehs	18	9	209	4	shi_ks_ehs
shikses	14	11	657	4	shi_ks_e_s
sickbed	16	39	682	4	s_ick_bed_
sicked	13	45	2440	4	s_ick__ed_
sickee	12	46	2222	4	s_ick_ee__
sickened	15	4	678	4	s_ickened_
sickeners	15	3	573	4	s_ickeners
sickens	13	44	1148	4	s_ick__ens
sickies	13	37	1750	4	s_ick_ie_s
sickled	14	47	1343	4	s_ick_led_
sickles	13	34	1754	4	s_ick_le_s
sicklied	15	4	658	4	s_icklied_
sicklies	14	7	1001	4	s_icklie_s
sickness	14	3	783	4	s_ick_ness
silkweed	16	4	322	4	s_ilkweed_
skunkweeds	17	6	112	4	skunkweeds
slicked	14	44	1384	4	slick__ed_
slickened	16	4	429	4	slickened_
slickeners	16	4	366	4	slickeners
slickens	14	31	726	4	slick__ens
slickers	14	31	1255	4	slick__ers
slickness	15	3	590	4	slick_ness
slickster	15	4	341	4	slickste_r
snicked	14	38	1163	4	snick__ed_
snickered	16	11	534	4	snickered_
snickerers	16	13	358	4	snickerers
snickers	14	30	1096	4	snick__ers
stacked	14	34	1612	4	stack__ed_
stackers	14	34	1356	4	stack__ers
stackless	15	5	593	4	stack_less
steeds	7	38	1488	4	st____eeds
stickballs	18	5	281	4	stickballs
sticker	13	35	1588	4	stick__e_r
stickfuls	18	4	258	4	stick_fuls
stickier	14	22	976	4	stick_ie_r
stickiest	15	22	960	4	stick_iest
stickle	13	24	1097	4	stick_le__
stickler	14	25	957	4	stick_le_r
stickmen	16	3	454	4	stick_me_n
stickouts	15	5	397	4	stick_outs
stickpins	17	4	409	4	stick_pins
sticks	12	51	1861	4	stick____s
stickums	16	4	394	4	stick__ums
stickups	16	4	330	4	stick__ups
stickworks	18	11	333	4	stickworks
stinkards	14	4	356	4	stink_ards
stinkers	12	31	1113	4	stink__ers
stinkwoods	18	5	274	4	stinkwoods
stipends	11	30	479	4	sti__pends
stockaded	17	4	353	4	stockaded_
stockades	16	4	443	4	stockade_s
stockages	16	4	492	4	stockage_s
stocked	14	43	1287	4	stock__ed_
stockers	14	34	1107	4	stock__ers
stockiness	16	4	524	4	stockiness
stockinets	16	4	353	4	stockinets
stockyards	20	10	219	4	stockyards
strickled	16	6	583	4	strick_led_
strickles	15	6	781	4	strick_le_s
succeeds	13	4	369	4	s_uc_ceeds
thickheads	23	4	249	4	thickheads
thicksets	18	26	373	4	thicks_ets
ticked	13	47	2052	4	_tick__ed_
tickers	13	36	1772	4	_tick__ers
ticketed	15	14	664	4	_ticketed_
tickets	13	41	1368	4	_tick__ets
tickled	14	43	1313	4	_tick_led_
ticklers	14	33	930	4	_tick_lers
tickles	13	34	1685	4	_tick_le_s
tricksters	16	26	476	4	tricksters
witchweeds	22	5	191	4	witchweeds

Search took 10 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	161450	0.436	409841.7
2	DLD Change Limit	161450	111	9.360	17248.9
3	Display Results	111	111	0.063	1761.9
	(SQL Overall)	178691	111	9.859	18124.7