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

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

291 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
seep	6	65	4034	(None)
beep	8	59	3121	1	beep
deep	7	60	3188	1	deep
jeep	13	56	2484	1	jeep
keep	10	63	2981	1	keep
neep	6	57	2831	1	neep
peep	8	58	3369	1	peep
see	3	57	7226	1	see_
seed	5	55	4948	1	seed
seek	8	59	3548	1	seek
seel	4	50	4298	1	seel
seem	6	54	3856	1	seem
seen	4	69	4312	1	seen
seeps	7	48	2875	1	seeps
seepy	10	47	1797	1	seepy
seer	4	55	4704	1	seer
sees	4	53	6105	1	sees
sheep	10	53	2152	1	sheep
skep	10	52	1935	1	skep
sleep	7	49	2018	1	sleep
steep	7	60	2070	1	steep
step	6	71	2629	1	step
sweep	10	47	1572	1	sweep
veep	9	53	2509	1	veep
weep	9	51	3165	1	weep
asleep	8	4	728	2	asleep
bee	5	62	6240	2	bee_
beef	9	62	3368	2	beef
been	6	53	3578	2	been
beeps	9	53	2097	2	beeps
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
bleep	9	50	1345	2	bleep
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
cep	7	57	3633	2	_cep
cepe	8	49	2665	2	cepe
cheep	12	54	1650	2	cheep
creep	9	52	1810	2	creep
dee	4	76	6582	2	dee_
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deeps	8	49	2177	2	deeps
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
eses	4	53	3610	2	eses
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
gee	4	53	5920	2	gee_
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
heap	9	64	3289	2	heap
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
help	9	53	2892	2	help
hemp	11	57	2562	2	hemp
hep	8	66	4414	2	_hep
jee	10	66	4864	2	jee_
jeed	12	54	2850	2	jeed
jeeps	14	47	1537	2	jeeps
jeer	11	54	2646	2	jeer
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
keef	11	58	2999	2	keef
keek	7	56	2496	2	keek
keel	8	57	2946	2	keel
keen	8	48	3040	2	keen
keeps	11	60	2028	2	keeps
keet	8	53	4733	2	keet
kelep	11	60	1455	2	kelep
kelp	10	53	2280	2	kelp
kemp	12	64	1876	2	kemp
kep	9	64	3720	2	_kep
kreep	11	46	1041	2	kreep
leap	6	60	3268	2	leap
lee	3	60	6814	2	lee_
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
neap	6	69	2701	2	neap
nee	3	66	5778	2	nee_
need	5	49	3415	2	need
neem	6	73	2808	2	neem
neeps	7	56	1788	2	neeps
pee	5	60	6651	2	pee_
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peeps	9	58	2236	2	peeps
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
pep	7	64	4708	2	_pep
perp	8	90	2989	2	perp
prep	8	64	2767	2	prep
reap	6	59	3474	2	reap
ree	3	79	7407	2	ree_
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
rep	5	58	4780	2	_rep
repp	8	54	1874	2	repp
sae	3	83	6518	2	sae_
salep	7	70	2295	2	salep
salp	6	45	3409	2	salp
samp	8	57	3359	2	samp
sap	5	64	6323	2	s_ap
scop	8	59	2552	2	scop
scup	8	48	2238	2	scup
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	2675	2	seder
seeds	6	43	3006	2	seeds
seedy	9	48	2153	2	seedy
seeks	9	47	2464	2	seeks
seels	5	56	3282	2	seels
seely	8	45	2263	2	seely
seems	7	55	2502	2	seems
seeped	9	43	1752	2	seeped
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	3550	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
setup	7	39	1582	2	setup
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	2621	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
sheer	8	47	2689	2	sheer
sheet	8	48	3696	2	sheet
shes	7	57	3435	2	shes
shew	10	80	3076	2	shew
ship	9	52	2824	2	ship
shlep	10	49	1483	2	shlep
shop	9	56	2984	2	shop
simp	8	52	2877	2	simp
sip	5	76	5601	2	s_ip
sipe	6	73	4104	2	sipe
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
skelp	11	42	1142	2	skelp
skeps	11	56	1425	2	skeps
skew	11	62	1876	2	skew
skip	10	54	2175	2	skip
slap	6	64	3404	2	slap
sled	5	53	3437	2	sled
sleek	9	46	1904	2	sleek
sleeps	8	39	1332	2	sleeps
sleepy	11	47	941	2	sleepy
sleet	5	56	3913	2	sleet
slept	7	57	2810	2	slept
slew	7	62	2823	2	slew
slip	6	70	3173	2	slip
slop	6	65	3387	2	slop
smeek	11	49	1235	2	smeek
smew	9	50	1773	2	smew
snap	6	57	2703	2	snap
sneap	7	55	1482	2	sneap
sned	5	60	2605	2	sned
sneer	5	49	1995	2	sneer
snip	6	64	2465	2	snip
soap	6	58	3113	2	soap
sop	5	75	5786	2	s_op
soup	6	62	3291	2	soup
spec	8	58	2197	2	spec
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
steed	6	60	2494	2	steed
steek	9	54	1800	2	steek
steel	5	57	2199	2	steel
steeps	8	52	1519	2	steeps
steer	5	54	2386	2	steer
stem	6	106	2825	2	stem
steps	7	66	1988	2	steps
stet	4	59	4732	2	stet
stew	7	75	2546	2	stew
stey	7	62	2441	2	stey
stop	6	65	3203	2	stop
strep	7	71	2085	2	strep
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
sump	8	63	3153	2	sump
sup	5	70	4194	2	s_up
supe	6	59	3276	2	supe
swap	9	59	2543	2	swap
sweeps	11	41	1051	2	sweeps
sweepy	14	44	745	2	sweepy
sweer	8	49	1857	2	sweer
sweet	8	53	3052	2	sweet
swept	10	57	2060	2	swept
swop	9	51	2050	2	swop
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
temp	8	53	2333	2	temp
vee	6	57	5018	2	vee_
veeps	10	47	1572	2	veeps
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
wee	6	67	6081	2	wee_
weed	8	56	3751	2	weed
week	11	64	2815	2	week
weel	7	58	3408	2	weel
ween	7	58	3546	2	ween
weeps	10	41	2056	2	weeps
weepy	13	42	1259	2	weepy
weer	7	55	3509	2	weer
wees	7	62	4912	2	wees
weet	7	52	5415	2	weet
wheep	13	62	1435	2	wheep
yelp	9	56	2135	2	yelp
yep	8	66	3896	2	_yep
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees
zep	14	71	2914	2	_zep

Search took 1 second 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.060	2978183.3
2	DLD Change Limit	29872	291	0.783	38150.7
3	Display Results	291	291	0.060	4850.0
	(SQL Overall)	178691	291	0.903	197885.9