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

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

354 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
seen	4	69	4312	(None)
been	6	53	3578	1	been
keen	8	48	3041	1	keen
peen	6	59	3808	1	peen
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
seep	6	65	4034	1	seep
seer	4	55	4704	1	seer
sees	4	53	6105	1	sees
semen	7	57	2410	1	semen
sen	3	60	5852	1	s_en
sene	4	68	4805	1	sene
seven	8	41	1831	1	seven
sewn	7	61	2433	1	sewn
sheen	8	50	2331	1	sheen
skeen	9	48	1740	1	skeen
teen	4	59	3820	1	teen
ween	7	58	3546	1	ween
aeon	4	56	3461	2	aeon
amen	6	67	3315	2	amen
ashen	8	78	1867	2	ashen
aspen	7	52	1609	2	aspen
bean	6	64	4386	2	bean
bee	5	62	6240	2	bee_
beef	9	62	3368	2	beef
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
ben	5	65	5492	2	_ben
bene	6	64	3949	2	bene
bren	6	56	2956	2	bren
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
dean	5	60	3948	2	dean
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
den	4	75	5434	2	_den
dene	5	66	4341	2	dene
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
en	2	80	5239	2	__en
eon	3	60	5208	2	_eon
ern	3	57	3836	2	_ern
eses	4	53	3610	2	eses
esne	4	70	1879	2	esne
even	7	52	2227	2	even
eyen	7	62	2366	2	eyen
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
fen	6	68	5135	2	_fen
fern	7	61	2932	2	fern
gaen	5	73	2960	2	gaen
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
gen	4	59	5051	2	_gen
gene	5	62	3722	2	gene
gien	5	63	3002	2	gien
glen	5	60	2720	2	glen
green	6	55	2214	2	green
haen	7	62	2945	2	haen
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
hen	6	75	5527	2	_hen
hern	7	61	3489	2	hern
hewn	10	67	1985	2	hewn
jean	11	66	2928	2	jean
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
jeon	11	68	2144	2	jeon
keef	11	58	3000	2	keef
keek	7	56	2497	2	keek
keel	8	57	2947	2	keel
keens	9	57	2118	2	keens
keep	10	63	2982	2	keep
keet	8	53	4734	2	keet
ken	7	63	4398	2	_ken
kern	8	53	2621	2	kern
lean	4	63	4524	2	lean
leben	7	3	1485	2	leben
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
lien	4	53	3980	2	lien
mean	6	55	3809	2	mean
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
men	5	92	5285	2	_men
mien	6	50	2836	2	mien
nee	3	66	5778	2	nee_
need	5	49	3415	2	need
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
nene	4	59	3206	2	nene
neon	4	70	2642	2	neon
omen	6	68	2818	2	omen
open	6	64	2700	2	open
oven	7	66	2414	2	oven
oxen	11	62	1859	2	oxen
pean	6	61	4717	2	pean
pee	5	60	6651	2	pee_
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peens	7	64	2819	2	peens
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
pein	6	58	3494	2	pein
pen	5	65	5884	2	_pen
peon	6	56	3524	2	peon
preen	7	59	2505	2	preen
queen	14	43	1206	2	queen
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
rein	4	60	4089	2	rein
reseen	6	43	1841	2	reseen
sae	3	83	6518	2	sae_
sain	4	55	5129	2	sain
sane	4	59	5434	2	sane
sateen	6	38	1501	2	sateen
sawn	7	54	2816	2	sawn
scan	6	55	3045	2	scan
scena	7	48	1578	2	scena
scend	8	55	1629	2	scend
scene	7	72	2057	2	scene
scent	7	58	3162	2	scent
screen	8	52	1602	2	screen
sea	3	61	6129	2	s_ea
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
seamen	8	45	1856	2	seamen
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
secern	8	10	1022	2	secern
secs	6	50	3389	2	secs
sect	6	74	4362	2	sect
sedan	6	56	2042	2	sedan
seder	6	48	2676	2	seder
seeds	6	43	3006	2	seeds
seedy	9	48	2153	2	seedy
seeing	7	42	2214	2	seeing
seeks	9	47	2464	2	seeks
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
segni	6	37	1248	2	segni
segno	6	48	1474	2	segno
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
seine	5	57	3287	2	seine
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
semens	8	46	1697	2	semens
semes	7	57	3158	2	semes
semi	6	51	2722	2	semi
send	5	52	3729	2	send
senna	5	46	1798	2	senna
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
serein	6	33	1846	2	serein
serene	6	35	2235	2	serene
serer	5	59	3551	2	serer
seres	5	54	4889	2	seres
serf	7	63	4011	2	serf
serin	5	54	3444	2	serin
sers	4	57	4665	2	sers
set	3	66	8125	2	s_et
seta	4	56	3731	2	seta
seton	5	52	2354	2	seton
sets	4	55	4950	2	sets
sett	4	59	4905	2	sett
sevens	9	38	1366	2	sevens
sever	8	54	2605	2	sever
sew	6	62	4726	2	s_ew
sewan	8	59	2129	2	sewan
sewed	9	53	2516	2	sewed
sewer	8	44	2622	2	sewer
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
sheens	9	51	1699	2	sheens
sheeny	12	49	1219	2	sheeny
sheep	10	53	2152	2	sheep
sheer	8	47	2689	2	sheer
sheet	8	48	3696	2	sheet
shend	9	47	1997	2	shend
shent	8	59	3350	2	shent
shes	7	57	3435	2	shes
shew	10	80	3076	2	shew
shewn	11	57	1570	2	shewn
shin	7	56	3431	2	shin
shun	7	51	2277	2	shun
sign	5	55	2305	2	sign
sin	3	62	6589	2	s_in
sine	4	65	6062	2	sine
siren	5	45	2582	2	siren
skean	9	44	1562	2	skean
skee	8	54	3147	2	skee
skeed	10	50	1898	2	skeed
skeens	10	39	1291	2	skeens
skees	9	50	2312	2	skees
skeet	9	54	2918	2	skeet
skeg	9	53	1616	2	skeg
skein	9	48	1441	2	skein
skene	9	61	1812	2	skene
skep	10	52	1935	2	skep
skew	11	62	1876	2	skew
skin	8	59	2753	2	skin
sled	5	53	3437	2	sled
sleek	9	46	1904	2	sleek
sleep	7	49	2018	2	sleep
sleet	5	56	3913	2	sleet
slew	7	62	2823	2	slew
smeek	11	49	1235	2	smeek
smew	9	50	1773	2	smew
sned	5	60	2605	2	sned
sneer	5	49	1995	2	sneer
son	3	77	6195	2	s_on
sone	4	66	4998	2	sone
soon	4	62	4050	2	soon
sorn	4	66	4106	2	sorn
sown	7	51	2745	2	sown
span	6	52	3466	2	span
spean	7	46	2051	2	spean
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
spend	8	56	1933	2	spend
spent	7	55	3283	2	spent
spew	9	54	2187	2	spew
spin	6	62	3130	2	spin
spleen	8	3	1026	2	spleen
spun	6	62	2146	2	spun
steed	6	60	2494	2	steed
steek	9	54	1800	2	steek
steel	5	57	2199	2	steel
steep	7	60	2070	2	steep
steer	5	54	2386	2	steer
stein	5	46	2054	2	stein
stem	6	106	2825	2	stem
steno	5	47	1686	2	steno
stent	5	56	3451	2	stent
step	6	71	2629	2	step
stern	5	53	1912	2	stern
stet	4	59	4732	2	stet
stew	7	75	2546	2	stew
stey	7	62	2441	2	stey
stun	4	56	2345	2	stun
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
sun	3	71	4903	2	s_un
sunn	4	54	2359	2	sunn
swan	7	66	3131	2	swan
sweeny	12	35	884	2	sweeny
sweep	10	47	1572	2	sweep
sweer	8	49	1857	2	sweer
sweet	8	53	3052	2	sweet
sweven	12	3	598	2	sweven
syn	6	70	2412	2	s_yn
syne	7	57	2576	2	syne
syren	8	52	1674	2	syren
tee	3	83	6687	2	tee_
teed	5	54	3926	2	teed
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teens	5	62	2748	2	teens
teeny	8	54	1788	2	teeny
tees	4	53	5358	2	tees
ten	3	58	5611	2	_ten
tern	4	61	3480	2	tern
then	7	84	2969	2	then
treen	5	56	2275	2	treen
tween	8	44	1374	2	tween
unseen	6	20	1262	2	unseen
vee	6	57	5018	2	vee_
veena	8	19	1232	2	veena
veep	9	53	2509	2	veep
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
vein	7	56	2575	2	vein
wean	7	57	3435	2	wean
wee	6	67	6081	2	wee_
weed	8	56	3751	2	weed
week	11	64	2815	2	week
weel	7	58	3408	2	weel
weens	8	52	2405	2	weens
weeny	11	53	1616	2	weeny
weep	9	51	3165	2	weep
weer	7	55	3509	2	weer
wees	7	62	4912	2	wees
weet	7	52	5415	2	weet
wen	6	62	4960	2	_wen
wheen	11	50	1605	2	wheen
when	10	57	2304	2	when
wren	7	82	2168	2	wren
yean	7	58	3458	2	yean
yen	6	68	4738	2	_yen
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees
zein	13	56	2060	2	zein

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.283	631417.0
2	DLD Change Limit	29872	354	0.843	35435.3
3	Display Results	354	354	0.093	3806.5
	(SQL Overall)	178691	354	1.219	146588.2