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

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

72 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
frasses	10	43	1451	(None)
brasses	9	38	1835	1	brasses
fraises	10	42	1569	1	fraises
grasses	8	41	1734	1	grasses
trasses	7	48	1932	1	trasses
wrasses	10	38	1259	1	wrasses
amasses	9	39	1285	2	amasses
asses	5	56	2928	2	__asses
basses	8	54	2830	2	_basses
biasses	9	49	1165	2	biasses
braises	9	38	1887	2	braises
brashes	12	45	1846	2	brashes
brassed	10	36	1237	2	brassed
brassies	10	36	1353	2	brassies
brisses	9	43	1431	2	brisses
chasses	12	40	1750	2	chasses
classes	9	47	1794	2	classes
crases	8	55	3231	2	cra_ses
crashes	12	46	1840	2	crashes
crasser	9	41	1433	2	crasser
crassest	10	34	1152	2	crassest
cresses	9	42	1981	2	cresses
crosses	9	42	2079	2	crosses
dresses	8	37	1617	2	dresses
drosses	8	45	1382	2	drosses
erases	6	44	2540	2	era_ses
eyasses	10	38	802	2	eyasses
fasces	11	49	1454	2	f_asces
fashes	12	45	2402	2	f_ashes
feases	9	54	2292	2	fea_ses
fesses	9	48	2025	2	f_esses
flashes	13	39	1610	2	flashes
flosses	10	34	1197	2	flosses
fosses	9	60	2208	2	f_osses
fracases	13	3	699	2	fracases
fraise	9	42	1491	2	fraise_
frames	11	51	1986	2	fra_mes
frappes	14	32	838	2	frappes
frass	8	53	2112	2	fra_s_s
freshes	13	35	1582	2	freshes
frisees	10	44	1169	2	frisees
frises	9	41	2427	2	fr_ises
fusses	9	49	2055	2	f_usses
gasses	7	57	2478	2	_gasses
glasses	8	44	1427	2	glasses
grassed	9	38	1279	2	grassed
grosses	8	45	1768	2	grosses
harasses	11	3	1103	2	harasses
kvasses	14	36	550	2	kvasses
lasses	6	48	2759	2	_lasses
masses	8	50	2871	2	_masses
morasses	10	3	890	2	morasses
passes	8	60	3047	2	_passes
praises	9	41	2110	2	praises
prases	8	44	2902	2	pra_ses
presses	9	35	2315	2	presses
prisses	9	48	1671	2	prisses
prosses	9	40	1951	2	prosses
quasses	16	20	950	2	quasses
raises	6	48	2654	2	_raises
rases	5	54	4721	2	_ra_ses
rashes	9	53	3015	2	_rashes
rassles	7	35	1392	2	_rassles
sasses	6	41	2439	2	_sasses
strasses	8	13	1144	2	strasses
tasses	6	48	2676	2	_tasses
trashes	10	41	1926	2	trashes
tresses	7	37	1954	2	tresses
trusses	7	38	1364	2	trusses
urases	6	37	2356	2	ura_ses
wrasse	9	39	877	2	wrasse_
wrassles	11	37	671	2	wrassles

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.140	1276364.3
2	DLD Change Limit	107671	72	3.296	32667.2
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	3.469	51510.8