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

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

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

223 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
switcher	16	17	768	(None)
snitcher	13	15	737	1	snitcher
stitcher	13	16	839	1	stitcher
switched	17	15	713	1	switched
switchers	17	14	663	1	switchers
switches	16	15	913	1	switches
swither	13	37	1099	1	swit_her
twitcher	16	13	534	1	twitcher
bewitcher	19	4	300	2	bewitcher
ditcher	13	40	1200	2	_ditcher
dowitcher	18	4	259	2	dowitcher
hitcher	15	37	1200	2	_hitcher
pitcher	14	38	1371	2	_pitcher
scutcher	15	17	696	2	scutcher
sketcher	17	3	543	2	sketcher
slither	10	41	1298	2	slit_her
snatcher	13	16	776	2	snatcher
snitched	14	16	686	2	snitched
snitchers	14	16	604	2	snitchers
snitches	13	14	898	2	snitches
stitched	14	14	820	2	stitched
stitchers	14	14	701	2	stitchers
stitchery	17	17	407	2	stitchery
stitches	13	14	1059	2	stitches
swatches	16	16	996	2	swatches
swather	13	42	1360	2	swat_her
swisher	13	36	952	2	swi_sher
switch	14	45	891	2	switch__
switcheroo	18	5	206	2	switcheroo
switchmen	19	6	242	2	switchmen
swithe	12	40	1068	2	swit_he_
swithers	14	43	1053	2	swit_hers
twitched	17	15	503	2	twitched
twitchers	17	13	453	2	twitchers
twitches	16	15	637	2	twitches
twitchier	17	5	323	2	twitchier
watcher	15	31	1340	2	_watcher
wincher	15	34	1065	2	_wincher
witched	16	30	1219	2	_witched
witchery	19	23	609	2	_witchery
witches	15	27	1579	2	_witches
witchier	16	30	788	2	_witchier
wither	12	43	2135	2	_wit_her
aitches	12	30	1436	3	_aitches
batcher	14	44	1485	3	_batcher
bewitched	20	4	323	3	bewitched
bewitchers	20	4	256	3	bewitchers
bewitchery	23	5	166	3	bewitchery
bewitches	19	4	382	3	bewitches
bitched	15	32	1292	3	_bitched
bitchen	14	34	973	3	_bitchen
bitchery	18	23	656	3	_bitchery
bitches	14	41	1706	3	_bitches
bitchier	15	30	773	3	_bitchier
blither	12	48	1217	3	blit_her
botcher	14	36	1322	3	_botcher
britches	15	27	868	3	britches
butcher	14	34	1116	3	_butcher
catcher	14	31	1582	3	_catcher
cither	11	46	1668	3	_cit_her
clincher	15	34	766	3	clincher
ditched	14	37	1190	3	_ditched
ditchers	14	36	1036	3	_ditchers
ditches	13	32	1571	3	_ditches
dither	10	44	1768	3	_dit_her
dowitchers	19	4	213	3	dowitchers
either	9	45	1742	3	_eit_her
etcher	11	39	1294	3	__etcher
fetcher	15	35	1039	3	_fetcher
filcher	15	37	779	3	_filcher
fitchee	15	27	1078	3	_fitchee
fitches	15	35	1619	3	_fitches
fitchet	15	31	1356	3	_fitchet
fitchew	18	27	680	3	_fitchew
fletcher	16	30	666	3	fletcher
flincher	16	25	658	3	flincher
flitched	17	25	629	3	flitched
flitches	16	38	846	3	flitches
glitches	14	29	665	3	glitches
glitchier	15	4	279	3	glitchier
hatcher	15	33	1472	3	_hatcher
hitched	16	33	1225	3	_hitched
hitchers	16	37	999	3	_hitchers
hitches	15	36	1627	3	_hitches
hither	12	44	1725	3	_hit_her
incher	11	41	1403	3	__incher
itched	12	38	1202	3	__itched
itches	11	49	1621	3	__itches
itchier	12	24	767	3	__itchier
ither	8	46	1760	3	__it_her
kitchen	16	28	768	3	_kitchen
kvetcher	20	5	281	3	kvetcher
lither	9	45	2095	3	_lit_her
matcher	14	32	1428	3	_matcher
mither	11	42	1856	3	_mit_her
neither	10	3	757	3	neit_her
notcher	12	36	1093	3	_notcher
patcher	14	35	1514	3	_patcher
pincher	14	38	1271	3	_pincher
pitched	15	35	1292	3	_pitched
pitchers	15	32	1148	3	_pitchers
pitches	14	36	1775	3	_pitches
pitchier	15	36	827	3	_pitchier
quitches	22	3	619	3	quitches
richer	11	40	1504	3	_ri_cher
saithe	9	47	1391	3	sait_he_
satchel	12	33	1030	3	s_atchel
scorcher	15	19	678	3	scorcher
scotched	16	18	793	3	scotched
scotches	15	17	947	3	scotches
scratcher	16	3	544	3	scratcher
scutched	16	18	689	3	scutched
scutchers	16	17	564	3	scutchers
scutches	15	16	888	3	scutches
searcher	13	20	910	3	searcher
seiche	11	8	1183	3	sei_che_
seiches	12	5	1381	3	sei_ches
shicker	16	39	1482	3	shi_cker
shittier	11	3	731	3	shittier
sicker	12	40	2390	3	s_i_cker
sigher	10	38	1370	3	s_i_gher
sitter	6	33	2338	3	s_it_ter
sketched	18	3	539	3	sketched
sketchers	18	3	451	3	sketchers
sketches	17	4	682	3	sketches
sketchier	18	5	341	3	sketchier
skitter	11	38	1040	3	skit_ter
slatches	13	15	1152	3	slatches
slather	10	38	1607	3	slat_her
slicer	8	41	1760	3	sli_c_er
slicker	13	33	1453	3	sli_cker
slithers	11	42	1295	3	slit_hers
slithery	14	35	670	3	slit_hery
slitter	7	36	1587	3	slit_ter
slittier	8	3	700	3	slittier
sloucher	13	20	681	3	sloucher
smirched	16	3	467	3	smirched
smirches	15	3	599	3	smirches
smiter	8	36	1641	3	smit__er
smithers	13	36	979	3	smit_hers
smithery	16	32	570	3	smit_hery
smoocher	15	20	550	3	smoocher
smother	12	35	1021	3	smot_her
smutched	16	16	592	3	smutched
smutches	15	17	727	3	smutches
smutchier	16	4	350	3	smutchier
snatched	14	15	763	3	snatched
snatchers	14	14	631	3	snatchers
snatches	13	14	1071	3	snatches
snatchier	14	5	535	3	snatchier
snicker	13	30	1267	3	sni_cker
snitch	11	35	794	3	snitch__
soother	10	42	1504	3	soot_her
souther	10	41	1630	3	sout_her
spicer	10	47	1931	3	spi_c_er
spicier	11	51	1246	3	spi_cier
spitter	9	40	1518	3	spit_ter
stancher	13	19	881	3	stancher
sticker	13	35	1588	3	sti_cker
stitch	11	41	910	3	stitch__
stretcher	14	4	629	3	stretcher
suiter	6	41	2181	3	suit__er
swasher	13	40	1151	3	sw_asher
swatch	14	54	928	3	swatch__
swathe	12	55	1411	3	swat_he_
swathed	14	46	1193	3	swat_hed
swathers	14	45	1208	3	swat_hers
swathes	13	41	1551	3	swat_hes
swatter	10	41	1332	3	swat_ter
swifter	13	31	805	3	swi_fter
swigger	12	33	845	3	swi_gger
swiller	10	32	1166	3	swi_ller
swimmer	14	29	765	3	swi_mmer
swimmier	15	17	431	3	swimmier
swindler	12	25	772	3	swindler
swineherd	16	8	225	3	swineherd
swinger	11	38	1256	3	swi_nger
swingier	12	26	700	3	swingier
swirlier	11	3	521	3	swirlier
swished	14	41	884	3	swi_shed
swishers	14	32	805	3	swi_shers
swishes	13	34	1137	3	swi_shes
swishier	14	3	456	3	swishier
switcheroos	19	5	192	3	switcher~~oos~~
switching	18	3	570	3	switching
switchman	19	6	220	3	switchman
switchyard	22	5	158	3	switchyard
swith	11	59	1740	3	swit_h__
swithered	16	13	546	3	swit_hered
swithly	16	3	444	3	swit_hly
swizzler	19	6	322	3	swizzler
swotter	10	39	947	3	swot_ter
thatcher	16	3	566	3	thatcher
thither	13	32	810	3	thit_her
tither	9	49	2028	3	_tit_her
twitch	14	40	616	3	twitch__
twitchy	18	39	357	3	twitch_y
twitter	10	27	809	3	twit_ter
watched	16	30	1282	3	_watched
watchers	16	35	1179	3	_watchers
watches	15	30	1737	3	_watches
welcher	15	31	939	3	_welcher
wencher	15	38	1113	3	_wencher
wether	12	33	1539	3	_wet_her
whither	16	35	1025	3	whit_her
wiches	14	44	1875	3	_wi_ches
wicker	15	45	1867	3	_wi_cker
wincer	11	50	1819	3	_winc_er
winched	16	31	1059	3	_winched
winchers	16	31	922	3	_winchers
winches	15	47	1437	3	_winches
wisher	12	36	1706	3	_wi_sher
witch	13	45	1756	3	_witch__
witchy	17	46	859	3	_witch_y
withe	11	52	2023	3	_wit_he_
withed	13	44	1623	3	_wit_hed
withers	13	44	1775	3	_wit_hers
withes	12	46	2084	3	_wit_hes
withier	13	29	1049	3	_withier
wittier	10	39	1082	3	_wittier
writher	13	40	1085	3	writ_her
wuther	12	45	1161	3	_wut_her
zither	18	38	1308	3	_zit_her

Search took 8 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	146162	0.860	207780.2
2	DLD Change Limit	146162	223	7.013	20841.6
3	Display Results	223	223	0.080	2787.5
	(SQL Overall)	178691	223	7.953	22468.4