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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
capons	10	41	1950	(None)
canons	8	55	2206	1	canons
capon	9	52	2187	1	capon_
capos	9	48	2607	1	capo_s
yapons	11	44	1177	1	yapons
aeons	5	76	2465	2	_aeons
agons	6	64	2378	2	_agons
apods	8	63	1634	2	_apods
apos	6	54	3382	2	_apo_s
aprons	8	3	1699	2	_aprons
axons	12	55	1793	2	_axons
azons	14	65	1825	2	_azons
bacons	10	49	1758	2	bacons
barons	8	50	2538	2	barons
batons	8	55	1942	2	batons
cabins	10	44	1891	2	cabins
cabobs	12	43	1188	2	cabobs
cahows	14	39	912	2	cahows
cains	7	53	3430	2	ca_ins
cairns	8	53	1330	2	cairns
cajon	14	45	1390	2	cajon_
cajones	16	33	1133	2	cajones
calos	7	44	3190	2	calo_s
camions	11	39	1613	2	camions
camos	9	59	2761	2	camo_s
campions	14	35	1129	2	campions
campong	14	31	812	2	campong
campongs	15	35	612	2	campongs
campos	12	52	1795	2	campo_s
cannons	9	44	1288	2	cannons
canoes	8	47	2588	2	canoes
canon	7	47	2530	2	canon_
cans	6	50	5084	2	ca__ns
cantons	9	52	2120	2	cantons
canyons	12	45	1159	2	canyons
capers	10	54	2813	2	capers
capes	9	54	4192	2	cap_es
caphs	12	45	1537	2	cap_hs
capias	10	3	1835	2	capias
caplins	11	35	1599	2	caplins
capo	8	58	2921	2	capo__
capote	10	3	1573	2	capote
capotes	11	3	1464	2	capotes
capris	10	4	1507	2	capris
caps	8	71	4789	2	cap__s
captans	11	16	1205	2	captans
captions	12	38	1321	2	captions
captors	11	39	1498	2	captors
carbons	11	54	1894	2	carbons
cardons	10	45	1993	2	cardons
carns	7	59	3756	2	ca_rns
carobs	10	48	1810	2	carobs
carols	8	51	2498	2	carols
caroms	10	56	1957	2	caroms
cartons	9	41	2247	2	cartons
cations	9	45	2414	2	cations
cions	7	52	2285	2	c_ions
claxons	16	3	580	2	claxons
clons	7	52	2813	2	c_lons
codons	9	61	1946	2	codons
cogons	9	68	1811	2	cogons
colons	8	60	2868	2	colons
cons	6	60	5769	2	c__ons
coons	7	67	3728	2	c_oons
copens	10	61	1996	2	copens
coupons	11	27	1055	2	coupons
crampons	14	3	664	2	crampons
cratons	9	43	1603	2	cratons
crayons	12	43	923	2	crayons
crepons	11	3	931	2	crepons
croons	8	54	1842	2	croons
cytons	11	17	1018	2	cytons
fanons	9	61	1521	2	fanons
gipons	9	38	960	2	gipons
halons	9	57	2071	2	halons
japans	15	3	982	2	japans
jupons	15	37	780	2	jupons
kaons	9	50	1485	2	ka_ons
kapoks	11	34	726	2	kapoks
lapins	8	45	2068	2	lapins
macons	10	40	1724	2	macons
masons	8	39	1651	2	masons
paeons	8	39	1552	2	paeons
pons	6	58	5060	2	__pons
racons	8	43	1934	2	racons
radons	7	41	1852	2	radons
rayons	9	41	1334	2	rayons
salons	6	38	2368	2	salons
sapors	8	41	1881	2	sapors
talons	6	40	1942	2	talons
tampons	11	27	1155	2	tampons
tarpons	9	26	1220	2	tarpons
tauons	6	34	1267	2	tauons
taxons	13	42	1150	2	taxons
vapors	11	38	1269	2	vapors
wagons	10	39	1121	2	wagons
weapons	12	27	860	2	weapons
yapoks	15	34	678	2	yapoks
yapon	10	46	1358	2	yapon_
yaupons	12	34	568	2	yaupons
yupons	11	39	835	2	yupons

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.140	1276364.3
2	DLD Change Limit	82551	101	2.936	28116.8
3	Display Results	101	101	0.033	3060.6
	(SQL Overall)	178691	101	3.109	57475.4