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

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

58 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
outglitters	12	7	139	(None)
outglitter	11	8	199	1	outglitter_
outfitters	13	4	275	2	out_fitters
outglittered	14	5	76	2	outglittered
glitters	9	37	1054	3	___glitters
outfitter	12	4	391	3	out_fitter_
outglittering	15	5	103	3	outglittering
outliers	8	26	1067	3	out_li__ers
outliners	9	22	836	3	out_li_ners
outlivers	12	24	615	3	out_li_vers
aglitter	9	3	509	4	__aglitter_
antilitter	10	4	533	4	antilitter_
flitters	11	43	1217	4	___flitters
futilities	13	4	886	4	futilitie_s
glisters	9	39	1260	4	___glisters
glitter	8	42	1180	4	___glitter_
glittery	12	37	561	4	___glittery
gritters	9	42	1063	4	___gritters
litters	7	34	2256	4	____litters
omitters	10	27	765	4	o___mitters
oubliettes	12	4	289	4	ou_bliette_s
outbidders	14	4	205	4	out_bidders
outcities	11	4	950	4	out_citie_s
outdelivers	15	5	176	4	outdeli_vers
outfitted	13	4	519	4	out_fitte_d
outflies	11	3	1014	4	outfli__e_s
outgives	12	21	862	4	outg_i_ve_s
outglares	10	4	700	4	outgl_are_s
outguides	11	4	541	4	outgui_de_s
outlanders	11	4	427	4	out_landers
outlier	7	22	1614	4	out_li__er_
outlies	7	24	2199	4	out_li__e_s
outliner	8	24	1210	4	out_li_ner_
outlines	8	24	1809	4	out_li_ne_s
outliver	11	26	878	4	out_li_ver_
outlives	11	25	1176	4	out_li_ve_s
outmasters	12	4	573	4	out_masters
outpities	11	4	862	4	out_pitie_s
outplotted	13	4	319	4	outplotte_d
outriders	10	23	722	4	out_ri_ders
outriggers	12	4	295	4	out_riggers
outsiders	10	23	665	4	out_si_ders
outsteers	9	3	603	4	out__steers
outwitted	13	4	513	4	out_witte_d
outwrites	12	3	823	4	outwri_te_s
outwritten	13	4	271	4	outwritte_n
quitters	17	23	852	4	qu___itters
slitters	8	40	1413	4	___slitters
splitters	11	30	732	4	__splitters
submitters	14	4	443	4	su_bmitters
titters	7	42	1961	4	__t__itters
twitters	11	29	677	4	__t_witters
uglifiers	13	4	309	4	_u_glifiers
unclutters	12	4	200	4	_unclutters
uplifters	14	6	328	4	_u_plifters
utilisers	9	5	354	4	_utili_sers
utilities	9	6	1080	4	_utilitie_s
utilizers	18	5	454	4	_utili_zers

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	148819	0.156	1145455.1
2	DLD Change Limit	148819	58	9.266	16060.8
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	9.452	18905.1