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

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

82 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
kvetchers	21	4	237	(None)
kvetcher	20	5	281	1	kvetcher_
kvetches	20	5	358	1	kvetche_s
etchers	12	34	1129	2	__etchers
fetchers	16	32	886	2	_fetchers
fletchers	17	33	553	2	fletchers
ketches	16	40	1219	2	k_etche_s
kvetched	21	4	278	2	kvetche_d
kvetchier	21	4	186	2	kvetchier_
sketchers	18	3	451	2	sketchers
vetches	15	34	1126	2	_vetche_s
aethers	10	36	1494	3	_aet_hers
avouchers	17	4	308	3	avouchers
batchers	15	36	1327	3	_batchers
belchers	15	35	1002	3	_belchers
benchers	15	36	1101	3	_benchers
bleachers	16	29	792	3	bleachers
blenchers	16	35	672	3	blenchers
blethers	13	42	961	3	blet_hers
botchers	15	35	1154	3	_botchers
breachers	16	36	985	3	breachers
butchers	15	37	1018	3	_butchers
catchers	15	31	1406	3	_catchers
clenchers	16	27	655	3	clenchers
detachers	15	3	648	3	_detachers
diethers	12	5	745	3	diet_hers
ditchers	14	36	1036	3	_ditchers
drenchers	15	29	610	3	drenchers
etcher	11	39	1294	3	__etcher_
etches	11	42	1776	3	__etche_s
ethers	9	45	1841	3	__et_hers
fetcher	15	35	1039	3	_fetcher_
fetches	15	34	1389	3	_fetche_s
fletcher	16	30	666	3	fletcher_
fletches	16	30	885	3	fletche_s
hatchers	16	31	1317	3	_hatchers
hitchers	16	37	999	3	_hitchers
kenches	16	39	1227	3	k_enche_s
ketchups	19	4	189	3	k_etchups
kitchens	17	19	578	3	k_itchens
klatches	17	15	713	3	klatche_s
kvetch	18	3	299	3	kvetch___
kvetchiest	22	4	195	3	kvetchiest
kvetching	22	4	290	3	kvetching
kvetchy	22	4	180	3	kvetch__y
leachers	13	37	1281	3	_leachers
lechers	12	33	1396	3	_le_chers
letches	12	40	1548	3	_letche_s
matchers	15	30	1243	3	_matchers
notchers	13	27	942	3	_notchers
patchers	15	34	1330	3	_patchers
peachers	15	32	1384	3	_peachers
perchers	15	36	1152	3	_perchers
pitchers	15	32	1148	3	_pitchers
preachers	16	33	957	3	preachers
quenchers	23	4	317	3	quenchers
reachers	13	35	1572	3	_reachers
retches	12	33	1851	3	_retche_s
scutchers	16	17	564	3	scutchers
sketcher	17	3	543	3	sketcher_
sketches	17	4	682	3	sketche_s
snatchers	14	14	631	3	snatchers
snitchers	14	16	604	3	snitchers
stitchers	14	14	701	3	stitchers
stretchers	15	4	517	3	stretchers
switchers	17	14	663	3	switchers
teachers	13	32	1239	3	_teachers
teethers	11	32	871	3	teet_hers
tethers	10	38	1531	3	_tet_hers
thatchers	17	4	458	3	thatchers
trenchers	14	28	807	3	trenchers
twitchers	17	13	453	3	twitchers
vetivers	14	3	516	3	_vetivers
vetoers	10	35	947	3	_vet_oers
vetters	10	40	1632	3	_vet_ters
vouchers	16	41	862	3	_vouchers
watchers	16	35	1179	3	_watchers
welchers	16	33	805	3	_welchers
wenchers	16	31	921	3	_wenchers
wethers	13	52	1469	3	_wet_hers
wrenchers	17	25	633	3	wrenchers
wretches	16	25	728	3	wretche_s

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	82	7.436	19989.4
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	7.638	23395.0