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

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

156 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
yacked	16	45	1679	(None)
backed	15	57	2572	1	backed
hacked	16	49	2351	1	hacked
jacked	20	48	1752	1	jacked
lacked	13	53	2465	1	lacked
packed	15	48	2260	1	packed
racked	13	45	2608	1	racked
sacked	13	55	2521	1	sacked
tacked	13	47	2394	1	tacked
yakked	13	36	609	1	yakked
yanked	14	43	1224	1	yanked
yocked	16	41	1442	1	yocked
yucked	16	40	1356	1	yucked
aced	7	95	4088	2	_ac_ed
ached	11	92	2783	2	_ached
ackee	11	58	2536	2	_ackee
acned	8	75	2066	2	_acned
acred	8	71	2635	2	_acred
acted	8	85	2173	2	_acted
arcked	13	62	1194	2	arcked
asked	10	69	1931	2	_asked
bached	14	55	1989	2	bached
backer	14	45	2552	2	backer
baked	12	61	3077	2	ba_ked
balked	13	52	1941	2	balked
banked	13	50	2144	2	banked
barked	13	50	2731	2	barked
basked	13	52	1860	2	basked
becked	15	54	1776	2	becked
blacked	16	36	1337	2	blacked
bucked	15	51	2106	2	bucked
cached	14	54	1920	2	cached
cackled	16	46	1329	2	cackled
caked	12	61	2862	2	ca_ked
calked	13	46	1740	2	calked
carked	13	40	2482	2	carked
casked	13	48	1551	2	casked
clacked	16	41	1360	2	clacked
cocked	15	50	2256	2	cocked
cracked	16	35	1474	2	cracked
dacker	13	49	2075	2	dacker
darked	12	39	1963	2	darked
decked	14	52	1762	2	decked
dicked	14	49	2086	2	dicked
docked	14	50	1833	2	docked
ducked	14	47	1801	2	ducked
faced	11	77	2765	2	fac_ed
faked	13	52	2548	2	fa_ked
flacked	17	37	1158	2	flacked
fucked	16	41	1448	2	fucked
gawked	15	46	876	2	gawked
gecked	14	69	1193	2	gecked
hackee	15	49	2183	2	hackee
hacker	15	48	2269	2	hacker
hackled	17	33	1248	2	hackled
hanked	14	42	2060	2	hanked
harked	14	54	2255	2	harked
hawked	17	47	1267	2	hawked
hocked	16	55	2130	2	hocked
jacker	19	44	1758	2	jacker
jacket	19	47	2067	2	jacket
jauked	18	48	901	2	jauked
kecked	12	51	1316	2	kecked
kicked	12	44	1594	2	kicked
knacked	13	28	779	2	knacked
laced	8	71	3264	2	lac_ed
lacker	12	53	2562	2	lacker
lackey	15	48	1335	2	lackey
laked	10	57	3112	2	la_ked
larked	11	45	1947	2	larked
licked	13	46	2156	2	licked
locked	13	49	2166	2	locked
lucked	13	51	1802	2	lucked
maced	10	85	2869	2	mac_ed
mackled	16	41	1191	2	mackled
macled	11	67	1811	2	macled
marked	13	39	2162	2	marked
masked	13	43	1652	2	masked
mocked	15	47	1661	2	mocked
mucked	15	38	1609	2	mucked
nacred	9	52	1249	2	nacred
naked	10	53	2085	2	na_ked
narked	11	41	1674	2	narked
necked	13	47	1506	2	necked
nicked	13	50	1968	2	nicked
nocked	13	46	1738	2	nocked
paced	10	69	3168	2	pac_ed
packer	14	42	2340	2	packer
packet	14	47	2650	2	packet
paiked	13	51	1343	2	paiked
parked	13	44	2513	2	parked
pecked	15	50	1910	2	pecked
picked	15	44	2131	2	picked
pocked	15	48	1898	2	pocked
quacked	23	3	679	2	quacked
raced	8	76	3531	2	rac_ed
racker	12	48	2455	2	racker
racket	12	52	2942	2	racket
raked	10	58	3142	2	ra_ked
ranked	11	46	2074	2	ranked
recked	13	48	2180	2	recked
ricked	13	65	2362	2	ricked
rocked	13	50	2232	2	rocked
rucked	13	47	1876	2	rucked
sacker	12	51	2484	2	sacker
sacred	9	49	1710	2	sacred
shacked	17	40	1539	2	shacked
sicked	13	45	2440	2	sicked
slacked	14	38	1545	2	slacked
smacked	16	37	1099	2	smacked
snacked	14	40	1311	2	snacked
socked	13	47	2150	2	socked
stacked	14	34	1612	2	stacked
sucked	13	41	2049	2	sucked
swacked	17	31	1052	2	swacked
tacker	12	42	2450	2	tacker
tacket	12	46	2749	2	tacket
tackey	15	46	1308	2	tackey
tackled	14	39	1318	2	tackled
talcked	14	4	634	2	talcked
talked	11	40	1540	2	talked
tanked	11	39	1929	2	tanked
tasked	11	47	1464	2	tasked
thacked	17	38	1020	2	thacked
ticked	13	47	2052	2	ticked
tracked	14	37	1613	2	tracked
tucked	13	40	1749	2	tucked
wacke	14	59	1862	2	wacke_
wacker	15	49	2012	2	wacker
wackes	15	47	1771	2	wackes
waked	13	56	2675	2	wa_ked
walked	14	53	1378	2	walked
wanked	14	45	1715	2	wanked
warked	14	44	2121	2	warked
wauked	14	42	1057	2	wauked
whacked	20	45	862	2	whacked
wicked	16	43	1741	2	wicked
wracked	17	41	1011	2	wracked
yachted	16	3	485	2	yachted
yack	13	54	2597	2	yack__
yacks	14	44	1981	2	yack_s
yaffed	16	45	732	2	yaffed
yakker	12	40	553	2	yakker
yapped	14	44	1514	2	yapped
yarded	11	47	1402	2	yarded
yarned	10	55	1402	2	yarned
yauped	12	40	833	2	yauped
yawed	12	60	2245	2	ya_wed
yawled	13	45	998	2	yawled
yawned	13	50	984	2	yawned
yawped	15	52	810	2	yawped
yerked	14	50	937	2	yerked
yeuked	14	45	623	2	yeuked
yoked	13	48	2162	2	y_oked
yolked	14	36	715	2	yolked
yukked	13	31	487	2	yukked

Search took 4 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.110	1624463.6
2	DLD Change Limit	82551	156	3.203	25773.0
3	Display Results	156	156	0.076	2052.6
	(SQL Overall)	178691	156	3.389	52726.8