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

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

342 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
pert	6	67	5932	(None)
part	6	59	6746	1	part
peart	7	64	4075	1	peart
peat	6	59	6793	1	peat
pelt	6	76	5108	1	pelt
pent	6	65	5907	1	pent
per	5	63	5309	1	per_
pere	6	64	5026	1	pere
peri	6	56	3697	1	peri
perk	10	62	3284	1	perk
perm	8	58	3463	1	perm
perp	8	90	2989	1	perp
perv	9	72	2481	1	perv
pest	6	55	5529	1	pest
pet	5	64	7730	1	pe_t
port	6	60	5963	1	port
vert	7	72	4937	1	vert
wert	7	97	4982	1	wert
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
airt	4	57	5778	2	airt
alert	5	47	4065	2	alert
apart	7	43	3067	2	apart
aper	6	63	3623	2	aper_
apers	7	66	2913	2	apers
apery	10	65	1790	2	apery
aport	7	54	3217	2	aport
art	3	86	7914	2	_art
avert	8	60	2949	2	avert
beat	6	61	6830	2	beat
beet	6	64	5754	2	beet
belt	6	57	5403	2	belt
bent	6	77	5991	2	bent
beret	7	49	4636	2	beret
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
berth	10	49	1788	2	berth
best	6	63	5532	2	best
bet	5	83	7667	2	be_t
bort	6	59	6096	2	bort
cart	6	65	7034	2	cart
celt	6	56	4671	2	celt
cent	6	74	5101	2	cent
cere	6	67	4147	2	cere
cero	6	63	2945	2	cero
chert	10	52	3210	2	chert
curt	6	70	5171	2	curt
dart	5	58	5787	2	dart
debt	7	71	3902	2	debt
deet	5	73	5658	2	deet
deft	8	55	4022	2	deft
delt	5	78	5527	2	delt
dent	5	71	5841	2	dent
derat	6	50	4408	2	derat
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
dirt	5	55	5038	2	dirt
eat	3	69	8905	2	_eat
eery	7	61	2962	2	eery
eft	6	60	3882	2	_eft
er	2	83	4514	2	_er_
era	3	57	4150	2	_era
ere	3	63	5277	2	_ere
erg	4	55	3107	2	_erg
ern	3	57	3836	2	_ern
err	3	56	2653	2	_err
ers	3	60	4628	2	_ers
erst	4	74	3643	2	_erst
et	2	69	6419	2	_e_t
evert	8	49	2951	2	evert
exert	12	46	2414	2	exert
expert	15	5	1535	2	expert
fart	7	68	6056	2	fart
feat	7	64	5822	2	feat
feet	7	53	5221	2	feet
felt	7	51	4693	2	felt
fer	6	66	4612	2	fer_
fere	7	63	4223	2	fere
fern	7	61	2932	2	fern
fest	7	49	4944	2	fest
fet	6	64	7163	2	fe_t
fort	7	64	5644	2	fort
fret	7	58	4504	2	fret
gelt	5	64	4801	2	gelt
gent	5	69	5439	2	gent
germ	7	54	2896	2	germ
gest	5	61	4913	2	gest
get	4	74	6746	2	ge_t
girt	5	66	4642	2	girt
hart	7	68	6577	2	hart
heart	8	54	4074	2	heart
heat	7	70	6142	2	heat
heft	10	67	3629	2	heft
hent	7	66	5638	2	hent
her	6	65	4781	2	her_
herb	9	47	3096	2	herb
herd	8	49	3306	2	herd
here	7	64	4710	2	here
herl	7	58	3455	2	herl
herm	9	56	3615	2	herm
hern	7	61	3489	2	hern
hero	7	46	3578	2	hero
hers	7	58	4487	2	hers
hertz	17	49	1904	2	hertz
hest	7	59	5077	2	hest
het	6	76	7431	2	he_t
hurt	7	71	4257	2	hurt
inert	5	32	3437	2	inert
jerk	15	49	2013	2	jerk
jest	11	67	3850	2	jest
jet	10	67	5482	2	je_t
kart	8	67	5080	2	kart
keet	8	53	4734	2	keet
kelt	8	53	4319	2	kelt
kent	8	68	4696	2	kent
kept	10	62	3294	2	kept
kerb	10	43	2271	2	kerb
kerf	11	58	2746	2	kerf
kern	8	53	2621	2	kern
leet	4	59	5790	2	leet
left	7	63	4048	2	left
lent	4	63	6053	2	lent
lept	6	64	4088	2	lept
lest	4	69	5632	2	lest
let	3	64	8147	2	le_t
mart	6	68	6598	2	mart
meat	6	63	5960	2	meat
meet	6	53	5055	2	meet
melt	6	57	5289	2	melt
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merit	7	3	3918	2	merit
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
met	5	60	7243	2	me_t
mort	6	67	5883	2	mort
neat	4	63	5678	2	neat
nerd	5	66	2494	2	nerd
nerts	5	59	2498	2	nerts
nertz	14	51	1745	2	nertz
nest	4	55	4873	2	nest
net	3	66	7029	2	ne_t
nett	4	66	4323	2	nett
newt	7	69	3374	2	newt
next	11	66	3108	2	next
opera	7	3	1357	2	opera
ort	3	94	6523	2	_ort
overt	8	56	3072	2	overt
pact	8	66	4872	2	pact
pant	6	60	6126	2	pant
par	5	74	6702	2	par_
para	6	52	4217	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
pe	4	76	4903	2	pe__
pea	5	66	5724	2	pe_a
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peas	6	57	5506	2	peas
peats	7	61	4019	2	peats
peaty	10	57	2569	2	peaty
pec	7	67	4441	2	pe_c
pech	11	61	2545	2	pech
peck	12	57	3068	2	peck
pecs	8	46	3410	2	pecs
ped	6	67	5152	2	pe_d
pedro	8	3	1315	2	pedro
peds	7	58	3524	2	peds
pee	5	60	6651	2	pe_e
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
peers	7	51	3027	2	peers
peery	10	57	1944	2	peery
pees	6	52	5737	2	pees
peg	6	58	4306	2	pe_g
pegs	7	55	3176	2	pegs
peh	8	67	4096	2	pe_h
pehs	9	56	2576	2	pehs
pein	6	58	3494	2	pein
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelts	7	61	2881	2	pelts
pen	5	65	5884	2	pe_n
pend	7	59	3453	2	pend
pens	6	56	4964	2	pens
peon	6	56	3524	2	peon
pep	7	64	4708	2	pe_p
pepo	8	76	2215	2	pepo
peps	8	51	3451	2	peps
perch	12	45	1883	2	perch
perdu	8	42	1627	2	perdu
perdy	11	54	1733	2	perdy
perea	7	50	2644	2	perea
peres	7	62	4664	2	peres
peril	7	54	2595	2	peril
peris	7	55	3707	2	peris
periti	8	3	1995	2	periti
perks	11	53	2580	2	perks
perky	14	53	1948	2	perky
permit	10	3	2168	2	permit
perms	9	55	2451	2	perms
perps	9	55	2148	2	perps
perry	10	52	2271	2	perry
perse	7	54	2952	2	perse
perter	8	44	2228	2	perter
pertly	11	53	1255	2	pertly
pervs	10	51	1737	2	pervs
pes	5	72	5978	2	pe_s
peso	6	69	2582	2	peso
pesto	7	57	2372	2	pesto
pests	7	59	3327	2	pests
pesty	10	64	2171	2	pesty
petit	7	43	3265	2	petit
pets	6	62	4833	2	pets
petti	7	51	1945	2	petti
petto	7	60	2104	2	petto
petty	10	53	2029	2	petty
pew	8	64	4230	2	pe_w
pewit	10	46	2279	2	pewit
pews	9	57	3153	2	pews
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
pier	6	60	3529	2	pier_
piers	7	59	2633	2	piers
pint	6	69	6317	2	pint
pirn	6	71	2837	2	pirn
pit	5	64	7192	2	p_it
plat	6	60	4887	2	plat
pleat	7	47	3447	2	pleat
plot	6	61	4123	2	plot
poet	6	55	5290	2	poet
pore	6	64	5126	2	pore
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
ports	7	59	3459	2	ports
post	6	79	5336	2	post
pot	5	80	7843	2	p_ot
pout	6	57	5255	2	pout
prat	6	59	5204	2	prat
pree	6	70	4473	2	pree
prep	8	64	2767	2	prep
prest	7	57	3635	2	prest
prex	13	57	2297	2	prex
prey	9	62	2848	2	prey
prez	15	61	2631	2	prez
pro	5	58	3726	2	p_ro
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
reft	7	51	4127	2	reft
rent	4	66	6124	2	rent
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
ser	3	67	5240	2	ser_
sera	4	61	4139	2	sera
sere	4	61	5347	2	sere
serf	7	63	4011	2	serf
sers	4	57	4665	2	sers
set	3	66	8125	2	se_t
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
sort	4	62	6481	2	sort
spelt	7	54	3019	2	spelt
spent	7	55	3283	2	spent
sperm	9	32	1602	2	sperm
spirt	7	50	3295	2	spirt
sport	7	59	3598	2	sport
spurt	7	72	2798	2	spurt
tart	4	75	6618	2	tart
teat	4	59	6363	2	teat
tent	4	61	5986	2	tent
term	6	62	3315	2	term
tern	4	61	3480	2	tern
test	4	86	5162	2	test
tet	3	92	7499	2	te_t
text	11	60	3393	2	text
tort	4	69	6746	2	tort
tret	4	66	5353	2	tret
vent	7	60	4905	2	vent
vera	7	68	2884	2	vera
verb	9	62	2487	2	verb
verst	8	44	2937	2	verst
verts	8	57	2473	2	verts
vertu	8	50	1761	2	vertu
very	10	80	2564	2	very
vest	7	57	4360	2	vest
vet	6	59	5852	2	ve_t
vext	14	69	2776	2	vext
wart	7	78	6608	2	wart
weet	7	52	5415	2	weet
weft	10	54	3501	2	weft
welt	7	55	4786	2	welt
went	7	60	5187	2	went
wept	9	56	3505	2	wept
were	7	62	3833	2	were
west	7	57	4808	2	west
wet	6	59	6662	2	we_t
wort	7	66	5475	2	wort
yerk	11	62	2208	2	yerk
yet	6	69	6069	2	ye_t
yett	7	64	3449	2	yett
yurt	7	64	3504	2	yurt
zerk	17	53	1925	2	zerk
zero	13	48	2247	2	zero
zest	13	60	3570	2	zest

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.313	570897.8
2	DLD Change Limit	29872	342	0.860	34734.9
3	Display Results	342	342	0.076	4500.0
	(SQL Overall)	178691	342	1.249	143067.3