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

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

54 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
gloater	8	37	1101	(None)
bloater	9	40	1342	1	bloater
floater	10	44	1335	1	floater
gloated	9	35	1153	1	gloated
gloaters	9	28	885	1	gloaters
bleater	9	45	1530	2	bleater
bloated	10	45	1343	2	bloated
bloaters	10	33	1101	2	bloaters
blotter	9	46	1285	2	blotter
boater	8	46	2209	2	_boater
clouter	9	35	1168	2	clouter
coater	8	43	2955	2	_coater
elater	6	47	2420	2	el_ater
floated	11	33	1270	2	floated
floatel	10	30	801	2	floatel
floaters	11	27	1150	2	floaters
floatier	11	3	698	2	floatier
flouter	10	43	1134	2	flouter
gater	6	45	3364	2	g__ater
glazer	16	42	1226	2	gl_azer
gleamer	10	32	851	2	gleamer
gleaner	8	37	977	2	gleaner
glister	8	40	1334	2	glister
glitter	8	42	1180	2	glitter
gloat	6	54	2768	2	gloat__
gloats	7	45	1542	2	gloat_s
globate	10	5	782	2	globate_
globated	12	6	575	2	globated
glosser	8	34	1081	2	glosser
glouted	9	42	971	2	glouted
glover	10	45	1353	2	glo_ver
glower	10	51	1493	2	glo_wer
goatee	7	32	1953	2	g_oatee
goiter	7	41	1620	2	g_oiter
grater	7	46	2543	2	g_rater
greater	8	44	1649	2	greater
groaner	8	25	1013	2	groaner
grouter	8	44	1252	2	grouter
later	5	48	4392	2	_l_ater
loader	7	43	1630	2	_loader
loafer	9	36	1094	2	_loafer
loaner	6	44	1650	2	_loaner
loather	10	37	1100	2	_loather
locater	9	31	1360	2	_locater
lofter	9	46	1472	2	_lofter
loiter	6	46	1917	2	_loiter
looter	6	42	2232	2	_looter
lotter	6	40	2560	2	_lotter
oater	5	54	3373	2	__oater
plater	8	44	2769	2	pl_ater
pleater	9	39	1633	2	pleater
plotter	9	41	1366	2	plotter
slater	6	44	2918	2	sl_ater
slotter	7	33	1444	2	slotter

Search took 5 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.123	1452772.4
2	DLD Change Limit	107671	54	4.016	26810.5
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	4.169	42861.8