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

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

359 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
port	6	60	5963	(None)
aport	7	54	3217	1	aport
bort	6	59	6096	1	bort
fort	7	64	5644	1	fort
mort	6	67	5883	1	mort
ort	3	94	6523	1	_ort
part	6	59	6746	1	part
pert	6	67	5932	1	pert
poet	6	55	5290	1	poet
pore	6	64	5126	1	pore
pork	10	69	2968	1	pork
porn	6	56	3602	1	porn
ports	7	59	3459	1	ports
post	6	79	5336	1	post
pot	5	80	7843	1	po_t
pout	6	57	5255	1	pout
sort	4	62	6481	1	sort
sport	7	59	3598	1	sport
tort	4	69	6746	1	tort
wort	7	66	5475	1	wort
abort	7	61	3358	2	abort
airt	4	57	5779	2	airt
amort	7	58	3220	2	amort
aorta	5	59	2257	2	aorta
apart	7	43	3067	2	apart
art	3	86	7914	2	_art
boart	7	88	3593	2	boart
boat	6	63	6031	2	boat
bolt	6	62	5417	2	bolt
boot	6	77	5937	2	boot
bora	6	61	4163	2	bora
bore	6	60	5133	2	bore
bork	10	69	3382	2	bork
born	6	73	3841	2	born
borts	7	67	3545	2	borts
borty	10	55	2283	2	borty
bortz	16	57	2220	2	bortz
bot	5	96	8040	2	bo_t
bott	6	65	4857	2	bott
bout	6	63	5329	2	bout
cart	6	65	7034	2	cart
coat	6	75	5835	2	coat
coft	9	79	3968	2	coft
colt	6	71	5824	2	colt
coot	6	78	6038	2	coot
cor	5	99	6094	2	cor_
cord	7	67	4092	2	cord
core	6	72	6311	2	core
corf	9	59	4148	2	corf
cork	10	66	3569	2	cork
corm	8	57	3538	2	corm
corn	6	99	4581	2	corn
cors	6	66	5644	2	cors
cory	9	69	4151	2	cory
cost	6	80	5794	2	cost
cot	5	104	8322	2	co_t
court	7	55	3277	2	court
curt	6	70	5171	2	curt
dart	5	58	5787	2	dart
deport	9	49	2239	2	deport
dirt	5	55	5039	2	dirt
doat	5	69	4767	2	doat
doit	5	63	4785	2	doit
dolt	5	66	4942	2	dolt
dor	4	72	5392	2	dor_
dore	5	63	5330	2	dore
dork	9	65	3146	2	dork
dorm	7	68	3463	2	dorm
dorp	7	60	2805	2	dorp
dorr	5	66	2772	2	dorr
dors	5	67	4760	2	dors
dorty	9	62	2081	2	dorty
dory	8	58	3623	2	dory
dost	5	72	4835	2	dost
dot	4	75	7318	2	do_t
export	15	4	1218	2	export
fart	7	68	6056	2	fart
font	7	71	4375	2	font
foot	7	62	4801	2	foot
for	6	69	5207	2	for_
fora	7	59	3739	2	fora
forb	9	71	3133	2	forb
ford	8	68	3549	2	ford
fore	7	83	5147	2	fore
fork	11	59	3094	2	fork
form	9	58	3687	2	form
forte	8	61	3146	2	forte
forth	11	62	2267	2	forth
forts	8	60	3445	2	forts
forty	11	48	2427	2	forty
girt	5	66	4643	2	girt
goat	5	62	5083	2	goat
gor	4	78	4826	2	gor_
gore	5	57	4496	2	gore
gorm	7	55	2939	2	gorm
gorp	7	56	2590	2	gorp
gory	8	61	2966	2	gory
got	4	98	7044	2	go_t
gout	5	66	4600	2	gout
grot	5	59	4205	2	grot
hart	7	68	6577	2	hart
holt	7	78	5258	2	holt
hoot	7	57	5210	2	hoot
hora	7	61	3656	2	hora
horn	7	67	3561	2	horn
horst	8	58	3351	2	horst
host	7	78	5283	2	host
hot	6	77	7606	2	ho_t
hurt	7	71	4257	2	hurt
import	10	27	1376	2	import
jolt	11	66	3912	2	jolt
jot	10	82	5902	2	jo_t
kart	8	67	5082	2	kart
kor	7	65	3890	2	kor_
kora	8	64	3157	2	kora
korat	9	49	3444	2	korat
kore	8	58	3417	2	kore
kors	8	59	3302	2	kors
loft	7	65	3914	2	loft
loot	4	69	5582	2	loot
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
lorn	4	64	3525	2	lorn
lory	7	59	3171	2	lory
lost	4	79	5149	2	lost
lot	3	81	7926	2	lo_t
lout	4	59	5214	2	lout
mart	6	68	6598	2	mart
moat	6	63	5203	2	moat
molt	6	63	5616	2	molt
moot	6	76	5362	2	moot
mor	5	68	5500	2	mor_
mora	6	66	4127	2	mora
more	6	71	5452	2	more
morn	6	62	3756	2	morn
mors	6	59	5006	2	mors
morts	7	55	3356	2	morts
most	6	65	5420	2	most
mot	5	72	7942	2	mo_t
mott	6	66	4844	2	mott
nor	3	80	4882	2	nor_
nori	4	71	3314	2	nori
norm	6	64	2981	2	norm
north	8	60	1827	2	north
not	3	94	7466	2	no_t
nowt	7	88	3375	2	nowt
oat	3	98	8826	2	_oat
oft	6	77	4406	2	_oft
oot	3	112	7469	2	_oot
opt	5	75	4554	2	_opt
or	2	73	5473	2	_or_
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
out	3	80	7215	2	_out
pact	8	66	4872	2	pact
pant	6	60	6126	2	pant
par	5	74	6702	2	par_
para	6	52	4218	2	para
pard	7	64	4132	2	pard
pare	6	67	6084	2	pare
park	10	52	3749	2	park
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
parts	7	77	4337	2	parts
party	10	66	3061	2	party
past	6	59	5901	2	past
pat	5	80	8946	2	p_at
peart	7	64	4075	2	peart
peat	6	59	6793	2	peat
pelt	6	76	5108	2	pelt
pent	6	65	5907	2	pent
per	5	63	5309	2	per_
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
perv	9	72	2481	2	perv
pest	6	55	5529	2	pest
pet	5	64	7730	2	p_et
pfft	12	3	1188	2	pfft
phat	9	58	3786	2	phat
phot	9	55	3436	2	phot
pht	8	60	3052	2	p_ht
phut	9	69	2597	2	phut
pint	6	69	6318	2	pint
pirn	6	71	2838	2	pirn
pit	5	64	7193	2	p_it
plat	6	60	4887	2	plat
plot	6	61	4123	2	plot
pock	12	61	2929	2	pock
poco	8	68	2615	2	poco
pod	6	63	5149	2	po_d
pods	7	65	4016	2	pods
poem	8	62	2577	2	poem
poets	7	60	2444	2	poets
pogy	10	56	2355	2	pogy
poh	8	67	4053	2	po_h
poi	5	72	4466	2	po_i
point	7	53	3873	2	point
pois	6	65	3904	2	pois
poke	10	53	3536	2	poke
poky	13	59	2215	2	poky
pol	5	64	4938	2	po_l
pole	6	59	5130	2	pole
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
pom	7	82	4991	2	po_m
pome	8	56	3669	2	pome
pomo	8	58	2845	2	pomo
pomp	10	62	2546	2	pomp
poms	8	70	3774	2	poms
pond	7	55	3049	2	pond
pone	6	57	4753	2	pone
pong	7	62	3114	2	pong
pons	6	58	5060	2	pons
pony	9	64	3405	2	pony
poo	5	77	5711	2	po_o
pood	7	59	3432	2	pood
poof	9	55	4166	2	poof
pooh	9	60	2738	2	pooh
pool	6	58	3595	2	pool
poon	6	73	4126	2	poon
poop	8	65	3281	2	poop
poor	6	56	3022	2	poor
poori	7	48	1623	2	poori
poos	6	59	4911	2	poos
pop	7	62	5225	2	po_p
pope	8	55	3561	2	pope
pops	8	63	4095	2	pops
porch	12	59	1862	2	porch
pored	8	52	3451	2	pored
pores	7	58	4903	2	pores
porgy	11	69	1612	2	porgy
porks	11	51	2414	2	porks
porky	14	50	1933	2	porky
porno	7	51	2065	2	porno
porns	7	55	2734	2	porns
porny	10	60	2019	2	porny
portal	8	42	1846	2	portal
ported	9	42	2324	2	ported
porter	8	42	2441	2	porter
portly	11	47	1340	2	portly
pose	6	64	4173	2	pose
posh	9	54	2732	2	posh
posit	7	58	3333	2	posit
posts	7	52	2878	2	posts
posy	9	60	2842	2	posy
pots	6	64	5236	2	pots
potto	7	53	2094	2	potto
potty	10	56	2100	2	potty
pouf	9	57	3264	2	pouf
poult	7	69	2887	2	poult
pour	6	115	2747	2	pour
pours	7	46	2318	2	pours
pouts	7	55	3032	2	pouts
pouty	10	70	1881	2	pouty
pow	8	71	4728	2	po_w
pows	9	55	3766	2	pows
pox	12	61	4069	2	po_x
poxy	16	68	2089	2	poxy
prat	6	59	5204	2	prat
pro	5	58	3726	2	p_ro
proa	6	62	2996	2	proa
prod	7	61	2950	2	prod
prof	9	61	3466	2	prof
prog	7	57	2900	2	prog
prom	8	76	3170	2	prom
prop	8	59	3281	2	prop
pros	6	57	4278	2	pros
prost	7	54	3410	2	prost
prow	9	70	3038	2	prow
pry	8	57	2805	2	p_ry
psst	6	61	1840	2	psst
pst	5	79	3251	2	p_st
punt	6	57	4720	2	punt
pur	5	68	4055	2	pur_
pure	6	55	4333	2	pure
puri	6	59	3144	2	puri
purl	6	56	3142	2	purl
purr	6	49	2581	2	purr
purs	6	56	4104	2	purs
purty	10	50	1940	2	purty
put	5	57	5907	2	p_ut
putt	6	69	3784	2	putt
pyre	9	49	2555	2	pyre
pyro	9	60	1939	2	pyro
report	8	53	2602	2	report
root	4	56	5592	2	root
rot	3	72	8295	2	ro_t
rout	4	61	5328	2	rout
short	8	50	4053	2	short
skort	9	49	2564	2	skort
snort	5	48	3375	2	snort
soft	7	69	4282	2	soft
soot	4	57	6106	2	soot
sora	4	57	4691	2	sora
sorb	6	83	3304	2	sorb
sord	5	62	3720	2	sord
sore	4	70	5953	2	sore
sori	4	60	3984	2	sori
sorn	4	66	4106	2	sorn
sorta	5	71	2541	2	sorta
sorts	5	45	3666	2	sorts
sot	3	103	8430	2	so_t
spirt	7	50	3295	2	spirt
spore	7	54	2859	2	spore
sports	8	46	1918	2	sports
sporty	11	51	1249	2	sporty
spot	6	55	4069	2	spo_t
spout	7	50	2963	2	spout
spurt	7	72	2798	2	spurt
tart	4	75	6618	2	tart
toft	7	74	4165	2	toft
toit	4	63	5306	2	toit
toot	4	59	5888	2	toot
tor	3	92	6168	2	tor_
tora	4	75	4599	2	tora
torc	6	63	3335	2	torc
tore	4	73	5932	2	tore
tori	4	75	4215	2	tori
torn	4	60	4425	2	torn
toro	4	80	4568	2	toro
torot	5	61	3994	2	torot
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
torta	5	59	2535	2	torta
torte	5	54	3170	2	torte
torts	5	61	3812	2	torts
tory	7	58	4054	2	tory
tost	4	83	5192	2	tost
tot	3	88	8477	2	to_t
tout	4	67	5382	2	tout
trot	4	63	5131	2	trot
vert	7	72	4937	2	vert
volt	7	64	3953	2	volt
wart	7	78	6608	2	wart
wert	7	97	4982	2	wert
whort	11	46	2369	2	whort
wont	7	58	4250	2	wont
word	8	98	3200	2	word
wore	7	71	4467	2	wore
work	11	55	2884	2	work
worm	9	61	2949	2	worm
worn	7	56	3175	2	worn
worst	8	63	3013	2	worst
worth	11	71	2052	2	worth
worts	8	86	3118	2	worts
wost	7	65	4436	2	wost
wot	6	104	6748	2	wo_t
yore	7	63	3594	2	yore
yurt	7	64	3504	2	yurt
zori	13	77	2292	2	zori

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.296	603685.8
2	DLD Change Limit	29872	359	0.873	34217.6
3	Display Results	359	359	0.093	3860.2
	(SQL Overall)	178691	359	1.262	141593.5