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

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

81 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
scarves	12	45	1162	(None)
carves	11	51	2845	1	_carves
scares	8	50	3300	1	scar_es
starves	10	46	1455	1	starves
calves	11	51	1928	2	_calves
cares	7	73	6918	2	_car_es
caries	8	51	4762	2	_caries
carles	8	54	3508	2	_carles
carses	8	52	3365	2	_carses
cartes	8	62	3947	2	_cartes
carve	10	62	2775	2	_carve_
carved	12	43	2085	2	_carved
carvel	11	48	1757	2	_carvel
carvels	12	49	1459	2	_carvels
carven	11	47	1666	2	_carven
carver	11	44	2015	2	_carver
carvers	12	48	1754	2	_carvers
caves	10	56	3970	2	_ca_ves
corves	11	51	2252	2	_corves
craves	11	58	2539	2	_craves
curves	11	46	1928	2	_curves
dwarves	14	3	446	2	dwarves
ecartes	9	42	1256	2	ecartes
salves	9	42	2176	2	s_alves
sarees	6	53	2994	2	s_arees
sarges	7	51	2859	2	s_arges
saves	8	58	3863	2	s_a_ves
scabies	11	6	1333	2	scabies
scales	8	45	2931	2	sca_les
scapes	10	51	2226	2	sca_pes
scarabs	11	3	729	2	scarabs
scarce	10	40	1363	2	scarce_
scarcer	11	39	1137	2	scarcer
scarcest	12	16	917	2	scarcest
scare	7	53	3446	2	scar_e_
scared	9	52	2729	2	scar_ed
scarer	8	45	2461	2	scar_er
scarers	9	46	1851	2	scarers
scarey	11	50	1698	2	scar_ey
scarfed	13	47	1118	2	scarfed
scarfer	12	45	1108	2	scarfer
scarfers	13	40	846	2	scarfers
scarfs	11	47	1468	2	scar_fs
scarier	9	40	1787	2	scarier
scariest	10	16	1595	2	scariest
scarless	10	18	905	2	scarless
scarlet	9	15	1694	2	scarlet
scarlets	10	17	857	2	scarlets
scarped	12	43	1440	2	scarped
scarper	11	48	1482	2	scarper
scarpers	12	47	1251	2	scarpers
scarphs	14	43	741	2	scarphs
scarps	10	47	1860	2	scar_ps
scarred	10	45	1263	2	scarred
scars	7	54	3353	2	scar__s
scarted	10	48	1612	2	scarted
scarts	8	53	2149	2	scar_ts
scathes	12	45	1571	2	scathes
scores	8	47	2592	2	scor_es
scrapes	11	62	1766	2	scrapes
screes	8	50	2397	2	sc_rees
scries	8	52	2682	2	sc_ries
scrives	12	44	1427	2	scrives
scurvies	13	24	812	2	scurvies
serves	9	44	2365	2	s_erves
shares	9	52	3641	2	shar_es
shaves	12	52	2493	2	sha_ves
slaves	9	50	2302	2	sla_ves
snares	6	53	2903	2	snar_es
soaves	9	42	1867	2	soa_ves
spares	8	48	3455	2	spar_es
sparges	10	40	1634	2	sparges
stares	6	60	3875	2	star_es
starve	9	46	1374	2	starve_
starved	11	49	1157	2	starved
starver	10	46	1199	2	starver
starvers	11	45	964	2	starvers
staves	9	45	2519	2	sta_ves
swerves	13	7	753	2	swerves
varves	12	44	1478	2	_varves
wharves	16	45	714	2	wharves

Search took 7 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	107671	1.280	139602.3
2	DLD Change Limit	107671	81	5.140	20947.7
3	Display Results	81	81	0.016	5062.5
	(SQL Overall)	178691	81	6.436	27764.3