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

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

100 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
delve	9	60	1826	(None)
deave	9	50	2233	1	deave
dele	5	68	4308	1	del_e
delved	11	41	1275	1	delved
delver	10	49	1349	1	delver
delves	10	49	1708	1	delves
helve	11	50	1809	1	helve
belie	7	56	3038	2	belie
belive	11	54	1530	2	belive
belle	7	58	2783	2	belle
calve	10	59	1992	2	calve
dale	5	56	4398	2	dal_e
deaved	11	49	1655	2	deaved
deaves	10	53	1953	2	deaves
debye	11	3	890	2	debye
dee	4	76	6582	2	de__e
deice	8	43	2003	2	deice
deke	9	52	2876	2	de_ke
del	4	67	5275	2	del__
delate	7	38	2775	2	delate
delay	9	48	2063	2	delay
deleave	11	4	772	2	deleave
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delete	7	36	2070	2	delete
delf	8	54	3657	2	del_f
delfs	9	49	1867	2	delfs
delft	9	56	2332	2	delft
deli	5	56	3129	2	del_i
delime	9	3	1404	2	delime
delis	6	49	2854	2	delis
deliver	11	33	1224	2	deliver
dell	5	69	3820	2	del_l
dells	6	66	3094	2	dells
delly	9	60	2387	2	delly
dels	5	67	4547	2	del_s
delt	5	78	5527	2	del_t
delta	6	61	1777	2	delta
delts	6	57	3179	2	delts
delude	8	19	1067	2	delude
deluge	8	18	940	2	deluge
deluxe	14	19	730	2	deluxe
delvers	11	34	1199	2	delvers
deme	7	65	3628	2	de_me
dene	5	66	4341	2	de_ne
dense	6	59	2350	2	dense
dere	5	68	4590	2	de_re
derive	10	38	1704	2	derive
deuce	8	45	1749	2	deuce
dev	7	60	3377	2	de_v_
deva	8	57	2098	2	de_va
devel	9	42	1712	2	de_vel
devolve	14	31	606	2	devolve
devs	8	64	2403	2	de_vs
dexie	13	47	1689	2	dexie
dive	8	56	3477	2	d_ive
dolce	8	58	1668	2	dolce
dole	5	65	5000	2	dol_e
dove	8	51	3156	2	d_ove
drave	9	52	1927	2	drave
drive	9	53	1800	2	drive
drove	9	55	1806	2	drove
dulse	6	54	1504	2	dulse
eave	7	57	3358	2	_eave
else	4	59	2308	2	_else
elver	8	52	1624	2	_elver
elves	8	51	1874	2	_elves
eve	6	63	3116	2	_e_ve
gelee	6	36	2698	2	gelee
halve	11	48	1892	2	halve
heave	11	45	2181	2	heave
helved	13	43	1370	2	helved
helves	12	43	1606	2	helves
keeve	12	45	1213	2	keeve
leave	8	47	2372	2	leave
melee	7	37	2910	2	melee
nerve	8	66	1737	2	nerve
neve	7	62	2483	2	ne_ve
peeve	10	49	1525	2	peeve
pele	6	55	3955	2	pel_e
pelves	11	45	1466	2	pelves
reave	8	45	2802	2	reave
reeve	8	41	2132	2	reeve
reive	8	55	2294	2	reive
releve	9	51	1640	2	releve
relive	9	51	2078	2	relive
salve	8	50	2213	2	salve
selle	5	44	2831	2	selle
selva	8	30	1427	2	selva
selves	9	41	1961	2	selves
serve	8	54	2596	2	serve
shelve	12	40	1276	2	shelve
solve	8	56	1894	2	solve
telae	5	43	2329	2	telae
tele	4	50	4087	2	tel_e
twelve	12	3	416	2	twelve
valve	11	45	1593	2	valve
velvet	12	36	1375	2	velvet
verve	11	54	1772	2	verve
weave	11	52	1853	2	weave

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.313	570897.8
2	DLD Change Limit	53800	100	1.626	33087.3
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	1.969	90752.2