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

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

125 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
butchery	18	32	625	(None)
bitchery	18	23	656	1	bitchery
botchery	18	36	676	1	botchery
butcher	14	34	1116	1	butcher_
butcherly	19	25	265	1	butcherly
butchers	15	37	1018	1	butchers
cutchery	18	26	517	1	cutchery
batcher	14	44	1485	2	batcher_
batchers	15	36	1327	2	batchers
botcher	14	36	1322	2	botcher_
botchers	15	35	1154	2	botchers
butchered	17	4	458	2	butchered
butcherer	16	4	375	2	butcherer
butches	14	43	1536	2	butche_s
butlery	12	36	942	2	but_lery
buttery	12	43	1119	2	but_tery
hatchery	19	32	638	2	hatchery
witchery	19	23	609	2	witchery
archery	15	47	806	3	_archery
batched	15	41	1424	3	batche_d
batches	14	40	1961	3	batche_s
bather	11	53	2251	3	bat_her_
bathers	12	47	2036	3	bat_hers
battery	12	49	1181	3	bat_tery
belcher	14	35	1149	3	belcher_
belchers	15	35	1002	3	belchers
bencher	14	41	1348	3	bencher_
benchers	15	36	1101	3	benchers
bewitchery	23	5	166	3	bewitchery
bitched	15	32	1292	3	bitche_d
bitchen	14	34	973	3	bitche_n
bitches	14	41	1706	3	bitche_s
bitchier	15	30	773	3	bitchier_
bitchily	18	4	453	3	bitchily
bitchy	16	47	920	3	bitch__y
blucher	14	33	1022	3	blucher_
bluchers	15	35	903	3	bluchers
botched	15	36	1190	3	botche_d
botchedly	20	4	259	3	botchedly
botches	14	37	1602	3	botche_s
botchier	15	28	714	3	botchier_
botchily	18	6	437	3	botchily
botchy	16	53	782	3	botch__y
bother	11	52	1806	3	bot_her_
bothers	12	43	1775	3	bot_hers
bruncher	15	34	778	3	bruncher_
brunchers	16	29	625	3	brunchers
bucker	14	54	2046	3	bu_cker_
buckers	15	35	1745	3	bu_ckers
buggery	14	36	793	3	bu_ggery
bunchberry	22	5	141	3	bunchberry
bunched	15	43	1241	3	bunche_d
bunches	14	41	1603	3	bunche_s
bunchier	15	3	615	3	bunchier_
bunchily	18	4	454	3	bunchily
bunchy	16	43	746	3	bunch__y
burgher	13	3	700	3	burgher_
burghers	14	3	563	3	burghers
busher	11	49	2220	3	bu_sher_
bushers	12	40	1880	3	bu_shers
butch	12	54	1654	3	butch___
butcherers	17	4	270	3	butcherers
butcheries	17	4	507	3	butcheries
butchering	18	4	450	3	butchering
butchness	16	4	345	3	butchness
butler	8	42	2003	3	but_ler_
butlers	9	45	1805	3	but_lers
butter	8	47	2423	3	but_ter_
butters	9	45	2172	3	but_ters
butthead	14	5	451	3	butthead
catcher	14	31	1582	3	catcher_
catchers	15	31	1406	3	catchers
cutches	14	32	1646	3	cutche_s
cutlery	12	44	839	3	cut_lery
ditcher	13	40	1200	3	ditcher_
ditchers	14	36	1036	3	ditchers
dithery	14	31	894	3	dit_hery
etcher	11	39	1294	3	_etcher_
etchers	12	34	1129	3	_etchers
fetcher	15	35	1039	3	fetcher_
fetchers	16	32	886	3	fetchers
guttery	11	42	776	3	gut_tery
hatcher	15	33	1472	3	hatcher_
hatchers	16	31	1317	3	hatchers
hitcher	15	37	1200	3	hitcher_
hitchers	16	37	999	3	hitchers
hutched	16	35	988	3	hutche_d
hutches	15	36	1352	3	hutche_s
lathery	13	39	1112	3	lat_hery
lechery	15	25	764	3	_lechery
luncher	12	31	1141	3	luncher_
lunchers	13	34	956	3	lunchers
lurcher	12	33	813	3	lurcher_
lurchers	13	30	715	3	lurchers
luthern	10	3	765	3	lut_hern
matcher	14	32	1428	3	matcher_
matchers	15	30	1243	3	matchers
mothery	15	37	1051	3	mot_hery
muncher	14	36	1037	3	muncher_
munchers	15	31	877	3	munchers
mutches	14	33	1428	3	mutche_s
notcher	12	36	1093	3	notcher_
notchers	13	27	942	3	notchers
ochery	14	31	944	3	__ochery
outcharm	15	4	473	3	outcharm
outcheat	13	4	941	3	outcheat
outcry	11	3	799	3	outc__ry
patcher	14	35	1514	3	patcher_
patchers	15	34	1330	3	patchers
pitcher	14	38	1371	3	pitcher_
pitchers	15	32	1148	3	pitchers
puckery	18	30	626	3	pu_ckery
puncher	14	33	1167	3	puncher_
punchers	15	26	1007	3	punchers
quackery	26	3	311	3	quackery
scutcher	15	17	696	3	scutcher_
scutchers	16	17	564	3	scutchers
stitchery	17	17	407	3	stitchery
tushery	13	3	563	3	tu_shery
unchary	15	3	726	3	_unchary
watchcry	21	4	236	3	watchcry
watcher	15	31	1340	3	watcher_
watchers	16	35	1179	3	watchers
wuther	12	45	1161	3	wut_her_
wuthers	13	37	1152	3	wut_hers

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	125	6.233	23449.7
3	Display Results	125	125	0.046	2717.4
	(SQL Overall)	178691	125	6.702	26662.3