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

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

176 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
balked	13	52	1941	(None)
backed	15	57	2572	1	backed
baked	12	61	3077	1	ba_ked
balded	10	54	1751	1	balded
baled	8	54	3644	1	bal_ed
balker	12	45	1916	1	balker
balled	9	49	2689	1	balled
banked	13	50	2144	1	banked
barked	13	50	2731	1	barked
basked	13	52	1860	1	basked
baulked	14	46	562	1	baulked
bilked	13	40	1294	1	bilked
bulked	13	42	1674	1	bulked
calked	13	46	1740	1	calked
talked	11	40	1540	1	talked
walked	14	53	1378	1	walked
abled	8	69	2683	2	abl_ed
alkyd	13	53	709	2	_alkyd
asked	10	69	1931	2	_asked
baaed	8	52	1816	2	ba_aed
babied	11	49	1350	2	babied
bached	14	55	1989	2	bached
backer	14	45	2552	2	backer
badged	11	48	1478	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
bake	10	56	3751	2	ba_ke_
baker	11	56	2954	2	ba_ker
bakes	11	70	3537	2	ba_kes
bald	7	64	3290	2	bal__d
balder	9	53	1886	2	balder
bale	6	63	5384	2	bal_e_
baleen	8	6	1305	2	baleen
baler	7	56	3527	2	bal_er
bales	7	62	5008	2	bal_es
balk	10	51	3222	2	balk__
balkers	13	49	1572	2	balkers
balkier	13	41	1198	2	balkier
balks	11	49	2629	2	balk_s
balky	14	54	1824	2	balk_y
ballad	9	43	1532	2	ballad
baller	8	38	2520	2	baller
ballet	8	47	3397	2	ballet
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
banker	12	42	2273	2	banker
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
barker	12	48	2286	2	barker
barned	9	56	2358	2	barned
barred	9	57	2579	2	barred
based	8	53	3158	2	ba_sed
bashed	12	62	2570	2	bashed
basket	12	57	2291	2	basket
basted	9	52	2723	2	basted
bated	8	59	3553	2	ba_ted
bathed	12	55	1874	2	bathed
batiked	14	3	596	2	batiked
batted	9	56	2365	2	batted
bawled	12	44	1569	2	bawled
bayed	11	54	2302	2	ba_yed
beaked	13	59	1949	2	beaked
becked	15	54	1776	2	becked
belied	9	50	2216	2	belied
belled	9	46	2618	2	belled
belted	9	40	2063	2	belted
biked	12	53	2003	2	b_iked
bilged	10	55	1318	2	bilged
bilker	12	49	1344	2	bilker
billed	9	42	2490	2	billed
blacked	16	36	1337	2	blacked
bladed	10	47	1776	2	bladed
blamed	11	60	1795	2	blamed
blanked	14	40	1122	2	blanked
blared	9	50	1824	2	blared
blawed	12	47	1389	2	blawed
blazed	18	43	1471	2	blazed
bled	7	57	2931	2	b_l_ed
bleed	8	50	1980	2	b_leed
blued	8	45	2032	2	b_lued
bolled	9	47	2265	2	bolled
bolted	9	46	1780	2	bolted
bonked	13	55	1731	2	bonked
booked	13	53	1950	2	booked
borked	13	51	1729	2	borked
braked	13	53	1869	2	braked
bucked	15	51	2106	2	bucked
bulbed	11	43	1277	2	bulbed
bulged	10	51	1712	2	bulged
bulled	9	46	2649	2	bulled
bunked	13	51	1837	2	bunked
burked	13	52	2088	2	burked
busked	13	49	1770	2	busked
caked	12	61	2862	2	ca_ked
calker	12	49	1708	2	calker
called	9	41	2673	2	called
calmed	11	48	1638	2	calmed
calved	12	52	1545	2	calved
carked	13	40	2482	2	carked
casked	13	48	1551	2	casked
caulked	14	48	667	2	caulked
chalked	17	44	986	2	chalked
darked	12	39	1963	2	darked
faked	13	52	2548	2	fa_ked
flaked	14	47	1565	2	flaked
galled	8	46	2285	2	galled
gawked	15	46	876	2	gawked
hacked	16	49	2351	2	hacked
haled	9	53	3582	2	hal_ed
haloed	10	47	1759	2	haloed
halted	10	50	1960	2	halted
halved	13	48	1390	2	halved
hanked	14	42	2060	2	hanked
harked	14	54	2255	2	harked
hawked	17	47	1267	2	hawked
holked	14	49	1366	2	holked
hulked	14	46	1130	2	hulked
jacked	20	48	1752	2	jacked
jauked	18	48	901	2	jauked
lacked	13	53	2465	2	lacked
laked	10	57	3112	2	la_ked
lalled	7	42	1875	2	lalled
larked	11	45	1947	2	larked
malfed	12	36	975	2	malfed
malled	9	46	2610	2	malled
malted	9	48	1985	2	malted
marked	13	39	2162	2	marked
masked	13	43	1652	2	masked
milked	13	46	1257	2	milked
naked	10	53	2085	2	na_ked
naled	6	55	2505	2	nal_ed
narked	11	41	1674	2	narked
packed	15	48	2260	2	packed
paiked	13	51	1343	2	paiked
paled	8	55	3872	2	pal_ed
palled	9	46	2516	2	palled
palmed	11	43	1464	2	palmed
palped	11	45	1364	2	palped
parked	13	44	2513	2	parked
racked	13	45	2608	2	racked
raked	10	58	3142	2	ra_ked
ranked	11	46	2074	2	ranked
sacked	13	55	2521	2	sacked
salted	7	41	2120	2	salted
salved	10	39	1642	2	salved
silked	11	43	1481	2	silked
slaked	11	43	1827	2	slaked
stalked	12	38	1117	2	stalked
sulked	11	43	1470	2	sulked
tacked	13	47	2394	2	tacked
talced	9	38	1100	2	talced
talcked	14	4	634	2	talcked
talker	10	39	1622	2	talker
tanked	11	39	1929	2	tanked
tasked	11	47	1464	2	tasked
valued	10	40	1115	2	valued
valved	13	67	1104	2	valved
waked	13	56	2675	2	wa_ked
waled	9	43	3099	2	wal_ed
walker	13	39	1399	2	walker
walled	10	40	2129	2	walled
wanked	14	45	1715	2	wanked
warked	14	44	2121	2	warked
wauked	14	42	1057	2	wauked
yacked	16	45	1679	2	yacked
yakked	13	36	609	2	yakked
yanked	14	43	1224	2	yanked
yolked	14	36	715	2	yolked

Search took 5 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.216	827273.1
2	DLD Change Limit	82551	176	4.003	20622.3
3	Display Results	176	176	0.043	4093.0
	(SQL Overall)	178691	176	4.262	41926.6