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

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

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.

77 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
frissons	11	4	504	(None)
frisson	10	4	531	1	frisson_
caissons	10	3	628	2	caissons
crimsons	12	4	563	2	crimsons
fissions	11	3	803	2	f_issions
foisons	10	4	761	2	foi_sons
grisons	8	3	899	2	gri_sons
orisons	7	3	1056	2	ori_sons
prisons	9	3	1322	2	pri_sons
ariosos	7	40	985	3	arioso_s
aristos	7	3	1237	3	aristo_s
arsons	6	39	1721	3	ar__sons
bisons	8	39	1437	3	_bi_sons
bridoons	11	4	542	3	bridoons
brisses	9	43	1431	3	briss_es
bristols	10	4	677	3	bristols
caisson	9	3	659	3	caisson_
chrismons	16	4	400	3	chrismons
classons	10	3	770	3	classons
crimson	11	3	564	3	crimson_
crispens	12	28	625	3	crispens
derisions	10	3	884	3	derisions
elisions	8	22	1042	3	elisions
emissions	11	4	692	3	emissions
erasions	8	3	1098	3	erasions
erosions	8	3	1034	3	erosions
fission	10	3	873	3	f_ission_
foison	9	4	893	3	foi_son_
frasses	10	43	1451	3	frass_es
frescoes	13	5	783	3	frescoes
frescos	12	3	681	3	fresco_s
freshens	14	29	831	3	freshens
frictions	14	4	803	3	frictions
frisbees	13	29	501	3	frisbees
frisees	10	44	1169	3	fri_sees
frises	9	41	2427	3	fri_s_es
friseurs	11	3	330	3	friseurs
friskers	15	33	737	3	friskers
friskets	15	32	626	3	friskets
frisking	16	26	836	3	frisking
frisks	13	47	926	3	fri_s_ks
frivols	13	3	474	3	fri_vols
frons	8	61	2404	3	fr___ons
frontons	11	3	650	3	frontons
fruitions	12	10	611	3	fruitions
fusions	10	3	915	3	f_usions
gibsons	10	4	504	3	_gibsons
griffons	15	4	257	3	griffons
griseous	9	4	561	3	griseous
griskins	13	3	595	3	griskins
grison	7	3	1010	3	gri_son_
lessons	7	38	1102	3	_lessons
lewissons	12	4	174	3	lewissons
missions	10	3	1190	3	_missions
omissions	11	4	615	3	omissions
orison	6	4	1166	3	ori_son_
pistons	9	30	1637	3	_pistons
poisons	9	3	1035	3	poi_sons
pressors	10	32	1269	3	pressors
prions	8	43	1778	3	pri__ons
prison	8	5	1402	3	pri_son_
prisses	9	48	1671	3	priss_es
prissies	10	17	1200	3	prissies
prissing	11	30	1145	3	prissing
ramsons	9	3	956	3	_ramsons
reasons	7	25	1494	3	_reasons
ribbons	11	3	625	3	_ribbons
rissole	7	3	978	3	_rissole
rissoles	8	3	911	3	_rissoles
scissions	11	4	543	3	scissions
scissors	10	5	435	3	scissors
treasons	8	4	868	3	treasons
trigons	8	43	1209	3	tri_gons
tritons	7	38	1488	3	tri_tons
unisons	7	4	842	3	uni_sons
visions	10	3	1102	3	_visions
warisons	11	3	690	3	wari_sons

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	77	7.123	20519.7
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	7.562	23630.1