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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

91 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
wracks	15	47	1111	(None)
cracks	14	48	1700	1	cracks
racks	11	50	2885	1	_racks
tracks	12	48	1884	1	tracks
wacks	14	66	2628	1	w_acks
whacks	18	46	1048	1	whacks
wrack	14	54	1388	1	wrack_
wrecks	15	41	888	1	wrecks
wricks	15	46	1062	1	wricks
araks	9	48	2088	2	ara_ks
arracks	13	8	773	2	arracks
backs	13	57	2962	2	_backs
blacks	14	49	1495	2	blacks
braces	10	84	2777	2	braces
brachs	13	44	1575	2	brachs
bracts	10	56	1777	2	bracts
branks	12	48	1738	2	branks
bricks	14	46	1462	2	bricks
brocks	14	52	1415	2	brocks
caracks	15	22	1156	2	caracks
clacks	14	45	1634	2	clacks
crack	13	41	2053	2	crack_
cracky	17	50	1022	2	cracky
cranks	12	50	1531	2	cranks
cricks	14	43	1605	2	cricks
crocks	14	51	1842	2	crocks
crucks	14	44	1258	2	crucks
drecks	13	45	920	2	drecks
flacks	15	41	1453	2	flacks
fracas	11	3	1199	2	fracas
franks	13	49	1273	2	franks
frocks	15	41	1121	2	frocks
graces	9	45	2349	2	graces
hacks	14	49	2871	2	_hacks
jacks	18	52	1983	2	_jacks
knacks	11	42	854	2	knacks
kyacks	14	41	606	2	kyacks
lacks	11	61	2920	2	_lacks
macks	13	51	2760	2	_macks
packs	13	55	2893	2	_packs
placks	14	44	1415	2	placks
pranks	12	48	1472	2	pranks
pricks	14	44	1426	2	pricks
quacks	21	47	1010	2	quacks
races	7	49	4324	2	_races
rack	10	62	3488	2	_rack_
ranks	9	52	2573	2	_ranks
recks	11	56	2513	2	_recks
reracks	13	23	1053	2	reracks
ricks	11	51	2613	2	_ricks
rocks	11	46	2641	2	_rocks
rucks	11	44	2205	2	_rucks
sacks	11	42	2887	2	_sacks
shacks	15	48	1756	2	shacks
slacks	12	44	1653	2	slacks
smacks	14	41	1232	2	smacks
snacks	12	45	1455	2	snacks
stacks	12	43	1726	2	stacks
tacks	11	54	3013	2	_tacks
thacks	15	43	1192	2	thacks
traces	8	53	2993	2	traces
track	11	48	2301	2	track_
tracts	8	50	1907	2	tracts
traiks	10	40	1371	2	traiks
tranks	10	40	1776	2	tranks
tricks	12	53	1901	2	tricks
trocks	12	36	1463	2	trocks
trucks	12	47	1197	2	trucks
wack	13	53	3091	2	w_ack_
wacke	14	59	1862	2	w_acke
wackes	15	47	1771	2	w_ackes
wacko	14	55	1438	2	w_acko
wackos	15	52	1099	2	w_ackos
wacky	17	47	1493	2	w_acky
walks	12	62	1850	2	w_alks
wanks	12	61	2448	2	w_anks
warks	12	79	3240	2	w_arks
wauks	12	55	1516	2	w_auks
whack	17	48	1302	2	whack_
whacko	18	47	703	2	whacko
whackos	19	37	526	2	whackos
whacky	21	55	649	2	whacky
wicks	14	46	1936	2	w_icks
wracked	17	41	1011	2	wracked
wrangs	10	46	1191	2	wrangs
wraps	10	56	1715	2	wra_ps
wraths	12	38	1008	2	wraths
wreaks	13	47	1111	2	wreaks
wreck	14	46	1104	2	wreck_
wrick	14	40	1339	2	wrick_
yacks	14	44	1981	2	_yacks

Search took 6 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.220	812231.8
2	DLD Change Limit	82551	91	5.110	16154.8
3	Display Results	91	91	0.060	1516.7
	(SQL Overall)	178691	91	5.390	33152.3