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

Here are the results of your fuzzy-string dictionary search for “specks” 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
specks	14	43	1270	(None)
pecks	13	57	2443	1	_pecks
snecks	12	44	1003	1	snecks
speaks	12	51	1458	1	speaks
speck	13	51	1565	1	speck_
specs	9	69	1667	1	spec_s
spicks	14	48	1499	1	spicks
aspects	11	4	674	2	aspects
becks	13	55	2201	2	_becks
checks	17	49	1270	2	checks
copecks	17	4	587	2	copecks
decks	12	48	2219	2	_decks
drecks	13	45	920	2	drecks
fecks	14	54	1785	2	_fecks
flecks	15	43	1080	2	flecks
gecks	12	51	1709	2	_gecks
hecks	14	52	2065	2	_hecks
kecks	10	54	1657	2	_kecks
kopecks	14	3	307	2	kopecks
necks	11	51	1933	2	_necks
packs	13	55	2893	2	_packs
peaks	11	48	2562	2	_peaks
pechs	12	55	1620	2	_pechs
peck	12	57	3068	2	_peck_
pecky	16	55	1509	2	_pecky
pecs	8	46	3410	2	_pec_s
peeks	11	50	2111	2	_peeks
perks	11	53	2580	2	_perks
picks	13	52	2614	2	_picks
pocks	13	50	2296	2	_pocks
pucks	13	43	2210	2	_pucks
recks	11	56	2513	2	_recks
sacks	11	42	2887	2	s_acks
secs	6	50	3389	2	s_ec_s
sects	7	56	2289	2	s_ects
seeks	9	47	2464	2	s_eeks
shacks	15	48	1756	2	shacks
sheiks	13	25	1001	2	sheiks
shocks	15	44	1458	2	shocks
shucks	15	40	1041	2	shucks
sicks	11	51	2762	2	s_icks
slacks	12	44	1653	2	slacks
sleeks	10	45	1246	2	sleeks
slicks	12	48	1611	2	slicks
smacks	14	41	1232	2	smacks
smeeks	12	42	843	2	smeeks
smerks	12	44	971	2	smerks
smocks	14	57	1001	2	smocks
snacks	12	45	1455	2	snacks
sneaks	10	43	1249	2	sneaks
sneck	11	47	1366	2	sneck_
snicks	12	43	1247	2	snicks
socks	11	49	2608	2	s_ocks
spaces	10	47	2263	2	spaces
spanks	12	45	1412	2	spanks
sparks	12	46	1636	2	sparks
speak	11	46	1867	2	speak_
speans	8	54	1714	2	speans
spears	8	40	1947	2	spears
spec	8	58	2197	2	spec__
specie	10	4	1222	2	specie
species	11	3	1413	2	species
specked	16	32	901	2	specked
speckle	15	29	755	2	speckle
speckles	16	26	813	2	speckles
speeds	9	43	1605	2	speeds
speels	8	51	1639	2	speels
speers	8	50	1995	2	speers
speils	8	41	1622	2	speils
speirs	8	50	1323	2	speirs
speiss	8	43	1164	2	speiss
spells	8	46	1768	2	spells
spelts	8	46	1464	2	spelts
spences	11	34	1392	2	spences
spends	9	47	1447	2	spends
sperms	10	25	1260	2	sperms
spews	10	50	1592	2	spe_ws
spicas	10	47	1582	2	spicas
spices	10	43	2603	2	spices
spick	13	45	1907	2	spick_
spics	9	41	2324	2	spic_s
spiks	11	41	1747	2	sp_iks
spooks	12	43	1293	2	spooks
spunks	12	34	933	2	spunks
stacks	12	43	1726	2	stacks
steaks	10	44	1585	2	steaks
steeks	10	36	1370	2	steeks
sticks	12	51	1861	2	sticks
stocks	12	47	1563	2	stocks
sucks	11	45	2307	2	s_ucks
wrecks	15	41	888	2	wrecks

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	91	2.390	34540.2
3	Display Results	91	91	0.033	2757.6
	(SQL Overall)	178691	91	2.533	70545.2