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

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

294 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
seek	8	59	3548	(None)
eek	7	79	3510	1	_eek
geek	9	53	2702	1	geek
keek	7	56	2497	1	keek
leek	8	53	3173	1	leek
meek	10	56	2483	1	meek
peek	10	60	3143	1	peek
reek	8	52	3252	1	reek
see	3	57	7226	1	see_
seed	5	55	4948	1	seed
seeks	9	47	2464	1	seeks
seel	4	50	4298	1	seel
seem	6	54	3856	1	seem
seen	4	69	4312	1	seen
seep	6	65	4034	1	seep
seer	4	55	4704	1	seer
sees	4	53	6105	1	sees
sleek	9	46	1904	1	sleek
smeek	11	49	1235	1	smeek
steek	9	54	1800	1	steek
week	11	64	2815	1	week
apeek	11	47	1187	2	apeek
beak	10	65	3438	2	beak
beck	12	62	2657	2	beck
bee	5	62	6240	2	bee_
beef	9	62	3368	2	beef
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
berk	10	59	2984	2	berk
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
cheek	14	51	1571	2	cheek
cleek	11	55	1491	2	cleek
creek	11	49	1739	2	creek
deck	11	58	2775	2	deck
dee	4	76	6582	2	dee_
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
deke	9	52	2876	2	deke
desk	9	56	1890	2	desk
drek	9	63	2109	2	drek
eel	3	79	4684	2	_eel
eke	7	56	3009	2	_eke
elk	7	67	2612	2	_elk
eses	4	53	3610	2	eses
feck	13	49	2343	2	feck
fee	6	68	6201	2	fee_
feeb	9	69	2454	2	feeb
feed	8	45	3890	2	feed
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
feet	7	53	5221	2	feet
geck	11	57	2199	2	geck
gee	4	53	5920	2	gee_
geed	6	54	3550	2	geed
geeks	10	49	1584	2	geeks
geeky	13	47	1073	2	geeky
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
gleek	10	53	1510	2	gleek
greek	10	59	1594	2	greek
heck	13	58	2649	2	heck
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
jee	10	66	4864	2	jee_
jeed	12	54	2850	2	jeed
jeep	13	56	2484	2	jeep
jeer	11	54	2646	2	jeer
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
jerk	15	49	2013	2	jerk
keck	9	49	2071	2	keck
keef	11	58	3000	2	keef
keeks	8	47	1725	2	keeks
keel	8	57	2947	2	keel
keen	8	48	3041	2	keen
keep	10	63	2982	2	keep
keet	8	53	4734	2	keet
leak	8	62	3371	2	leak
lee	3	60	6814	2	lee_
leeks	9	53	1889	2	leeks
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
lek	7	56	4030	2	_lek
leke	8	55	2740	2	leke
meed	7	49	3470	2	meed
meet	6	53	5055	2	meet
merk	10	60	2794	2	merk
neck	10	54	2366	2	neck
nee	3	66	5778	2	nee_
need	5	49	3415	2	need
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
neuk	8	74	1660	2	neuk
peak	10	65	3520	2	peak
peck	12	57	3068	2	peck
pee	5	60	6651	2	pee_
peed	7	62	3918	2	peed
peeks	11	50	2111	2	peeks
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
peke	10	59	2620	2	peke
perk	10	62	3284	2	perk
reck	10	61	3056	2	reck
ree	3	79	7407	2	ree_
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reeks	9	41	2403	2	reeks
reeky	12	54	1626	2	reeky
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
reseek	10	38	1313	2	reseek
sack	10	53	3731	2	sack
sae	3	83	6518	2	sae_
sake	8	52	4496	2	sake
samek	11	49	1527	2	samek
sank	8	52	3683	2	sank
sark	8	49	3897	2	sark
sea	3	61	6129	2	s_ea
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
sec	5	59	4532	2	s_ec
secs	6	50	3389	2	secs
sect	6	74	4362	2	sect
seder	6	48	2676	2	seder
seeds	6	43	3006	2	seeds
seedy	9	48	2153	2	seedy
seeker	10	36	1536	2	seeker
seels	5	56	3282	2	seels
seely	8	45	2263	2	seely
seems	7	55	2502	2	seems
seeps	7	48	2875	2	seeps
seepy	10	47	1797	2	seepy
seers	5	51	3638	2	seers
seg	4	55	4488	2	s_eg
sego	5	65	2518	2	sego
segs	5	49	3388	2	segs
sei	3	60	4893	2	s_ei
seif	7	56	3873	2	seif
seis	4	55	4239	2	seis
sel	3	82	5332	2	s_el
self	7	51	3829	2	self
sell	4	58	4061	2	sell
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
semen	7	57	2410	2	semen
semes	7	57	3158	2	semes
semi	6	51	2722	2	semi
sen	3	60	5852	2	s_en
send	5	52	3729	2	send
sene	4	68	4805	2	sene
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
ser	3	67	5240	2	s_er
sera	4	61	4139	2	sera
sere	4	61	5347	2	sere
sered	6	57	3729	2	sered
serer	5	59	3551	2	serer
seres	5	54	4889	2	seres
serf	7	63	4011	2	serf
sers	4	57	4665	2	sers
set	3	66	8125	2	s_et
seta	4	56	3731	2	seta
sets	4	55	4950	2	sets
sett	4	59	4905	2	sett
seven	8	41	1831	2	seven
sever	8	54	2605	2	sever
sew	6	62	4726	2	s_ew
sewed	9	53	2516	2	sewed
sewer	8	44	2622	2	sewer
sewn	7	61	2433	2	sewn
sews	7	58	3602	2	sews
sex	10	70	4322	2	s_ex
sexed	13	66	1854	2	sexed
sexes	12	61	2622	2	sexes
sext	11	73	3809	2	sext
sexy	14	64	1802	2	sexy
she	6	68	3769	2	she_
shea	7	60	3157	2	shea
shed	8	65	3615	2	shed
sheen	8	50	2331	2	sheen
sheep	10	53	2152	2	sheep
sheer	8	47	2689	2	sheer
sheet	8	48	3696	2	sheet
sheik	12	25	1466	2	sheik
shes	7	57	3435	2	shes
shew	10	80	3076	2	shew
sick	10	64	3557	2	sick
sike	8	71	3878	2	sike
silk	8	55	2932	2	silk
sink	8	66	4014	2	sink
skee	8	54	3147	2	skee
skeed	10	50	1898	2	skeed
skeen	9	48	1740	2	skeen
skees	9	50	2312	2	skees
skeet	9	54	2918	2	skeet
skeg	9	53	1616	2	skeg
skep	10	52	1935	2	skep
skew	11	62	1876	2	skew
sled	5	53	3437	2	sled
sleeks	10	45	1246	2	sleeks
sleeky	13	39	896	2	sleeky
sleep	7	49	2018	2	sleep
sleet	5	56	3913	2	sleet
slew	7	62	2823	2	slew
smeeks	12	42	843	2	smeeks
smerk	11	54	1272	2	smerk
smew	9	50	1773	2	smew
sneak	9	60	1617	2	sneak
sneck	11	47	1366	2	sneck
sned	5	60	2605	2	sned
sneer	5	49	1995	2	sneer
soak	8	72	2766	2	soak
sock	10	52	3321	2	sock
soke	8	54	3626	2	soke
sook	8	49	3339	2	sook
souk	8	61	2717	2	souk
speak	11	46	1867	2	speak
spec	8	58	2197	2	spec
speck	13	51	1565	2	speck
sped	7	60	3149	2	sped
speed	8	55	2662	2	speed
speel	7	44	2076	2	speel
speer	7	46	2390	2	speer
spew	9	54	2187	2	spew
spik	10	54	1971	2	spik
steak	9	52	1980	2	steak
steed	6	60	2494	2	steed
steeks	10	36	1370	2	steeks
steel	5	57	2199	2	steel
steep	7	60	2070	2	steep
steer	5	54	2386	2	steer
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
streek	10	41	1141	2	streek
suck	10	61	3173	2	suck
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
suk	7	56	3297	2	s_uk
sulk	8	53	2665	2	sulk
sunk	8	50	3181	2	sunk
sweep	10	47	1572	2	sweep
sweer	8	49	1857	2	sweer
sweet	8	53	3052	2	sweet
syke	11	54	2056	2	syke
teak	8	59	3084	2	teak
tee	3	83	6687	2	tee_
teed	5	54	3926	2	teed
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
trek	8	62	2231	2	trek
vee	6	57	5018	2	vee_
veep	9	53	2509	2	veep
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
weak	11	71	2630	2	weak
wee	6	67	6081	2	wee_
weed	8	56	3751	2	weed
weeks	12	50	1786	2	weeks
weel	7	58	3408	2	weel
ween	7	58	3546	2	ween
weep	9	51	3165	2	weep
weer	7	55	3509	2	weer
wees	7	62	4912	2	wees
weet	7	52	5415	2	weet
yelk	11	53	2000	2	yelk
yerk	11	62	2208	2	yerk
yeuk	11	60	1547	2	yeuk
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees
zek	16	73	2316	2	_zek
zerk	17	53	1925	2	zerk

Search took 2 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.280	638182.1
2	DLD Change Limit	29872	294	0.890	33564.0
3	Display Results	294	294	0.080	3675.0
	(SQL Overall)	178691	294	1.250	142952.8