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

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

292 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
cent	6	74	5101	(None)
bent	6	77	5991	1	bent
cant	6	63	6202	1	cant
celt	6	56	4671	1	celt
cento	7	66	2517	1	cento
cents	7	47	3033	1	cents
centu	7	61	1941	1	centu
cunt	6	62	4367	1	cunt
dent	5	71	5841	1	dent
gent	5	69	5439	1	gent
hent	7	66	5638	1	hent
kent	8	68	4696	1	kent
lent	4	63	6053	1	lent
pent	6	65	5907	1	pent
rent	4	66	6124	1	rent
scent	7	58	3162	1	scent
sent	4	69	6301	1	sent
tent	4	61	5986	1	tent
vent	7	60	4905	1	vent
went	7	60	5187	1	went
accent	10	51	1626	2	accent
agent	6	58	2964	2	agent
ament	7	60	3654	2	ament
anent	5	49	3184	2	anent
ant	3	72	7078	2	_ant
ascent	8	45	1965	2	ascent
aunt	4	65	5365	2	aunt
beat	6	61	6830	2	beat
beet	6	64	5754	2	beet
belt	6	57	5403	2	belt
ben	5	65	5492	2	ben_
bend	7	64	3526	2	bend
bene	6	64	3949	2	bene
bens	6	59	4570	2	bens
bento	7	59	2295	2	bento
bents	7	60	3369	2	bents
best	6	63	5532	2	best
bet	5	83	7667	2	be_t
bint	6	73	5503	2	bint
blent	7	62	3095	2	blent
brent	7	57	3413	2	brent
bunt	6	58	5085	2	bunt
cadent	9	41	2035	2	cadent
can	5	77	6013	2	can_
cane	6	66	5311	2	cane
cans	6	50	5084	2	cans
canst	7	49	3221	2	canst
canto	7	49	3101	2	canto
cants	7	70	3694	2	cants
canty	10	52	2680	2	canty
cart	6	65	7034	2	cart
cast	6	71	5990	2	cast
cat	5	82	8234	2	c_at
ceca	8	48	2078	2	ceca
cede	7	49	2876	2	cede
cedi	7	49	1927	2	cedi
cee	5	59	5270	2	ce_e
cees	6	59	4159	2	cees
ceil	6	57	2506	2	ceil
cel	5	60	4055	2	ce_l
cell	6	50	3172	2	cell
cels	6	55	3497	2	cels
celts	7	53	2578	2	celts
cement	10	33	2166	2	cement
cenote	8	37	1584	2	cenote
cense	7	51	2140	2	cense
centai	8	48	1478	2	centai
cental	8	44	2096	2	cental
centas	8	50	2070	2	centas
center	8	44	2141	2	center
centos	8	59	2046	2	centos
centra	8	41	1388	2	centra
centre	8	43	1664	2	centre
centum	10	40	1236	2	centum
cep	7	57	3633	2	ce_p
cepe	8	49	2665	2	cepe
ceps	8	61	2595	2	ceps
cere	6	67	4147	2	cere
cero	6	63	2945	2	cero
cess	6	53	2605	2	cess
cesta	7	54	1948	2	cesta
cesti	7	52	1742	2	cesti
cete	6	49	3478	2	cete
chant	10	59	3269	2	chant
chat	9	55	4613	2	chat
cheat	10	57	3245	2	cheat
chert	10	52	3210	2	chert
chest	10	49	2614	2	chest
chit	9	69	3746	2	chit
cine	6	62	4294	2	cine
cist	6	72	4496	2	cist
cleat	7	63	3506	2	cleat
cleft	10	62	2285	2	cleft
clept	9	57	2577	2	clept
client	8	3	1634	2	client
clot	6	65	4242	2	clot
coat	6	75	5834	2	coat
coft	9	79	3968	2	coft
cogent	9	3	2100	2	cogent
colt	6	71	5824	2	colt
con	5	102	6802	2	con_
cone	6	72	5696	2	cone
coni	6	55	3480	2	coni
conk	10	65	3144	2	conk
conn	6	62	2913	2	conn
cons	6	60	5769	2	cons
conte	7	66	3320	2	conte
conto	7	60	2717	2	conto
cony	9	65	3783	2	cony
coot	6	78	6038	2	coot
cost	6	80	5794	2	cost
cot	5	104	8322	2	c_ot
count	7	49	3205	2	count
crept	9	51	2589	2	crept
crest	7	46	3269	2	crest
crit	6	57	4371	2	crit
cult	6	65	4115	2	cult
cunts	7	61	2512	2	cunts
curt	6	70	5171	2	curt
cut	5	79	5766	2	c_ut
cyst	9	63	2281	2	cyst
debt	7	71	3902	2	debt
decent	9	40	2370	2	decent
deet	5	73	5658	2	deet
deft	8	55	4022	2	deft
delt	5	78	5527	2	delt
den	4	75	5434	2	den_
dene	5	66	4341	2	dene
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dents	6	50	3180	2	dents
deny	8	60	2712	2	deny
dint	5	67	5905	2	dint
docent	9	29	1868	2	docent
dunt	5	57	4687	2	dunt
eat	3	69	8905	2	_eat
echt	9	57	2290	2	echt
eft	6	60	3882	2	_eft
en	2	80	5239	2	_en_
end	4	68	3435	2	_end
eng	4	67	2678	2	_eng
ens	3	72	4592	2	_ens
et	2	69	6419	2	_e_t
event	8	59	2444	2	event
feat	7	64	5822	2	feat
feet	7	53	5221	2	feet
feint	8	47	3225	2	feint
felt	7	51	4693	2	felt
fen	6	68	5135	2	fen_
fend	8	48	3297	2	fend
fens	7	61	3976	2	fens
fest	7	49	4944	2	fest
fet	6	64	7163	2	fe_t
font	7	71	4375	2	font
gelt	5	64	4801	2	gelt
gen	4	59	5051	2	gen_
gene	5	62	3722	2	gene
genet	6	60	3868	2	genet
gens	5	57	4007	2	gens
gents	6	57	2961	2	gents
genu	5	59	2907	2	genu
gest	5	61	4913	2	gest
get	4	74	6746	2	ge_t
hant	7	54	6158	2	hant
heat	7	70	6142	2	heat
heft	10	67	3629	2	heft
hen	6	75	5527	2	hen_
hens	7	56	4257	2	hens
hents	8	73	3074	2	hents
hest	7	59	5077	2	hest
het	6	76	7431	2	he_t
hint	7	74	5574	2	hint
hunt	7	64	4549	2	hunt
incent	8	33	2072	2	incent
jest	11	67	3850	2	jest
jet	10	67	5482	2	je_t
keet	8	53	4733	2	keet
kelt	8	53	4319	2	kelt
ken	7	63	4398	2	ken_
keno	8	79	2643	2	keno
kens	8	54	3523	2	kens
kente	9	58	2106	2	kente
kept	10	62	3294	2	kept
leant	5	67	3778	2	leant
leet	4	59	5790	2	leet
left	7	63	4048	2	left
lend	5	62	3367	2	lend
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lento	5	72	2339	2	lento
lept	6	64	4088	2	lept
lest	4	69	5632	2	lest
let	3	64	8147	2	le_t
lint	4	162	6623	2	lint
lucent	8	3	1382	2	lucent
lunt	4	61	4884	2	lunt
meant	7	65	3720	2	meant
meat	6	63	5960	2	meat
meet	6	53	5055	2	meet
melt	6	57	5289	2	melt
men	5	92	5284	2	men_
mend	7	53	3402	2	mend
meno	6	60	3135	2	meno
menta	7	44	2442	2	menta
menu	6	51	3022	2	menu
met	5	60	7243	2	me_t
mint	6	67	5804	2	mint
neat	4	63	5678	2	neat
nene	4	59	3206	2	nene
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
nocent	8	32	1741	2	nocent
pant	6	60	6125	2	pant
peat	6	59	6793	2	peat
pelt	6	76	5108	2	pelt
pen	5	65	5884	2	pen_
pend	7	59	3453	2	pend
pens	6	56	4964	2	pens
pert	6	67	5932	2	pert
pest	6	55	5529	2	pest
pet	5	64	7730	2	pe_t
pint	6	69	6317	2	pint
punt	6	57	4720	2	punt
rant	4	58	6467	2	rant
recent	8	36	3085	2	recent
reft	7	51	4127	2	reft
rend	5	61	3657	2	rend
rente	5	47	3378	2	rente
rents	5	59	3518	2	rents
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
runt	4	66	4798	2	runt
scant	7	97	3507	2	scant
scena	7	48	1578	2	scena
scend	8	55	1629	2	scend
scene	7	72	2057	2	scene
scents	8	53	1702	2	scents
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
sen	3	60	5852	2	sen_
send	5	52	3729	2	send
sene	4	68	4805	2	sene
sente	5	64	3287	2	sente
senti	5	62	2669	2	senti
sept	6	58	4436	2	sept
set	3	66	8125	2	se_t
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
shent	8	59	3349	2	shent
spent	7	55	3283	2	spent
stent	5	56	3451	2	stent
teat	4	59	6363	2	teat
ten	3	58	5611	2	ten_
tend	5	64	3377	2	tend
tenet	5	55	4221	2	tenet
tens	4	56	4741	2	tens
tenth	8	54	2183	2	tenth
tents	5	64	3421	2	tents
tenty	8	61	2160	2	tenty
test	4	86	5162	2	test
tet	3	92	7498	2	te_t
text	11	60	3393	2	text
tint	4	67	5886	2	tint
vena	7	61	2629	2	vena
vend	8	66	2642	2	vend
vents	8	61	2593	2	vents
vert	7	72	4937	2	vert
vest	7	57	4360	2	vest
vet	6	59	5852	2	ve_t
vext	14	69	2776	2	vext
want	7	61	5616	2	want
weet	7	52	5415	2	weet
weft	10	54	3501	2	weft
welt	7	55	4786	2	welt
wen	6	62	4960	2	wen_
wend	8	53	3045	2	wend
wens	7	63	3793	2	wens
wept	9	56	3505	2	wept
wert	7	97	4982	2	wert
west	7	57	4808	2	west
wet	6	59	6662	2	we_t
wont	7	58	4250	2	wont
yen	6	68	4738	2	yen_
yens	7	58	3226	2	yens
yenta	8	39	1704	2	yenta
yente	8	62	2004	2	yente
yet	6	69	6069	2	ye_t
yett	7	64	3449	2	yett
zest	13	60	3570	2	zest

Search took 3 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.186	960704.3
2	DLD Change Limit	29872	292	2.110	14157.3
3	Display Results	292	292	0.140	2085.7
	(SQL Overall)	178691	292	2.436	73354.3