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

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

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.

72 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
twitchier	17	5	323	(None)
twitcher	16	13	534	1	twitch_er
witchier	16	30	788	1	_witchier
bitchier	15	30	773	2	_bitchier
glitchier	15	4	279	2	glitchier
itchier	12	24	767	2	__itchier
pitchier	15	36	827	2	_pitchier
switcher	16	17	768	2	switch_er
tetchier	13	3	645	2	t_etchier
thatchier	17	4	398	2	thatchier
twitched	17	15	503	2	twitch_ed
twitchers	17	13	453	2	twitch_ers
twitches	16	15	637	2	twitch_es
twitchiest	18	4	296	2	twitchiest
twitchily	20	5	219	2	twitchily
twitching	18	3	424	2	twitching
withier	13	29	1049	2	_wit_hier
bewitcher	19	4	300	3	bewitch_er
blotchier	16	4	321	3	blotchier
botchier	15	28	714	3	_botchier
catchier	15	32	986	3	_catchier
chichier	18	3	602	3	chi_chier
chinchier	19	4	463	3	chinchier
ditcher	13	40	1200	3	_ditch_er
dowitcher	18	4	259	3	dowitch_er
hitcher	15	37	1200	3	_hitch_er
kvetchier	21	4	186	3	kvetchier
nitchie	12	4	723	3	_nitchie_
nitchies	13	3	907	3	_nitchies
patchier	15	31	966	3	_patchier
pitcher	14	38	1371	3	_pitch_er
pithier	12	30	1029	3	_pit_hier
sketchier	18	5	341	3	sketchier
smutchier	16	4	350	3	smutchier
snatchier	14	5	535	3	snatchier
snitcher	13	15	737	3	snitch_er
stitcher	13	16	839	3	stitch_er
stretchier	15	4	448	3	stretchier
swishier	14	3	456	3	swi_shier
switched	17	15	713	3	switch_ed
switchers	17	14	663	3	switch_ers
switches	16	15	913	3	switch_es
switching	18	3	570	3	switching
switchmen	19	6	242	3	switchmen
swither	13	37	1099	3	swit_h_er
techier	12	6	924	3	t__echier
thatcher	16	3	566	3	thatch_er
thither	13	32	810	3	thit_h_er
tither	9	49	2028	3	t_it_h_er
toothier	11	3	642	3	toot_hier
torchier	13	3	746	3	t_orchier
touchier	13	4	738	3	t_ouchier
trickier	14	30	1023	3	tri_ckier
twiddlier	14	4	186	3	twiddlier
twiggier	13	3	307	3	twi_ggier
twinier	10	3	731	3	twi__nier
twirlier	11	3	351	3	twi_rlier
twistier	11	3	481	3	twi_stier
twitch	14	40	616	3	twitch___
twitchy	18	39	357	3	twitch__y
twitter	10	27	809	3	twit__ter
twitterer	12	4	330	3	twitterer
watcher	15	31	1340	3	_watch_er
wincher	15	34	1065	3	_winch_er
witched	16	30	1219	3	_witch_ed
witchery	19	23	609	3	_witch_ery
witches	15	27	1579	3	_witch_es
witchiest	17	3	631	3	_witchiest
witching	17	34	1063	3	_witching
wither	12	43	2135	3	_wit_h_er
withies	13	39	1354	3	_wit_hies
wittier	10	39	1082	3	_wit_tier

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	148641	0.453	394461.4
2	DLD Change Limit	148641	72	6.266	23721.8
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	6.752	26464.9