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

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

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.

43 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
glossarial	11	5	226	(None)
glossaries	11	4	451	2	glossaries
glossarist	11	5	360	2	glossarist
fossorial	12	4	379	3	_fossorial
glossal	8	44	705	3	gloss___al
glossarists	12	5	235	3	glossarists
glossary	12	4	337	3	glossar__y
bursarial	11	5	400	4	_bursarial
cloistral	11	4	354	4	cloistr_al
gharial	11	3	734	4	g___harial
glacial	10	3	814	4	gl___acial
glissading	13	4	225	4	glissading
gloria	7	19	1055	4	glo___ria_
glorias	8	16	1032	4	glo___rias
glossa	7	52	916	4	gloss___a_
glossae	8	47	728	4	gloss___ae
glossas	8	43	819	4	gloss___as
glossator	10	4	257	4	glossa_tor
glossators	11	5	255	4	glossators
glosser	8	34	1081	4	glosser___
glossers	9	31	905	4	glosser__s
glossier	9	35	820	4	gloss__ier
glossies	9	33	1125	4	gloss__ies
glossily	12	3	509	4	gloss__ily
glossina	9	27	554	4	gloss__ina
glossinas	10	21	414	4	gloss_inas
glossing	10	27	888	4	gloss__ing
glossitic	12	16	343	4	glossiti_c
glossitis	10	14	359	4	glossiti_s
glossolalia	12	13	140	4	glossolalia_
glossolalias	13	12	127	4	glossolalias
gonadial	10	6	682	4	g_o_nadial
loessial	8	4	378	4	_loes_sial
nonserial	9	6	1198	4	_nonserial
notarial	8	4	1075	4	_no_tarial
ovarial	10	3	761	4	__o_varial
postaxial	18	4	530	4	_postaxial
posttrial	11	4	651	4	_posttrial
rosaria	7	4	925	4	_ro_saria_
rosarian	8	4	759	4	_ro_sarian
sponsorial	12	5	340	4	sponsorial
tonsorial	9	11	674	4	_tonsorial
zoarial	16	4	692	4	_zo__arial

Search took 10 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	161450	0.453	394461.4
2	DLD Change Limit	161450	43	9.360	17248.9
3	Display Results	43	43	0.016	2687.5
	(SQL Overall)	178691	43	9.829	18180.0