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

Here are the results of your fuzzy-string dictionary search for “glasses” 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
glasses	8	44	1427	(None)
classes	9	47	1794	1	classes
gasses	7	57	2478	1	g_asses
glassed	9	37	1043	1	glassed
glassies	9	40	1227	1	glassies
glosses	8	40	1412	1	glosses
grasses	8	41	1734	1	grasses
lasses	6	48	2759	1	_lasses
amasses	9	39	1285	2	amasses
asses	5	56	2928	2	__asses
basses	8	54	2830	2	_basses
biasses	9	49	1165	2	biasses
blesses	9	38	1239	2	blesses
blisses	9	49	1151	2	blisses
brasses	9	38	1835	2	brasses
chasses	12	40	1750	2	chasses
clashes	12	40	1728	2	clashes
classed	10	41	1365	2	classed
classer	9	36	1461	2	classer
classers	10	41	1183	2	classers
classis	9	37	1272	2	classis
clauses	9	38	1332	2	clauses
elapses	9	5	766	2	elapses
eyasses	10	38	802	2	eyasses
flashes	13	39	1610	2	flashes
flosses	10	34	1197	2	flosses
frasses	10	43	1451	2	frasses
gases	6	56	3399	2	g_a_ses
gashes	10	57	2515	2	g_ashes
gassed	8	52	1763	2	g_assed
gasser	7	50	1777	2	g_asser
gassers	8	47	1463	2	g_assers
gausses	8	30	869	2	gausses
glaces	9	42	1803	2	gla_ces
glacises	11	3	851	2	glacises
glades	8	48	2034	2	gla_des
glaires	8	40	1014	2	glaires
glaives	11	34	783	2	glaives
glances	10	41	1314	2	glances
glandes	9	54	1383	2	glandes
glares	7	55	1887	2	gla_res
glass	6	55	1813	2	gla_s_s
glassie	8	32	949	2	glassie
glassier	9	28	908	2	glassier
glassiest	10	27	925	2	glassiest
glassines	10	27	804	2	glassines
glassless	10	4	387	2	glassless
glassmen	11	4	539	2	glassmen
glassy	10	52	775	2	glass_y
glazes	16	53	1564	2	gla_zes
glossas	8	43	819	2	glossas
glossed	9	44	1007	2	glossed
glosser	8	34	1081	2	glosser
glossers	9	31	905	2	glossers
glossies	9	33	1125	2	glossies
gnashes	11	41	957	2	gnashes
grassed	9	38	1279	2	grassed
grosses	8	45	1768	2	grosses
guesses	8	16	937	2	guesses
kvasses	14	36	550	2	kvasses
lapses	8	52	1769	2	_lapses
lases	5	49	4476	2	_la_ses
lashes	9	48	3100	2	_lashes
lassies	7	44	2010	2	_lassies
lassis	6	52	1670	2	_lassis
lassoes	7	46	1385	2	_lassoes
lassos	6	49	1381	2	_lassos
losses	6	59	2523	2	_losses
masses	8	50	2871	2	_masses
molasses	10	3	723	2	molasses
passes	8	60	3047	2	_passes
plashes	12	44	1739	2	plashes
plisses	9	44	1177	2	plisses
plusses	9	35	1069	2	plusses
quasses	16	20	950	2	quasses
sasses	6	41	2439	2	_sasses
slashes	10	36	1911	2	slashes
tasses	6	48	2676	2	_tasses
trasses	7	48	1932	2	trasses
wrasses	10	38	1259	2	wrasses

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.373	479064.3
2	DLD Change Limit	107671	80	3.360	32044.9
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	3.766	47448.5