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

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

87 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
sweeps	11	41	1051	(None)
seeps	7	48	2875	1	s_eeps
sleeps	8	39	1332	1	sleeps
steeps	8	52	1519	1	steeps
sweep	10	47	1572	1	sweep_
sweepy	14	44	745	1	sweepy
sweets	9	42	1443	1	sweets
weeps	10	41	2056	1	_weeps
beeps	9	53	2097	2	_beeps
beweeps	14	9	456	2	beweeps
bleeps	10	49	910	2	bleeps
cheeps	13	53	1291	2	cheeps
creeps	10	42	1362	2	creeps
deeps	8	49	2177	2	_deeps
dweebs	12	3	365	2	dweebs
jeeps	14	47	1537	2	_jeeps
keeps	11	60	2028	2	_keeps
kreeps	12	42	741	2	kreeps
neeps	7	56	1788	2	_neeps
peeps	9	58	2236	2	_peeps
saleps	8	50	1490	2	saleps
seeds	6	43	3006	2	s_eeds
seeks	9	47	2464	2	s_eeks
seels	5	56	3282	2	s_eels
seems	7	55	2502	2	s_eems
seep	6	65	4034	2	s_eep_
seepy	10	47	1797	2	s_eepy
seers	5	51	3638	2	s_eers
sees	4	53	6105	2	s_ee_s
sewers	9	47	1971	2	sewers
sheens	9	51	1699	2	sheens
sheep	10	53	2152	2	sheep_
sheers	9	43	2240	2	sheers
sheets	9	39	1849	2	sheets
shleps	11	47	1033	2	shleps
skeens	10	39	1291	2	skeens
skees	9	50	2312	2	skee_s
skeets	10	45	1325	2	skeets
skelps	12	40	792	2	skelps
skeps	11	56	1425	2	s_keps
sleeks	10	45	1246	2	sleeks
sleep	7	49	2018	2	sleep_
sleepy	11	47	941	2	sleepy
sleets	6	43	1887	2	sleets
smeeks	12	42	843	2	smeeks
sneaps	8	45	1086	2	sneaps
sneers	6	40	1617	2	sneers
speeds	9	43	1605	2	speeds
speels	8	51	1639	2	speels
speers	8	50	1995	2	speers
steeds	7	38	1488	2	steeds
steeks	10	36	1370	2	steeks
steels	6	41	1798	2	steels
steep	7	60	2070	2	steep_
steers	6	38	2098	2	steers
steps	7	66	1988	2	s_teps
streps	8	62	1806	2	streps
swamps	13	59	1026	2	swamps
swaps	10	48	1920	2	sw_aps
swears	9	41	1407	2	swears
sweats	9	48	1461	2	sweats
swedes	10	27	1189	2	swedes
sweeny	12	35	884	2	sweeny
sweeper	12	32	937	2	sweeper
sweepers	13	34	816	2	sweepers
sweer	8	49	1857	2	swee_r
sweet	8	53	3052	2	swee_t
swells	9	39	1398	2	swells
swept	10	57	2060	2	sw_ept
swevens	13	3	461	2	swevens
swipes	11	41	1433	2	swipes
swoops	11	49	1092	2	swoops
swops	10	59	1397	2	sw_ops
tweeds	10	49	843	2	tweeds
tweens	9	48	984	2	tweens
tweets	9	42	1010	2	tweets
twerps	11	34	515	2	twerps
upsweeps	15	4	177	2	upsweeps
veeps	10	47	1572	2	_veeps
weeds	9	52	2221	2	_weeds
weeks	12	50	1786	2	_weeks
weens	8	52	2405	2	_weens
weep	9	51	3165	2	_weep_
weepy	13	42	1259	2	_weepy
wees	7	62	4912	2	_wee_s
weets	8	54	2772	2	_weets
wheeps	14	43	995	2	wheeps

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.126	1418182.5
2	DLD Change Limit	82551	87	2.466	33475.7
3	Display Results	87	87	0.016	5437.5
	(SQL Overall)	178691	87	2.608	68516.5