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

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

92 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
renew	8	39	1751	(None)
renews	9	38	1175	1	renews
resew	8	45	1950	1	resew
anew	7	66	2313	2	_anew
arene	5	53	2941	2	arene_
arenes	6	49	2839	2	arenes
bedew	11	45	1304	2	bedew
bene	6	64	3949	2	bene_
benes	7	55	3623	2	benes
crenel	8	42	1306	2	crenel
dene	5	66	4341	2	dene_
denes	6	56	3972	2	denes
enow	7	78	1987	2	_enow
erenow	9	3	737	2	erenow
erne	4	67	2743	2	erne_
ernes	5	52	2481	2	ernes
gene	5	62	3722	2	gene_
genes	6	51	3309	2	genes
genet	6	60	3868	2	genet
knew	11	59	1212	2	_knew
lenes	5	47	3852	2	lenes
nene	4	59	3206	2	nene_
nenes	5	53	2967	2	nenes
new	6	62	3709	2	__new
penes	7	58	3922	2	penes
ranee	5	54	3810	2	ranee
rebec	9	44	1654	2	rebec
rebel	7	34	2129	2	rebel
rechew	14	3	1021	2	rechew
rede	5	50	3767	2	rede_
reded	7	48	2912	2	reded
redes	6	51	3913	2	redes
redrew	10	30	951	2	redrew
ree	3	79	7407	2	re_e_
reed	5	55	4962	2	re_ed
reef	7	49	3821	2	re_ef
reek	8	52	3252	2	re_ek
reel	4	52	4053	2	re_el
rees	4	53	6419	2	re_es
refed	9	39	2192	2	refed
refel	8	49	2081	2	refel
refer	8	48	2214	2	refer
reflew	12	38	945	2	reflew
reges	6	56	2879	2	reges
regrew	10	38	856	2	regrew
rehem	10	38	1535	2	rehem
reined	7	44	2552	2	reined
rekey	12	40	1473	2	rekey
relet	5	47	4982	2	relet
remet	7	48	4372	2	remet
remex	14	63	1579	2	remex
renal	5	59	2950	2	renal
rend	5	61	3657	2	ren_d
rended	8	45	2410	2	rended
render	7	40	2414	2	render
rends	6	51	2995	2	rends
renege	7	27	1376	2	renege
renest	6	45	2971	2	renest
renewal	10	3	870	2	renewal
renewed	11	30	999	2	renewed
renewer	10	24	869	2	renewer
renig	6	45	1891	2	renig
renin	5	48	3003	2	renin
rennet	6	46	2485	2	rennet
renown	9	36	998	2	renown
rent	4	66	6124	2	ren_t
rente	5	47	3378	2	rente
rented	7	44	2659	2	rented
renter	6	45	2741	2	renter
rentes	6	54	3119	2	rentes
rents	5	59	3518	2	rents
repeg	8	40	1505	2	repeg
repel	7	49	2140	2	repel
resaw	8	41	1725	2	resaw
resee	5	43	3633	2	resee
reset	5	50	5186	2	reset
resewn	9	45	981	2	resewn
resews	9	48	1417	2	resews
resow	8	82	1724	2	resow
rete	4	49	4413	2	rete_
retem	7	42	2195	2	retem
revel	8	44	2316	2	revel
revet	8	49	3884	2	revet
review	12	3	869	2	review
rewed	9	54	2545	2	rewed
rewet	8	51	3515	2	rewet
rexes	12	45	2695	2	rexes
rune	4	52	3630	2	rune_
runes	5	55	3022	2	runes
sene	4	68	4805	2	sene_
sinew	8	47	1892	2	sinew
tenet	5	55	4221	2	tenet

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	53800	0.313	570897.8
2	DLD Change Limit	53800	92	1.720	31279.1
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	2.063	86617.1