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

Here are the results of your fuzzy-string dictionary search for “recto” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

72 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
recto	7	45	2080	(None)
recta	7	42	2026	1	recta
recti	7	36	1962	1	recti
rector	8	40	1975	1	rector
rectos	8	57	1878	1	rectos
bento	7	59	2295	2	bento
cento	7	66	2517	2	cento
deco	7	61	2597	2	dec_o
echo	9	66	1595	2	_echo
erect	7	41	2933	2	erect_
erector	9	35	1381	2	erector
erects	8	41	1618	2	erects
gecko	12	45	1111	2	gecko
hector	11	33	1265	2	hector
keto	8	62	2346	2	ke_to
lector	8	35	1499	2	lector
lento	5	72	2339	2	lento
pesto	7	57	2372	2	pesto
petto	7	60	2104	2	petto
presto	8	42	1620	2	presto
rato	4	54	3697	2	r_ato
react	7	46	3433	2	react_
reactor	9	30	1166	2	reactor
reacts	8	36	1660	2	reacts
reata	5	42	2539	2	reata
rebato	8	37	1468	2	rebato
rec	5	56	4546	2	rec__
recap	9	57	1802	2	recap
recce	9	5	1456	2	recce
recit	7	52	3510	2	recit
recite	8	36	2511	2	recite
recits	8	36	2135	2	recits
reck	10	61	3056	2	rec_k
reckon	12	30	1054	2	reckon
recks	11	56	2513	2	recks
recon	7	56	2424	2	recon
recook	12	55	1392	2	recook
recs	6	57	3418	2	rec_s
rectal	8	44	1814	2	rectal
rectors	9	35	2052	2	rectors
rectory	12	35	1273	2	rectory
rectum	10	34	1128	2	rectum
rectus	8	33	1463	2	rectus
recur	7	41	1684	2	recur
recut	7	47	2924	2	recut
recuts	8	38	1737	2	recuts
redo	5	60	2937	2	re_do
redtop	9	3	797	2	redtop
reecho	11	31	865	2	reecho
reft	7	51	4127	2	reft_
rent	4	66	6124	2	rent_
rente	5	47	3378	2	rente
rents	5	59	3518	2	rents
repo	6	60	2754	2	re_po
repot	7	51	3262	2	repot
repro	7	53	1591	2	repro
rest	4	64	5984	2	rest_
rests	5	49	3587	2	rests
ret	3	59	8283	2	re_t_
retch	10	48	1830	2	retch
rete	4	49	4413	2	re_te
retro	5	50	2095	2	retro
rets	4	53	5256	2	re_ts
roto	4	59	3505	2	r_oto
secco	9	3	1242	2	secco
sect	6	74	4362	2	sect_
sector	8	34	1593	2	sector
sects	7	56	2289	2	sects
sexto	12	44	1545	2	sexto
tecta	7	42	1552	2	tecta
vector	11	32	1206	2	vector
veto	7	66	2299	2	ve_to

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	53800	0.346	516448.0
2	DLD Change Limit	53800	72	1.450	37103.4
3	Display Results	72	72	0.016	4500.0
	(SQL Overall)	178691	72	1.812	98615.3