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

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

74 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
stargazings	22	10	170	(None)
stargazing	21	9	332	1	stargazing_
stagings	10	37	834	3	sta_g__ings
stargazers	20	4	180	3	stargaz_ers
stargazes	19	4	408	3	stargaz__es
starlings	10	23	792	3	star__lings
starvelings	15	4	222	3	starvelings
streakings	15	23	530	3	st_reakings
streamings	13	18	516	3	st_reamings
arcadings	13	5	439	4	__arcadings
atrazines	18	4	668	4	at_r_azines
bargains	11	7	864	4	_barga_in_s
grazings	19	33	726	4	__gr_azings
magazines	21	4	563	4	_ma_gazines
margarines	13	4	720	4	_margarines
margarins	12	4	829	4	_margarin_s
parawings	15	3	582	4	_par_awings
pargetings	14	4	371	4	_pargetings
pargings	12	34	1016	4	_parg__ings
saggaring	12	23	624	4	s_aggaring_
scarlatinas	13	10	212	4	scarlatinas
scrapings	14	25	517	4	s_cr_apings
seafarings	14	4	278	4	sea_farings
sergings	10	29	921	4	s_erg__ings
soarings	9	32	1039	4	soar___ings
sparging	12	26	1113	4	sparg__ing_
sparlings	12	25	715	4	spar__lings
stablings	12	25	610	4	sta__blings
staggering	13	19	458	4	staggering_
stagging	11	33	1051	4	sta_g_ging_
staging	9	38	1837	4	sta_g__ing_
stagnating	12	5	497	4	stagnating_
stalkings	14	31	498	4	sta__lkings
standings	11	25	715	4	sta__ndings
stanging	10	40	1365	4	stang__ing_
starching	15	3	859	4	star_ching_
stargaze	18	4	455	4	stargaz___e
stargazed	20	4	307	4	stargaz__ed
stargazer	19	4	259	4	stargaz__er
staring	8	45	2705	4	star___ing_
starling	9	30	1712	4	star__ling_
starring	9	23	1295	4	star__ring_
starting	9	31	1617	4	star__ting_
startling	10	3	737	4	star_tling_
starvations	14	4	505	4	starvations
starveling	14	4	426	4	starveling_
starving	12	25	1017	4	star__ving_
steadings	11	30	708	4	st__eadings
stealings	10	31	885	4	st__ealings
sterlings	10	30	875	4	ster__lings
stirrings	10	22	469	4	stir__rings
strafing	12	21	1119	4	st_r_afing_
straggling	13	4	430	4	straggling_
strains	7	42	1815	4	st_r_a_in_s
strappings	15	4	335	4	st_rappings
stravaging	15	4	372	4	stravaging_
stravaigs	13	4	272	4	strava_i_gs
strawing	12	24	1162	4	st_r_awing_
straying	12	29	1269	4	st_r_aying_
streaking	14	20	1032	4	st_reaking_
streaming	12	23	965	4	st_reaming_
striating	10	9	1419	4	st_riating_
stringings	12	4	523	4	st_ringings
strings	8	46	1713	4	st_r___ings
stripings	12	21	520	4	st_r_ipings
striplings	13	4	418	4	st_riplings
stroudings	12	4	274	4	st_roudings
surfacings	16	4	245	4	s_urfacings
tagalongs	11	4	223	4	_ta_galongs
targeting	11	3	730	4	_targeting_
taxpayings	23	4	95	4	_taxpayings
tracings	11	29	1041	4	_t_r_acings
triazines	18	4	754	4	_t_riazines
triazins	17	3	835	4	_t_riazin_s

Search took 9 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.423	422437.4
2	DLD Change Limit	148819	74	8.250	18038.7
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	8.703	20532.1