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

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

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

150 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
bached	14	55	1989	(None)
ached	11	92	2783	1	_ached
baches	13	54	2694	1	baches
backed	15	57	2572	1	backed
bashed	12	62	2570	1	bashed
batched	15	41	1424	1	batched
bathed	12	55	1874	1	bathed
beached	15	45	1655	1	beached
cached	14	54	1920	1	cached
aahed	9	178	1644	2	_aahed
abashed	13	5	766	2	abashed
aced	7	95	4088	2	_ac_ed
ache	9	68	2982	2	_ache_
aches	10	61	3229	2	_aches
acned	8	75	2067	2	_acned
acred	8	71	2635	2	_acred
acted	8	85	2173	2	_acted
ahed	8	95	3625	2	_a_hed
arched	12	57	1732	2	arched
ashed	9	78	2977	2	_ashed
baaed	8	52	1816	2	ba_aed
babied	11	49	1351	2	babied
bach	11	61	3139	2	bach__
backer	14	45	2552	2	backer
backhoed	20	4	701	2	backhoed
badged	11	48	1479	2	badged
baffed	15	48	1217	2	baffed
bagged	11	45	1990	2	bagged
bailed	9	47	2665	2	bailed
baited	9	53	1924	2	baited
baked	12	61	3077	2	ba_ked
balded	10	54	1751	2	balded
baled	8	54	3644	2	ba_led
balked	13	52	1941	2	balked
balled	9	49	2689	2	balled
bammed	13	39	1324	2	bammed
banded	10	52	2317	2	banded
baned	8	54	3635	2	ba_ned
banged	10	49	2372	2	banged
banked	13	50	2144	2	banked
banned	9	47	2134	2	banned
barbed	11	51	2131	2	barbed
barded	10	54	2642	2	barded
bared	8	51	4448	2	ba_red
barfed	12	54	1638	2	barfed
barged	10	58	2264	2	barged
barked	13	50	2731	2	barked
barned	9	56	2358	2	barned
barred	9	57	2579	2	barred
based	8	53	3158	2	ba_sed
basher	11	51	2381	2	basher
bashes	11	56	3139	2	bashes
basked	13	52	1860	2	basked
basted	9	52	2723	2	basted
batcher	14	44	1485	2	batcher
batches	14	40	1961	2	batches
bated	8	59	3553	2	ba_ted
bathe	10	58	2288	2	bathe_
bather	11	53	2251	2	bather
bathes	11	65	2483	2	bathes
batted	9	56	2365	2	batted
bawled	12	44	1569	2	bawled
bayed	11	54	2302	2	ba_yed
beaches	14	41	2065	2	beaches
becked	15	54	1776	2	becked
belched	15	40	1184	2	belched
benched	15	47	1394	2	benched
birched	15	34	991	2	birched
bitched	15	32	1292	2	bitched
blacked	16	36	1337	2	blacked
blanched	16	30	860	2	blanched
bleached	16	37	856	2	bleached
boche	12	42	1695	2	boche_
boches	13	46	1852	2	boches
botched	15	36	1190	2	botched
braced	11	54	2060	2	brac_ed
braches	14	46	2122	2	braches
brachet	14	40	2031	2	brachet
bracted	12	4	1093	2	bracted
branched	16	32	1045	2	branched
breached	16	34	1164	2	breached
broached	16	30	912	2	broached
bucked	15	51	2106	2	bucked
bunched	15	43	1241	2	bunched
bushed	12	48	2238	2	bushed
cache	12	51	2248	2	cache_
caches	13	79	2691	2	caches
cachet	13	45	2641	2	cachet
cashed	12	51	2435	2	cashed
coached	15	33	1384	2	coached
dashed	11	59	2056	2	dashed
eched	11	69	1922	2	_eched
etched	12	36	1370	2	etched
faced	11	77	2765	2	fac_ed
fashed	13	67	2025	2	fashed
gashed	11	63	2197	2	gashed
hacked	16	49	2351	2	hacked
hashed	13	60	2194	2	hashed
hatched	16	34	1446	2	hatched
inched	12	45	1448	2	inched
itched	12	38	1202	2	itched
jacked	20	48	1752	2	jacked
laced	8	71	3264	2	lac_ed
laches	11	65	2834	2	laches
lacked	13	53	2465	2	lacked
lashed	10	56	2521	2	lashed
latched	13	39	1406	2	latched
lathed	10	47	1845	2	lathed
leached	13	37	1504	2	leached
leched	12	37	1600	2	leched
maced	10	85	2869	2	mac_ed
mache	12	59	2530	2	mache_
maches	13	48	2723	2	maches
macled	11	67	1811	2	macled
marched	15	38	1340	2	marched
mashed	12	53	2504	2	mashed
matched	15	35	1396	2	matched
miched	14	39	1339	2	miched
naches	11	46	2241	2	naches
nacred	9	52	1249	2	nacred
niched	12	55	1406	2	niched
ouched	12	43	1693	2	ouched
paced	10	69	3168	2	pac_ed
packed	15	48	2260	2	packed
parched	15	40	1369	2	parched
pashed	12	59	2314	2	pashed
patched	15	35	1462	2	patched
peached	15	43	1588	2	peached
peched	14	49	1534	2	peched
poached	15	42	1240	2	poached
raced	8	76	3531	2	rac_ed
rachet	11	50	2897	2	rachet
racked	13	45	2608	2	racked
ranched	13	31	1360	2	ranched
reached	13	46	1908	2	reached
roached	13	32	1183	2	roached
ruched	12	43	1463	2	ruched
sachem	13	40	1222	2	sachem
sachet	11	47	2577	2	sachet
sacked	13	55	2521	2	sacked
sacred	9	49	1710	2	sacred
sashed	10	56	2294	2	sashed
tache	10	62	2237	2	tache_
taches	11	42	2417	2	taches
tacked	13	47	2394	2	tacked
teched	12	40	1443	2	teched
washed	13	55	2150	2	washed
watched	16	30	1282	2	watched
yachted	16	3	485	2	yachted
yacked	16	45	1679	2	yacked

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	150	2.486	33206.4
3	Display Results	150	150	0.046	3260.9
	(SQL Overall)	178691	150	2.875	62153.4