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

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

80 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
campos	12	52	1795	(None)
cameos	10	58	1800	1	cameos
camos	9	59	2761	1	cam_os
campo	11	52	1976	1	campo_
camps	11	63	3026	1	camp_s
campus	12	52	1392	1	campus
capos	9	48	2607	1	ca_pos
compos	12	48	1880	1	compos
ambos	9	53	2125	2	_ambos
ammos	9	48	1582	2	_ammos
amps	8	62	3034	2	_amp_s
apos	6	54	3382	2	_a_pos
cacaos	10	46	1618	2	cacaos
calos	7	44	3190	2	ca_los
camas	9	63	3352	2	cam_as
camass	10	41	1418	2	camass
camels	10	52	1708	2	camels
cameo	9	59	2499	2	cameo_
cames	9	70	4731	2	cam_es
camion	10	39	1719	2	camion
camions	11	39	1613	2	camions
camo	8	57	3175	2	cam_o_
camp	10	63	3645	2	camp__
camped	13	47	2023	2	camped
camper	12	47	2221	2	camper
campers	13	42	2029	2	campers
camphol	16	4	579	2	camphol
camphols	17	4	624	2	camphols
camphor	16	3	613	2	camphor
camphors	17	3	705	2	camphors
campi	11	62	1778	2	camp_i
campion	13	30	1141	2	campion
campions	14	35	1129	2	campions
campong	14	31	812	2	campong
campongs	15	35	612	2	campongs
campout	13	4	1285	2	campout
campouts	14	3	682	2	campouts
campy	14	51	1618	2	camp_y
cams	8	70	4728	2	cam__s
cansos	8	49	1538	2	cansos
cantos	8	48	2697	2	cantos
capes	9	54	4192	2	ca_pes
caphs	12	45	1537	2	ca_phs
capo	8	58	2921	2	ca_po_
capon	9	52	2187	2	ca_pon
capons	10	41	1950	2	ca_pons
caps	8	71	4789	2	ca_p_s
carbos	10	51	2226	2	carbos
cargos	9	46	1918	2	cargos
carps	9	69	3225	2	carp_s
carpus	10	55	1430	2	carpus
champs	15	49	1568	2	champ_s
clamps	12	45	1508	2	clamp_s
combos	12	53	1661	2	combos
compas	12	58	1706	2	compas
compo	11	53	1857	2	compo_
compose	13	57	1666	2	compose
compost	13	45	1535	2	compost
comps	11	55	2605	2	comp_s
compts	12	52	1665	2	compts
crambos	13	3	678	2	crambos
crampon	13	3	694	2	crampon
crampons	14	3	664	2	crampons
cramps	12	56	1556	2	cramp_s
damps	10	52	2041	2	damp_s
gamps	10	53	2371	2	gamp_s
lampas	10	66	1595	2	lampas
lamps	9	56	2483	2	lamp_s
mambos	12	54	1449	2	mambos
pampas	12	49	1399	2	pampas
ramps	9	62	2463	2	ramp_s
sambos	10	43	1519	2	sambos
samps	9	61	2467	2	samp_s
scamps	12	50	1417	2	scamp_s
tampon	10	29	1123	2	tampon
tampons	11	27	1156	2	tampons
tamps	9	55	2408	2	tamp_s
tempos	10	38	1229	2	tempos
vamps	12	54	1548	2	vamp_s
wampus	13	49	901	2	wampus

Search took 4 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	82551	0.346	516448.0
2	DLD Change Limit	82551	80	2.640	31269.3
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.016	59247.7