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

Here are the results of your fuzzy-string dictionary search for “partons” 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
partons	9	46	2051	(None)
cartons	9	41	2247	1	cartons
pardons	10	38	1762	1	pardons
parsons	9	35	1687	1	parsons
partans	9	44	1828	1	partans
parton	8	47	2099	1	parton_
patrons	9	38	1810	1	patrons
aprons	8	3	1699	2	apr_ons
argons	7	50	1820	2	_argons
arsons	6	39	1721	2	_arsons
barons	8	50	2538	2	bar_ons
baryons	12	10	1047	2	baryons
barytons	13	4	557	2	barytons
batons	8	55	1942	2	ba_tons
burtons	9	3	1085	2	burtons
cantons	9	52	2120	2	cantons
carbons	11	54	1894	2	carbons
cardons	10	45	1994	2	cardons
carton	8	45	2266	2	carton_
cartoons	10	40	1280	2	cartoons
cratons	9	43	1603	2	cratons
daltons	8	3	1040	2	daltons
garcons	10	24	1164	2	garcons
garrons	8	27	1346	2	garrons
jargons	15	5	820	2	jargons
lardons	8	39	1449	2	lardons
maroons	9	26	1555	2	maroons
marrons	9	32	1697	2	marrons
martens	9	37	1495	2	martens
martins	9	33	2206	2	martins
matrons	9	35	1763	2	matrons
natrons	7	32	1566	2	natrons
pactions	12	26	1350	2	pactions
paeons	8	39	1552	2	pa_eons
pantos	8	52	2274	2	panto_s
paragons	11	3	1150	2	paragons
pardon	9	46	1873	2	pardon_
pareos	8	70	2377	2	pareo_s
pargos	9	57	1904	2	pargo_s
parians	9	35	1973	2	parians
parlors	9	3	1291	2	parlors
parlous	9	4	1429	2	parlous
parols	8	47	2261	2	par_ols
parous	8	40	2416	2	par_ous
parrots	9	3	1274	2	parrots
parson	8	38	1790	2	parson_
partan	8	38	2056	2	partan_
parties	9	32	3086	2	parties
parting	10	35	2738	2	parting
partings	11	35	1373	2	partings
partook	13	3	731	2	partook
parts	7	77	4337	2	part__s
parvos	11	66	1475	2	parvo_s
pastors	9	41	1900	2	pastors
patens	8	48	2086	2	pa_tens
patins	8	75	2878	2	pa_tins
patois	8	43	1936	2	pa_tois
patrols	9	35	1351	2	patrols
patron	8	40	1804	2	patron_
patroons	10	27	1060	2	patroons
pattens	9	54	1492	2	pattens
pereons	9	28	1500	2	pereons
perrons	9	31	1548	2	perrons
persons	9	37	1701	2	persons
phaetons	13	4	585	2	phaetons
photons	12	38	1443	2	photons
phytons	15	31	906	2	phytons
pistons	9	30	1637	2	pistons
pitons	8	53	1904	2	p_itons
plutons	9	3	834	2	plutons
pontons	9	33	1555	2	pontons
portions	10	5	1441	2	portions
prions	8	43	1778	2	p_rions
protons	9	31	1800	2	protons
putons	8	35	1515	2	p_utons
rattons	7	38	1532	2	rattons
sartors	7	3	1497	2	sartors
tarpons	9	26	1221	2	tarpons
tartans	7	26	1582	2	tartans
wantons	10	37	1301	2	wantons

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	107671	0.376	475242.0
2	DLD Change Limit	107671	80	3.390	31761.4
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.796	47073.5