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

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

98 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
platen	8	45	1820	(None)
laten	5	43	2834	1	_laten
paten	7	48	2734	1	p_aten
platan	8	39	1369	1	platan
plate	7	46	3511	1	plate_
plated	9	52	2577	1	plated
platens	9	42	1398	1	platens
plater	8	44	2769	1	plater
plates	8	54	3224	1	plates
alate	5	53	4032	2	alate_
alated	7	56	2514	2	alated
alates	6	48	3396	2	alates
beaten	8	46	1706	2	beaten
blate	7	59	3378	2	blate_
eaten	5	53	2305	2	_eaten
elate	5	53	3588	2	elate_
elated	7	47	2582	2	elated
elater	6	47	2420	2	elater
elates	6	50	3236	2	elates
flamen	11	52	1599	2	flamen
flatten	10	42	965	2	flatten
flaxen	16	51	857	2	flaxen
gluten	7	42	1075	2	gluten
laden	6	50	2219	2	_laden
late	4	75	6048	2	_late_
lated	6	52	4067	2	_lated
lateen	6	40	1486	2	_lateen
latens	6	46	2021	2	_latens
latent	6	41	2430	2	_latent
later	5	48	4392	2	_later
latex	12	47	1711	2	_latex
latten	6	50	1820	2	_latten
neaten	6	42	1454	2	neaten
oaten	5	52	2240	2	_oaten
palate	8	42	2678	2	palate_
palates	9	36	2493	2	palates
palter	8	44	2326	2	palter
pate	6	53	5046	2	p_ate_
pated	8	52	3784	2	p_ated
patens	8	48	2086	2	p_atens
patent	8	45	2492	2	p_atent
pater	7	47	4072	2	p_ater
pates	7	60	4789	2	p_ates
patin	7	68	3285	2	p_atin
patten	8	44	1819	2	patten
peahen	11	34	1013	2	peahen
peasen	8	48	1596	2	peasen
pecten	10	27	1110	2	pecten
place	9	48	2461	2	place_
placed	11	43	1800	2	placed
placer	10	51	1774	2	placer
places	10	43	2370	2	places
placet	10	39	2367	2	placet
plage	8	45	2040	2	plage_
plages	9	45	2015	2	plages
plain	7	48	2330	2	pla_in
plaited	10	37	1389	2	plaited
plaiter	9	36	1539	2	plaiter
plan	6	58	3394	2	pla__n
plane	7	49	2914	2	plane_
planed	9	44	2091	2	planed
planer	8	41	2265	2	planer
planes	8	50	2808	2	planes
planet	8	42	2835	2	planet
planted	10	35	1612	2	planted
planter	9	40	1780	2	planter
plaster	9	33	1869	2	plaster
plat	6	60	4887	2	plat__
platane	9	31	1230	2	platane
platans	9	34	1312	2	platans
plateau	9	3	740	2	plateau
platers	9	39	2409	2	platers
platier	9	37	1629	2	platier
platies	9	37	2254	2	platies
platina	9	44	1364	2	platina
plating	10	38	2307	2	plating
platoon	9	3	895	2	platoon
plats	7	55	3137	2	plat_s
platted	10	36	1426	2	platted
platter	9	39	1741	2	platter
platy	10	50	2166	2	plat_y
platys	11	45	985	2	platys
played	12	48	1503	2	played
player	11	52	1521	2	player
playpen	14	3	469	2	playpen
pleated	10	38	1663	2	pleated
pleater	9	39	1633	2	pleater
plutei	8	40	890	2	plutei
pluton	8	3	885	2	pluton
prate	7	51	3598	2	prate_
prated	9	49	2492	2	prated
prater	8	48	2535	2	prater
prates	8	46	3316	2	prates
slate	5	54	3828	2	slate_
slated	7	50	2831	2	slated
slater	6	44	2918	2	slater
slates	6	49	3406	2	slates
slatey	9	54	1706	2	slatey

Search took 3 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.110	1624463.6
2	DLD Change Limit	82551	98	2.186	37763.5
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	2.326	76823.3