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

Here are the results of your fuzzy-string dictionary search for “prosos” 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
prosos	8	57	1855	(None)
promos	10	51	1642	1	promos
proses	8	47	3347	1	proses
proso	7	72	2241	1	proso_
pross	7	65	2940	1	pros_s
apropos	11	3	884	2	apropos
ariosos	7	40	985	2	ariosos
bromos	10	42	1331	2	bromos
broos	7	51	2641	2	bro_os
broses	8	65	2440	2	broses
cross	7	51	2450	2	cros_s
dross	6	54	1809	2	dros_s
eroses	6	53	2705	2	eroses
frosts	9	42	1462	2	frosts
gross	6	54	2169	2	gros_s
irokos	10	3	723	2	irokos
parodos	10	30	1175	2	parodos
pesos	7	72	2162	2	p_esos
phonos	11	41	1479	2	phonos
photos	11	33	1663	2	photos
pisos	7	60	2106	2	p_isos
polos	7	61	2991	2	p_olos
pomos	9	53	2158	2	p_omos
poos	6	59	4911	2	p_o_os
pornos	8	50	1525	2	pornos
poses	7	46	4276	2	p_oses
posts	7	52	2878	2	p_osts
praos	7	49	2356	2	pr_aos
prases	8	44	2902	2	prases
press	7	54	2595	2	pres_s
prestos	9	37	1607	2	prestos
prests	8	40	2126	2	prests
primos	10	45	1442	2	primos
prises	8	41	3317	2	prises
prisms	10	49	1550	2	prisms
prison	8	5	1402	2	prison
prisons	9	3	1322	2	prisons
priss	7	46	2389	2	pris_s
proas	7	50	2880	2	pro_as
probes	10	41	1945	2	probes
prods	8	55	2355	2	pro_ds
proems	10	47	1116	2	proems
profs	10	51	2089	2	pro_fs
progs	8	66	2415	2	pro_gs
proles	8	46	2720	2	proles
prolog	9	42	1297	2	prolog
prologs	10	35	1213	2	prologs
promo	9	56	1999	2	promo_
proms	9	54	2640	2	pro_ms
prongs	9	43	1448	2	prongs
proof	10	52	2153	2	pro_of
proofs	11	45	1168	2	proofs
propose	11	27	1484	2	propose
props	9	57	2688	2	pro_ps
pros	6	57	4278	2	pr__os
prose	7	58	3512	2	pros_e
prosed	9	49	2109	2	prosed
proser	8	42	2346	2	proser
prosers	9	42	1964	2	prosers
prosit	8	51	2459	2	prosit
prosody	13	3	643	2	prosody
prosoma	11	3	1022	2	prosoma
prosomas	12	4	972	2	prosomas
prosses	9	40	1951	2	prosses
prost	7	54	3410	2	pros_t
prosy	10	63	1925	2	pros_y
proton	8	43	1889	2	proton
protons	9	31	1800	2	protons
proves	11	43	2225	2	proves
provisos	13	3	691	2	provisos
provost	12	3	857	2	provost
prowls	11	55	1108	2	prowls
prows	10	63	2701	2	pro_ws
ptoses	8	35	1467	2	ptoses
ptosis	8	36	1182	2	ptosis
pyoses	11	43	1430	2	pyoses
pyosis	11	40	1212	2	pyosis
pyrosis	12	4	1165	2	pyrosis
roses	5	64	4577	2	_roses
rotos	5	60	2788	2	_rotos
torsos	6	48	1573	2	torsos

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.106	1685764.2
2	DLD Change Limit	82551	81	2.550	32372.9
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	2.686	66526.8