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

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

206 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
fletcher	16	30	666	(None)
fetcher	15	35	1039	1	f_etcher
fletched	17	30	669	1	fletched
fletchers	17	33	553	1	fletchers
fletches	16	30	885	1	fletches
bleacher	15	35	888	2	bleacher
blencher	15	30	839	2	blencher
blether	12	45	991	2	blet_her
clencher	15	27	797	2	clencher
etcher	11	39	1294	2	__etcher
fetched	16	37	1047	2	f_etched
fetchers	16	32	886	2	f_etchers
fetches	15	34	1389	2	f_etches
fleche	14	29	930	2	fle_che_
fleches	15	34	1144	2	fle_ches
fleecer	12	36	803	2	fleec_er
fleeched	17	34	582	2	fleeched
fleeches	16	28	708	2	fleeches
fleecier	13	3	476	2	fleecier
flenched	17	26	796	2	flenched
flenches	16	34	1053	2	flenches
flesher	13	36	1092	2	fle_sher
fletch	14	38	819	2	fletch__
flincher	16	25	658	2	flincher
flitched	17	25	629	2	flitched
flitches	16	38	846	2	flitches
kvetcher	20	5	281	2	kvetcher
leacher	12	40	1484	2	_leacher
lecher	11	34	1585	2	_le_cher
letched	13	39	1205	2	_letched
letches	12	40	1548	2	_letches
sketcher	17	3	543	2	sketcher
aether	9	42	1367	3	_aet_her
batcher	14	44	1485	3	_batcher
belcher	14	35	1149	3	_belcher
bencher	14	41	1348	3	_bencher
blancher	15	33	863	3	blancher
blather	12	53	1421	3	blat_her
bleached	16	37	856	3	bleached
bleachers	16	29	792	3	bleachers
bleaches	15	34	1067	3	bleaches
blenched	16	35	805	3	blenched
blenchers	16	35	672	3	blenchers
blenches	15	33	1076	3	blenches
blethers	13	42	961	3	blet_hers
blither	12	48	1217	3	blit_her
blotched	16	3	565	3	blotched
blotches	15	3	743	3	blotches
blotchier	16	4	321	3	blotchier
blucher	14	33	1022	3	bl_ucher
botcher	14	36	1322	3	_botcher
breacher	15	30	1150	3	breacher
butcher	14	34	1116	3	_butcher
catcher	14	31	1582	3	_catcher
clenched	16	25	776	3	clenched
clenchers	16	27	655	3	clenchers
clenches	15	29	1095	3	clenches
clincher	15	34	766	3	clincher
clutched	16	35	603	3	clutched
clutches	15	30	792	3	clutches
detacher	14	3	754	3	_detacher
diether	11	4	744	3	diet_her
ditcher	13	40	1200	3	_ditcher
drencher	14	25	721	3	drencher
etched	12	36	1370	3	__etched
etchers	12	34	1129	3	__etchers
etches	11	42	1776	3	__etches
ether	8	45	1877	3	__et_her
farther	13	4	834	3	fart_her
father	12	51	1671	3	f_at_her
feather	13	36	1350	3	f_eather
feldscher	18	4	202	3	feldscher
feldsher	15	4	324	3	feldsher
fencer	11	46	1353	3	f_enc_er
fetch	13	49	1347	3	f_etch__
fetiches	16	3	695	3	f_etiches
fetter	9	41	2038	3	f_et_ter
fiercer	12	35	695	3	fierc_er
filcher	15	37	779	3	f_ilcher
fitchee	15	27	1078	3	f_itchee
fitches	15	35	1619	3	f_itches
fitchet	15	31	1356	3	f_itchet
fitchew	18	27	680	3	f_itchew
flasher	13	39	1406	3	fl_asher
flatcar	12	7	461	3	flatc_ar
flatter	10	38	1596	3	flat_ter
flecked	17	35	807	3	fle_cked
fledgier	13	3	368	3	fledgier
fleece	11	36	990	3	fleec_e_
fleeced	13	35	815	3	fleec_ed
fleecers	13	32	593	3	fleec_ers
fleeces	12	39	964	3	fleec_es
fleech	14	36	734	3	fleech__
fleer	8	60	2077	3	fle___er
fleeter	10	32	1036	3	fle_eter
flench	14	40	1081	3	flench__
flenser	10	3	678	3	fle_nser
fleshed	14	32	1026	3	fle_shed
fleshers	14	33	944	3	fle_shers
fleshes	13	39	1327	3	fle_shes
fleshier	14	3	560	3	fleshier
fletching	18	25	614	3	fletching
flextimer	21	4	162	3	flextimer
flichter	16	6	496	3	fl_ichter
flicker	16	36	1062	3	fl_icker
flinched	17	31	670	3	flinched
flinchers	17	29	547	3	flinchers
flinches	16	35	895	3	flinches
flitch	14	92	817	3	flitch__
flitter	10	34	1390	3	flit_ter
flusher	13	30	1227	3	fl_usher
fluter	9	53	1686	3	flut__er
flutier	10	30	1155	3	flut_ier
flutter	10	40	1209	3	flut_ter
flycatcher	23	5	107	3	flycatcher
flysches	19	3	312	3	flysches
flytier	13	35	650	3	flyt_ier
frenched	17	29	943	3	frenched
frenches	16	33	1163	3	frenches
frescoer	13	4	598	3	frescoer
fresher	13	26	1264	3	fre_sher
fretter	10	34	1275	3	fret_ter
frettier	11	5	659	3	frettier
frother	13	31	1015	3	frot_her
further	13	3	700	3	furt_her
glitches	14	29	666	3	glitches
glitchier	15	4	279	3	glitchier
hatcher	15	33	1472	3	_hatcher
hitcher	15	37	1200	3	_hitcher
ketches	16	40	1219	3	_ketches
klatches	17	15	714	3	klatches
kvetched	21	4	278	3	kvetched
kvetchers	21	4	237	3	kvetchers
kvetches	20	5	358	3	kvetches
kvetchier	21	4	186	3	kvetchier
latched	13	39	1407	3	_latched
latches	12	33	2013	3	_latches
latchet	12	31	1791	3	_latchet
lather	9	51	2436	3	_lat_her
leached	13	37	1504	3	_leached
leachers	13	37	1281	3	_leachers
leaches	12	33	1934	3	_leaches
leachier	13	3	725	3	_leachier
leather	10	38	1578	3	_leather
leched	12	37	1600	3	_le_ched
lechers	12	33	1396	3	_le_chers
lechery	15	25	764	3	_le_chery
leches	11	54	2131	3	_le_ches
leeched	13	36	950	3	_leeched
leeches	12	39	1193	3	_leeches
letch	10	52	1580	3	_letch__
lethe	8	57	1730	3	_let_he_
lethes	9	48	1808	3	_let_hes
letter	6	37	2258	3	_let_ter
lither	9	45	2095	3	_lit_her
luncher	12	31	1141	3	_luncher
lurcher	12	33	813	3	_lurcher
lyncher	15	36	655	3	_lyncher
matcher	14	32	1428	3	_matcher
nether	9	40	1416	3	_net_her
notcher	12	36	1093	3	_notcher
patcher	14	35	1514	3	_patcher
peacher	14	42	1607	3	_peacher
percher	14	33	1342	3	_percher
pitcher	14	38	1371	3	_pitcher
pleached	16	33	806	3	pleached
pleaches	15	32	1043	3	pleaches
pleather	13	5	665	3	pleather
plenches	15	31	1062	3	plenches
preacher	15	32	1137	3	preacher
quencher	22	3	412	3	quencher
reacher	12	37	1829	3	_reacher
retched	13	38	1427	3	_retched
retches	12	33	1851	3	_retches
scutcher	15	17	696	3	scutcher
sketched	18	3	539	3	sketched
sketchers	18	3	451	3	sketchers
sketches	17	4	682	3	sketches
sketchier	18	5	341	3	sketchier
slatches	13	15	1153	3	slatches
slather	10	38	1608	3	slat_her
sleigher	12	3	431	3	sleigher
slither	10	41	1298	3	slit_her
sloucher	13	20	681	3	sloucher
snatcher	13	16	776	3	snatcher
snitcher	13	15	737	3	snitcher
stitcher	13	16	839	3	stitcher
stretcher	14	4	629	3	stretcher
switcher	16	17	768	3	switcher
teacher	12	37	1483	3	_teacher
teether	10	34	969	3	teet_her
tetched	13	30	1077	3	_tetched
tetchier	13	3	645	3	_tetchier
tether	9	37	1610	3	_tet_her
thatcher	16	3	566	3	thatcher
trencher	13	27	931	3	trencher
twitcher	16	13	534	3	twitcher
vetches	15	34	1126	3	_vetches
watcher	15	31	1340	3	_watcher
welcher	15	31	939	3	_welcher
wencher	15	38	1113	3	_wencher
wether	12	33	1539	3	_wet_her
whether	16	34	662	3	whet_her
wrencher	16	28	778	3	wrencher
wretched	17	27	653	3	wretched
wretches	16	25	728	3	wretches

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	146162	0.423	422437.4
2	DLD Change Limit	146162	206	6.170	23689.1
3	Display Results	206	206	0.080	2575.0
	(SQL Overall)	178691	206	6.673	26778.2