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

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

147 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
tetchier	13	3	645	(None)
techier	12	6	924	1	te_chier
beachier	15	3	880	2	beachier
beechier	15	3	563	2	beechier
bitchier	15	30	773	2	bitchier
botchier	15	28	714	2	botchier
catchier	15	32	986	2	catchier
etcher	11	39	1294	2	_etch_er
fetcher	15	35	1039	2	fetch_er
itchier	12	24	767	2	_itchier
kvetchier	21	4	186	2	kvetchier
leachier	13	3	725	2	leachier
patchier	15	31	966	2	patchier
peachier	15	4	862	2	peachier
pitchier	15	36	827	2	pitchier
reechier	13	3	667	2	reechier
sketchier	18	5	341	2	sketchier
stenchier	14	4	533	2	stenchier
stretchier	15	4	448	2	stretchier
teacher	12	37	1483	2	teach_er
techie	11	5	1172	2	te_chie_
techies	12	5	1360	2	te_chies
tetched	13	30	1077	2	tetch_ed
tetchiest	14	4	579	2	tetchiest
tetchily	16	4	412	2	tetchily
tether	9	37	1610	2	tet_h_er
thatchier	17	4	398	2	thatchier
torchier	13	3	746	2	torchier
touchier	13	4	738	2	touchier
twitchier	17	5	323	2	twitchier
witchier	16	30	788	2	witchier
achier	11	39	1426	3	__achier
aether	9	42	1367	3	aet_h_er
batcher	14	44	1485	3	batch_er
belcher	14	35	1149	3	belch_er
bencher	14	41	1348	3	bench_er
blotchier	16	4	321	3	blotchier
botcher	14	36	1322	3	botch_er
bunchier	15	3	615	3	bunchier
butcher	14	34	1116	3	butch_er
catcher	14	31	1582	3	catch_er
chichier	18	3	602	3	chichier
decrier	10	27	1355	3	de_crier
descrier	11	5	762	3	descrier
detacher	14	3	754	3	detach_er
ditcher	13	40	1200	3	ditch_er
echoer	11	40	1110	3	_e_choer
etched	12	36	1370	3	_etch_ed
etchers	12	34	1129	3	_etch_ers
etches	11	42	1776	3	_etch_es
etching	13	45	1184	3	_etching
ether	8	45	1877	3	_et_h_er
fetched	16	37	1047	3	fetch_ed
fetchers	16	32	886	3	fetch_ers
fetches	15	34	1389	3	fetch_es
fetching	17	29	841	3	fetching
fletcher	16	30	666	3	fletch_er
glitchier	15	4	279	3	glitchier
hatcher	15	33	1472	3	hatch_er
heathier	14	3	834	3	heathier
hitcher	15	37	1200	3	hitch_er
jettier	14	35	869	3	jet_tier
kerchief	20	4	387	3	kerchief
ketches	16	40	1219	3	ketch_es
kvetcher	20	5	281	3	kvetch_er
lathier	10	3	1083	3	lat_hier
leacher	12	40	1484	3	leach_er
lecher	11	34	1585	3	le_ch_er
letched	13	39	1205	3	letch_ed
letches	12	40	1548	3	letch_es
letching	14	38	1026	3	letching
luthier	10	3	823	3	lut_hier
matcher	14	32	1428	3	match_er
meshier	12	34	1085	3	me_shier
metier	8	35	1769	3	met__ier
mothier	12	19	1021	3	mot_hier
mythier	15	12	518	3	myt_hier
nether	9	40	1416	3	net_h_er
nettier	7	42	1181	3	net_tier
nettlier	8	6	481	3	nettlier
nitchie	12	4	723	3	nitchie_
nitchies	13	3	907	3	nitchies
notcher	12	36	1093	3	notch_er
patcher	14	35	1514	3	patch_er
peacher	14	42	1607	3	peach_er
peckier	15	39	1052	3	pe_ckier
percher	14	33	1342	3	perch_er
pettier	9	42	1361	3	pet_tier
pitcher	14	38	1371	3	pitch_er
pithier	12	30	1029	3	pit_hier
poachier	15	5	682	3	poachier
pouchier	15	4	680	3	pouchier
preachier	16	4	692	3	preachier
punchier	15	3	641	3	punchier
reacher	12	37	1829	3	reach_er
retched	13	38	1427	3	retch_ed
retches	12	33	1851	3	retch_es
retching	14	34	1217	3	retching
sketcher	17	3	543	3	sketch_er
smutchier	16	4	350	3	smutchier
snatchier	14	5	535	3	snatchier
starchier	14	3	664	3	starchier
stitcher	13	16	839	3	stitch_er
stretcher	14	4	629	3	stretch_er
tackier	13	37	1252	3	t_ackier
tattier	7	42	1624	3	tat_tier
teachers	13	32	1239	3	teach_ers
teaches	12	27	1835	3	teach_es
teaching	14	36	1260	3	teaching
tearier	7	38	1561	3	te_arier
teched	12	40	1443	3	te_ch_ed
techiest	13	5	983	3	te_chiest
techily	15	3	712	3	te_chily
teenier	7	26	1114	3	te_enier
teensier	8	3	557	3	teensier
teether	10	34	969	3	teeth_er
telpher	12	3	556	3	telph_er
tenches	12	35	1552	3	tench_es
tentier	7	38	1592	3	te_ntier
terrier	7	34	1496	3	te_rrier
testier	7	40	1564	3	te_stier
testifier	12	11	689	3	testifier
tetanies	8	5	1355	3	tetanies
tetchiness	15	4	358	3	tetchiness
tetchy	14	3	600	3	tetch__y
tethers	10	38	1531	3	tet_h_ers
tetramer	10	4	681	3	tetramer
tetter	6	43	2245	3	tet__ter
thatcher	16	3	566	3	thatch_er
tither	9	49	2028	3	tit_h_er
tocher	11	40	1491	3	t_och_er
toothier	11	3	642	3	toothier
torchiere	14	4	357	3	torchiere
torchiers	14	4	507	3	torchiers
tother	9	41	1714	3	tot_h_er
toucher	12	48	1435	3	touch_er
trashier	11	32	1010	3	trashier
treaclier	11	4	415	3	treaclier
trencher	13	27	931	3	trench_er
trickier	14	30	1023	3	trickier
twitcher	16	13	534	3	twitch_er
vetches	15	34	1126	3	vetch_es
watcher	15	31	1340	3	watch_er
welcher	15	31	939	3	welch_er
wencher	15	38	1113	3	wench_er
wether	12	33	1539	3	wet_h_er
withier	13	29	1049	3	wit_hier

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.420	425454.8
2	DLD Change Limit	146162	147	7.296	20033.2
3	Display Results	147	147	0.063	2333.3
	(SQL Overall)	178691	147	7.779	22970.9