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

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

226 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
racked	13	45	2608	(None)
arcked	13	62	1194	1	arcked
backed	15	57	2572	1	backed
cracked	16	35	1474	1	cracked
hacked	16	49	2351	1	hacked
jacked	20	48	1752	1	jacked
lacked	13	53	2465	1	lacked
packed	15	48	2260	1	packed
raced	8	76	3531	1	rac_ed
racker	12	48	2455	1	racker
racket	12	52	2942	1	racket
raked	10	58	3142	1	ra_ked
ranked	11	46	2074	1	ranked
recked	13	48	2180	1	recked
ricked	13	65	2362	1	ricked
rocked	13	50	2232	1	rocked
rucked	13	47	1876	1	rucked
sacked	13	55	2521	1	sacked
tacked	13	47	2394	1	tacked
tracked	14	37	1613	1	tracked
wracked	17	41	1011	1	wracked
yacked	16	45	1679	1	yacked
aced	7	95	4088	2	_ac_ed
ached	11	92	2783	2	_ached
ackee	11	58	2537	2	_ackee
acned	8	75	2067	2	_acned
acred	8	71	2635	2	_acred
acted	8	85	2173	2	_acted
arced	8	82	2416	2	arc_ed
arched	12	57	1732	2	arched
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
braced	11	54	2060	2	brac_ed
bracken	15	40	981	2	bracken
bracket	15	41	1723	2	bracket
bracted	12	4	1093	2	bracted
braked	13	53	1869	2	bra_ked
bricked	16	43	1206	2	bricked
bucked	15	51	2106	2	bucked
cached	14	54	1920	2	cached
cackled	16	46	1330	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
cracker	15	31	1417	2	cracker
crackled	17	42	886	2	crackled
cranked	14	38	1284	2	cranked
cricked	16	48	1428	2	cricked
crocked	16	40	1443	2	crocked
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
fracted	13	3	937	2	fracted
franked	15	36	1005	2	franked
frocked	17	43	933	2	frocked
fucked	16	41	1448	2	fucked
gawked	15	46	876	2	gawked
gecked	14	69	1193	2	gecked
graced	10	52	1790	2	grac_ed
hackee	15	49	2183	2	hackee
hacker	15	48	2269	2	hacker
hackled	17	33	1249	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	1317	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	1192	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	2514	2	parked
pecked	15	50	1910	2	pecked
picked	15	44	2131	2	picked
pocked	15	48	1898	2	pocked
pranked	14	37	1209	2	pranked
pricked	16	46	1383	2	pricked
quacked	23	3	679	2	quacked
race	6	67	4626	2	rac_e_
racemed	12	3	701	2	racemed
racer	7	52	3302	2	rac_er
races	7	49	4324	2	rac_es
rachet	11	50	2897	2	rachet
racier	8	51	2097	2	racier
rack	10	62	3488	2	rack__
rackers	13	43	2045	2	rackers
racketed	15	16	912	2	racketed
rackets	13	49	1687	2	rackets
rackety	16	49	911	2	rackety
rackle	12	39	1729	2	rackle
racks	11	50	2885	2	rack_s
radded	9	47	1649	2	radded
rafted	10	47	1470	2	rafted
raged	7	48	2945	2	ra_ged
ragged	9	46	2026	2	ragged
raided	8	50	1770	2	raided
railed	7	47	2754	2	railed
rained	7	50	2460	2	rained
raised	7	61	2033	2	raised
rake	8	48	4157	2	ra_ke_
rakee	9	60	3117	2	ra_kee
raker	9	45	2979	2	ra_ker
rakes	9	44	4035	2	ra_kes
rammed	11	31	1730	2	rammed
ramped	11	46	1790	2	ramped
ranched	13	31	1360	2	ranched
ranged	8	48	2431	2	ranged
ranker	10	50	2190	2	ranker
rankled	12	39	1065	2	rankled
ranted	7	43	2470	2	ranted
raped	8	53	3462	2	ra_ped
rapped	11	41	2268	2	rapped
rared	6	57	3832	2	ra_red
rased	6	50	3393	2	ra_sed
rasped	9	47	1520	2	rasped
rated	6	54	4138	2	ra_ted
ratted	7	49	2334	2	ratted
raved	9	49	3143	2	ra_ved
raxed	13	56	2266	2	ra_xed
rayed	9	51	2750	2	ra_yed
razed	15	50	2798	2	ra_zed
razeed	16	37	1001	2	razeed
razzed	15	47	828	2	razzed
reached	13	46	1908	2	reached
reacted	10	30	1571	2	reacted
reeked	11	37	1764	2	reeked
repacked	17	18	874	2	repacked
reracked	15	16	912	2	reracked
retacked	15	16	927	2	retacked
riced	8	58	2554	2	ric_ed
rickey	15	46	1397	2	rickey
risked	11	55	1463	2	risked
roached	13	32	1183	2	roached
rocker	12	43	1957	2	rocker
rocket	12	54	2528	2	rocket
rooked	11	49	1814	2	rooked
ruched	12	43	1463	2	ruched
ruckled	14	41	1103	2	ruckled
ryked	13	66	951	2	r_yked
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	1319	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
traced	9	48	2158	2	trac_ed
tracker	13	35	1517	2	tracker
traiked	12	33	1045	2	traiked
tricked	14	40	1616	2	tricked
trocked	14	43	1224	2	trocked
trucked	14	39	1081	2	trucked
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
wrecked	17	41	833	2	wrecked
wricked	17	49	1019	2	wricked
yakked	13	36	609	2	yakked
yanked	14	43	1224	2	yanked
yocked	16	41	1442	2	yocked
yucked	16	40	1356	2	yucked

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.376	475242.0
2	DLD Change Limit	82551	226	2.560	32246.5
3	Display Results	226	226	0.080	2825.0
	(SQL Overall)	178691	226	3.016	59247.7