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

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

155 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
spec	8	58	2197	(None)
pec	7	67	4441	1	_pec
sec	5	59	4532	1	s_ec
speck	13	51	1565	1	speck
specs	9	69	1667	1	specs
sped	7	60	3149	1	sped
spew	9	54	2187	1	spew
spic	8	52	2743	1	spic
alec	6	64	3006	2	alec
ape	5	72	5118	2	ape_
aped	7	85	3815	2	aped
aper	6	63	3623	2	aper
apes	6	60	4743	2	apes
apex	13	72	2021	2	apex
aspect	10	6	1282	2	aspect
aspen	7	52	1609	2	aspen
asper	7	55	2043	2	asper
aspic	9	51	1473	2	aspic
epee	6	46	2850	2	epee
epic	8	69	2130	2	epic
exec	13	53	1394	2	exec
ope	5	68	4524	2	ope_
oped	7	62	3015	2	oped
open	6	64	2700	2	open
opes	6	59	4261	2	opes
pac	7	90	5408	2	_pac
pe	4	76	4903	2	_pe_
pea	5	66	5724	2	_pea
pech	11	61	2545	2	_pech
peck	12	57	3068	2	_peck
pecs	8	46	3410	2	_pecs
ped	6	67	5152	2	_ped
pee	5	60	6651	2	_pee
peg	6	58	4306	2	_peg
peh	8	67	4096	2	_peh
pen	5	65	5884	2	_pen
pep	7	64	4708	2	_pep
per	5	63	5309	2	_per
pes	5	72	5978	2	_pes
pet	5	64	7730	2	_pet
pew	8	64	4230	2	_pew
pic	7	60	4682	2	_pic
rec	5	56	4546	2	_rec
sac	5	74	5286	2	s_ac
sae	3	83	6518	2	sae_
sea	3	61	6129	2	s_ea
secs	6	50	3389	2	s_ecs
sect	6	74	4362	2	s_ect
see	3	57	7226	2	s_ee
seed	5	55	4948	2	seed
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seem	6	54	3856	2	seem
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seer	4	55	4704	2	seer
sees	4	53	6105	2	sees
seg	4	55	4488	2	s_eg
sei	3	60	4893	2	s_ei
sel	3	82	5332	2	s_el
sen	3	60	5852	2	s_en
sepic	9	46	1705	2	sepic
sept	6	58	4436	2	sept
ser	3	67	5240	2	s_er
set	3	66	8125	2	s_et
sew	6	62	4726	2	s_ew
sex	10	70	4322	2	s_ex
she	6	68	3769	2	she_
shea	7	60	3157	2	shea
shed	8	65	3615	2	shed
shes	7	57	3435	2	shes
shew	10	80	3076	2	shew
sic	5	58	4787	2	s_ic
sice	6	55	4559	2	sice
sipe	6	73	4104	2	sipe_
siped	8	49	2768	2	siped
sipes	7	60	3695	2	sipes
skee	8	54	3147	2	skee
skeg	9	53	1616	2	skeg
skep	10	52	1935	2	skep
skew	11	62	1876	2	skew
sled	5	53	3437	2	sled
slew	7	62	2823	2	slew
smew	9	50	1773	2	smew
sneck	11	47	1366	2	sneck
sned	5	60	2605	2	sned
spa	5	57	3081	2	sp_a
space	9	53	2567	2	space
spacy	12	54	1562	2	spacy
spae	6	50	3432	2	spae
spaed	8	55	2227	2	spaed
spaes	7	60	2997	2	spaes
spam	8	59	3004	2	spam
span	6	52	3466	2	span
spar	6	54	3330	2	spar
spas	6	70	3672	2	spas
spat	6	65	4852	2	spat
spay	9	66	3166	2	spay
spaz	15	56	2616	2	spaz
speak	11	46	1867	2	speak
spean	7	46	2051	2	spean
spear	7	58	2106	2	spear
specie	10	4	1222	2	specie
specks	14	43	1270	2	specks
speech	13	4	756	2	speech
speed	8	55	2662	2	speed
speel	7	44	2076	2	speel
speer	7	46	2390	2	speer
speil	7	56	1864	2	speil
speir	7	53	1536	2	speir
spell	7	50	2030	2	spell
spelt	7	54	3019	2	spelt
spence	10	38	1379	2	spence
spend	8	56	1933	2	spend
spent	7	55	3283	2	spent
sperm	9	32	1602	2	sperm
spews	10	50	1592	2	spews
spica	9	47	1794	2	spica
spice	9	55	2881	2	spice
spick	13	45	1907	2	spick
spics	9	41	2324	2	spics
spicy	12	54	1771	2	spicy
spied	8	54	2771	2	spied
spiel	7	46	2391	2	spiel
spier	7	57	2803	2	spier
spies	7	60	3762	2	spies
spik	10	54	1971	2	spik
spin	6	62	3130	2	spin
spit	6	55	4508	2	spit
spiv	9	59	1779	2	spiv
spot	6	55	4069	2	spot
spree	7	48	3086	2	spree
spry	9	68	1912	2	spry
spud	7	58	1849	2	spud
spue	6	60	2552	2	spue
spued	8	49	1847	2	spued
spues	7	50	2538	2	spues
spun	6	62	2146	2	spun
spur	6	53	2119	2	spur
spy	8	60	2374	2	sp_y
stem	6	106	2825	2	stem
step	6	71	2629	2	step
stet	4	59	4732	2	stet
stew	7	75	2546	2	stew
stey	7	62	2441	2	stey
sue	3	56	5146	2	sue_
sued	5	65	3793	2	sued
suer	4	53	3403	2	suer
sues	4	62	4765	2	sues
suet	4	67	5482	2	suet
supe	6	59	3276	2	supe_
super	7	49	2448	2	super
supes	7	56	2830	2	supes
syce	9	58	2028	2	syce
sync	9	54	1510	2	sync

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	29872	0.673	265514.1
2	DLD Change Limit	29872	155	1.423	20992.3
3	Display Results	155	155	0.043	3604.7
	(SQL Overall)	178691	155	2.139	83539.5