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

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

67 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
wreck	14	46	1104	(None)
dreck	12	48	1280	1	dreck
reck	10	61	3056	1	_reck
wrack	14	54	1388	1	wrack
wreak	12	55	1327	1	wreak
wrecks	15	41	888	1	wrecks
wrick	14	40	1339	1	wrick
areca	7	56	1863	2	areca
beck	12	62	2657	2	_beck
break	11	53	1940	2	break
brick	13	46	1815	2	brick
brock	13	60	1707	2	brock
check	16	47	1471	2	check
crack	13	41	2053	2	crack
creak	11	54	1843	2	creak
creek	11	49	1739	2	creek
crick	13	51	1875	2	crick
crock	13	59	2199	2	crock
cruck	13	56	1532	2	cruck
deck	11	58	2775	2	_deck
drecks	13	45	920	2	drecks
drecky	16	48	633	2	drecky
drek	9	63	2108	2	dre_k
erect	7	41	2933	2	erect
feck	13	49	2343	2	_feck
fleck	14	82	1359	2	fleck
freak	12	51	1524	2	freak
frock	14	53	1465	2	frock
geck	11	57	2199	2	_geck
greek	10	59	1594	2	greek
heck	13	58	2649	2	_heck
keck	9	49	2071	2	_keck
neck	10	54	2366	2	_neck
peck	12	57	3068	2	_peck
prick	13	43	1750	2	prick
rack	10	62	3488	2	_rack
rec	5	56	4546	2	_rec_
recks	11	56	2513	2	_recks
recs	6	57	3418	2	_recs
reek	8	52	3252	2	_reek
rick	10	73	3465	2	_rick
rock	10	57	3518	2	_rock
ruck	10	47	2833	2	_ruck
sneck	11	47	1366	2	sneck
speck	13	51	1565	2	speck
track	11	48	2301	2	track
trek	8	62	2231	2	tre_k
trick	11	54	2069	2	trick
trock	11	48	1760	2	trock
truck	11	61	1546	2	truck
wack	13	53	3091	2	w_ack
weak	11	71	2630	2	w_eak
week	11	64	2815	2	w_eek
whack	17	48	1302	2	whack
whelk	15	43	1106	2	whelk
wick	13	57	2630	2	w_ick
wracks	15	47	1111	2	wracks
wreaks	13	47	1111	2	wreaks
wrecked	17	41	833	2	wrecked
wrecker	16	36	760	2	wrecker
wren	7	82	2168	2	wre_n
wrench	14	43	935	2	wrench
wrens	8	50	1624	2	wrens
wrest	8	49	2543	2	wrest
wretch	14	32	653	2	wretch
wricks	15	46	1062	2	wricks
wryneck	19	4	138	2	wryneck

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	67	2.500	21520.0
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	2.626	68046.8