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

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

297 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
opt	5	75	4554	(None)
apt	5	73	5254	1	apt
oat	3	98	8826	1	oat
oft	6	77	4406	1	oft
oot	3	112	7469	1	oot
op	4	58	5016	1	op_
ope	5	68	4524	1	ope
ops	5	66	4125	1	ops
opts	6	81	2474	1	opts
ort	3	94	6523	1	ort
out	3	80	7215	1	out
pot	5	80	7843	1	pot
act	5	95	5784	2	act
adopt	8	12	1974	2	adopt
aft	6	68	4901	2	aft
ait	3	80	9391	2	ait
alt	3	64	6796	2	alt
ant	3	72	7079	2	ant
ape	5	72	5118	2	ape
apo	5	111	4212	2	apo
app	7	68	2760	2	app
art	3	86	7914	2	art
at	2	123	9340	2	_at
att	3	54	5465	2	att
bat	5	109	8895	2	bat
bet	5	83	7667	2	bet
bit	5	70	7091	2	bit
boat	6	63	6031	2	boat
bolt	6	62	5417	2	bolt
boot	6	77	5937	2	boot
bop	7	75	4948	2	bop_
bops	8	60	3798	2	bops
bort	6	59	6096	2	bort
bot	5	96	8040	2	bot
bott	6	65	4857	2	bott
bout	6	63	5329	2	bout
but	5	59	6302	2	but
cat	5	82	8234	2	cat
coapt	9	61	3153	2	coapt
coat	6	75	5835	2	coat
coft	9	79	3968	2	coft
colt	6	71	5824	2	colt
compt	11	63	2822	2	compt
coopt	9	59	2985	2	coopt
coot	6	78	6038	2	coot
cop	7	111	6237	2	cop_
cope	8	68	4738	2	cope
cops	8	67	5137	2	cops
copy	11	62	2980	2	copy
cost	6	80	5794	2	cost
cot	5	104	8322	2	cot
cut	5	79	5766	2	cut
dipt	7	73	3933	2	dipt
dit	4	70	7134	2	dit
doat	5	69	4767	2	doat
doit	5	63	4785	2	doit
dolt	5	66	4942	2	dolt
dopa	7	72	2090	2	dopa
dope	7	60	3889	2	dope
dopy	10	62	2415	2	dopy
dost	5	72	4835	2	dost
dot	4	75	7318	2	dot
dropt	8	69	2443	2	dropt
eat	3	69	8905	2	eat
eft	6	60	3882	2	eft
et	2	69	6419	2	_et
fat	6	81	7808	2	fat
fet	6	64	7163	2	fet
fit	6	63	6546	2	fit
font	7	71	4375	2	font
foot	7	62	4801	2	foot
fop	8	67	4370	2	fop_
fops	9	65	3268	2	fops
fort	7	64	5644	2	fort
gat	4	68	8051	2	gat
get	4	74	6746	2	get
git	4	62	6606	2	git
goat	5	62	5083	2	goat
got	4	98	7044	2	got
gout	5	66	4600	2	gout
gut	4	67	5385	2	gut
hat	6	72	8996	2	hat
het	6	76	7431	2	het
hit	6	65	6920	2	hit
holt	7	78	5258	2	holt
hoot	7	57	5210	2	hoot
hop	8	75	5459	2	hop_
hope	9	66	3967	2	hope
hops	9	79	4263	2	hops
host	7	78	5283	2	host
hot	6	77	7606	2	hot
hut	6	64	5729	2	hut
it	2	84	5569	2	_it
jet	10	67	5482	2	jet
jolt	11	66	3912	2	jolt
jot	10	82	5902	2	jot
jut	10	59	4401	2	jut
kat	7	74	6830	2	kat
kept	10	62	3295	2	kept
kit	7	85	5989	2	kit
kop	9	74	4021	2	kop_
koph	13	58	1655	2	koph
kops	10	70	3130	2	kops
lat	3	75	9340	2	lat
lept	6	64	4088	2	lept
let	3	64	8147	2	let
lit	3	93	7732	2	lit
loft	7	65	3914	2	loft
loot	4	69	5582	2	loot
lop	5	82	5531	2	lop_
lope	6	59	4192	2	lope
lops	6	60	4335	2	lops
lost	4	79	5149	2	lost
lot	3	81	7926	2	lot
lout	4	59	5214	2	lout
mat	5	80	8394	2	mat
met	5	60	7243	2	met
moat	6	63	5203	2	moat
molt	6	63	5616	2	molt
moot	6	76	5362	2	moot
mop	7	69	5082	2	mop_
mope	8	68	3804	2	mope
mops	8	59	4013	2	mops
mopy	11	57	2197	2	mopy
mort	6	67	5883	2	mort
most	6	65	5420	2	most
mot	5	72	7942	2	mot
mott	6	66	4844	2	mott
mut	5	83	5718	2	mut
net	3	66	7029	2	net
nit	3	70	6595	2	nit
nope	6	59	3419	2	nope
not	3	94	7466	2	not
nowt	7	88	3375	2	nowt
nut	3	66	5196	2	nut
oaf	6	59	5288	2	oaf
oak	7	62	3865	2	oak
oar	3	70	5795	2	oar
oast	4	71	5632	2	oast
oath	7	61	3215	2	oath
oats	4	65	5421	2	oats
oba	5	75	3155	2	oba
obe	5	66	3864	2	obe
obi	5	71	2773	2	obi
obit	6	68	3708	2	obit
oca	5	67	3173	2	oca
od	3	92	5525	2	o_d
oda	4	81	3305	2	oda
odd	5	77	2546	2	odd
ode	4	74	4659	2	ode
ods	4	75	4622	2	ods
oe	2	84	7306	2	o_e
oes	3	58	6619	2	oes
of	5	82	4777	2	o_f
off	9	63	3163	2	off
oh	5	74	4700	2	o_h
ohm	8	65	2301	2	ohm
oho	6	65	3438	2	oho
ohs	6	62	3231	2	ohs
oi	2	90	6149	2	o_i
oil	3	74	5206	2	oil
oka	7	69	2680	2	oka
oke	7	58	3948	2	oke
old	4	70	3347	2	old
ole	3	71	5521	2	ole
om	4	85	5300	2	o_m
omit	6	53	3737	2	omit
oms	5	63	3751	2	oms
on	2	80	5718	2	o_n
one	3	70	5091	2	one
ono	3	68	3803	2	ono
ons	3	61	4851	2	ons
onto	4	61	2766	2	onto
ooh	6	76	3709	2	ooh
oops	6	52	3267	2	oops
oots	4	64	4644	2	oots
opah	9	62	1840	2	opah
opal	6	69	2352	2	opal
oped	7	62	3015	2	oped
open	6	64	2700	2	open
opes	6	59	4261	2	opes
opted	8	49	1427	2	opted
optic	9	37	1518	2	optic
opus	6	64	2059	2	opus
or	2	73	5473	2	o_r
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ore	3	66	6183	2	ore
ors	3	57	5011	2	ors
orts	4	65	3833	2	orts
os	2	113	5988	2	o_s
ose	3	81	4734	2	ose
otto	4	52	2064	2	otto
oud	4	74	3908	2	oud
ouph	9	56	1837	2	ouph
our	3	60	4289	2	our
oust	4	67	4744	2	oust
outs	4	57	4696	2	outs
ova	6	68	2379	2	ova
ow	5	89	5017	2	o_w
owe	6	70	4103	2	owe
owl	6	62	2897	2	owl
own	6	64	2970	2	own
ox	9	82	4238	2	o_x
oxo	10	73	2296	2	oxo
oxy	13	63	2098	2	oxy
oy	5	89	5013	2	o_y
pa	4	104	5648	2	_pa
pat	5	80	8946	2	pat
pe	4	76	4903	2	_pe
pet	5	64	7730	2	pet
pht	8	60	3052	2	pht
pi	4	81	4537	2	_pi
pit	5	64	7193	2	pit
pod	6	63	5149	2	pod
poet	6	55	5290	2	poet
poh	8	67	4053	2	poh
poi	5	72	4466	2	poi
pol	5	64	4938	2	pol
pom	7	82	4991	2	pom
poo	5	77	5711	2	poo
pop	7	62	5225	2	pop
pope	8	55	3561	2	pope
pops	8	63	4095	2	pops
port	6	60	5963	2	port
post	6	79	5336	2	post
pots	6	64	5236	2	pots
pout	6	57	5255	2	pout
pow	8	71	4728	2	pow
pox	12	61	4069	2	pox
pst	5	79	3251	2	pst
put	5	57	5907	2	put
qat	12	52	5333	2	qat
qoph	18	59	1194	2	qoph
rapt	6	72	4531	2	rapt
rat	3	78	9274	2	rat
ret	3	59	8283	2	ret
root	4	56	5592	2	root
rope	6	55	4291	2	rope
ropy	9	63	2341	2	ropy
rot	3	72	8295	2	rot
rout	4	61	5328	2	rout
rut	3	55	6052	2	rut
sat	3	62	8848	2	sat
sept	6	58	4436	2	sept
set	3	66	8125	2	set
sit	3	58	7776	2	sit
soft	7	69	4282	2	soft
soot	4	57	6106	2	soot
sop	5	75	5786	2	sop_
soph	9	70	2420	2	soph
sops	6	52	4456	2	sops
sort	4	62	6481	2	sort
sot	3	103	8430	2	sot
spa	5	57	3081	2	spa
spat	6	65	4852	2	spat
spit	6	55	4508	2	spit
spot	6	55	4069	2	spot
spy	8	60	2374	2	spy
stopt	7	65	2835	2	stopt
tat	3	76	9029	2	tat
tet	3	92	7499	2	tet
tit	3	67	7106	2	tit
toft	7	74	4165	2	toft
toit	4	63	5306	2	toit
toot	4	59	5888	2	toot
top	5	105	6068	2	top_
tope	6	59	4638	2	tope
toph	9	63	2687	2	toph
topi	6	78	3039	2	topi
topo	6	69	3240	2	topo
tops	6	62	4812	2	tops
tort	4	69	6746	2	tort
tost	4	83	5192	2	tost
tot	3	88	8477	2	tot
tout	4	67	5382	2	tout
tut	3	67	5809	2	tut
up	4	78	3282	2	up_
upo	5	89	2586	2	upo
ups	5	56	2905	2	ups
ut	2	86	4703	2	_ut
vat	6	78	6345	2	vat
vet	6	59	5852	2	vet
volt	7	64	3953	2	volt
wat	6	73	7892	2	wat
wept	9	56	3505	2	wept
wet	6	59	6662	2	wet
wit	6	65	6378	2	wit
wont	7	58	4250	2	wont
wop	8	71	4513	2	wop_
wops	9	66	3415	2	wops
wort	7	66	5475	2	wort
wost	7	65	4436	2	wost
wot	6	104	6748	2	wot
yet	6	69	6069	2	yet
zit	12	60	5000	2	zit

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	14084	0.283	631417.0
2	DLD Change Limit	14084	297	0.453	31090.5
3	Display Results	297	297	0.063	4714.3
	(SQL Overall)	178691	297	0.799	223643.3