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

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

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
submarining	16	5	358	(None)
summarising	16	5	356	2	summarising
summarizing	25	4	458	2	summarizing
suberising	13	4	742	3	sub_erising
suberizing	22	4	774	3	sub_erizing
subjoining	20	4	385	3	sub_joining
submarine	13	4	784	3	submar__ine
submarined	15	4	450	3	submarin_ed
submariner	14	4	407	3	submarin_er
submariners	15	5	322	3	submariners
submarines	14	4	691	3	submarin_es
submerging	16	4	458	3	submer_ging
submersing	15	4	584	3	submer_sing
suborning	12	4	668	3	sub_or_ning
subscribing	18	5	324	3	subscribing
sustaining	11	4	588	3	susta_ining
barning	10	43	2035	4	__b_ar_ning
braining	11	34	1468	4	__bra_ining
brining	10	32	1647	4	__b__rining
curarizing	22	4	710	4	cu_rarizing
curtaining	13	4	553	4	curta_ining
fulmining	15	5	440	4	fulm__ining
humanising	16	12	497	4	hu_manising
humanizing	25	12	588	4	hu_manizing
imagining	13	4	541	4	__imagining
margining	13	3	760	4	___margining
obtaining	12	3	677	4	_obta_ining
outearning	11	4	674	4	outear_ning
outgaining	12	3	709	4	outga_ining
outmanning	13	4	554	4	outma_nning
outmarching	19	4	360	4	outmarching
reimagining	15	4	266	4	reimagining
remaining	12	22	1279	4	_rema_ining
rubberizing	25	5	304	4	rubberizing
safariing	13	4	455	4	s_afari_ing
saining	8	36	2139	4	s___a_ining
sardining	11	3	757	4	s___ardining
shrining	12	26	1085	4	s___hrining
smartening	13	4	499	4	s__martening
smarting	11	32	1245	4	s__mar_ting
soberizing	22	4	675	4	sob_erizing
solarising	11	4	705	4	s_olarising
solarizing	20	4	828	4	s_olarizing
spraining	12	4	815	4	s_pra_ining
staining	9	4	1337	4	s__ta_ining
straining	10	4	1056	4	s_tra_ining
subceiling	15	4	519	4	sub_ceiling
subdividing	19	5	235	4	subdividing
subediting	14	4	530	4	sub_editing
sublating	12	3	1098	4	subla__ting
subliming	14	4	654	4	sub__liming
submarginal	16	5	215	4	submargin_al
submitting	15	4	497	4	subm_itting
subring	10	41	1626	4	sub__r__ing
subsampling	18	5	163	4	subsampling
subserving	16	4	497	4	subser_ving
subsiding	13	4	634	4	sub__siding
subsidising	15	5	346	4	subsidising
subsidizing	24	5	411	4	subsidizing
subsoiling	13	4	487	4	sub_soiling
subtilizing	23	4	600	4	subtilizing
subtracting	16	4	527	4	subtracting
subvening	15	4	603	4	sub__vening
subverting	16	6	629	4	subver_ting
subwaying	18	4	387	4	subwa__ying
sugaring	10	3	905	4	su_gar__ing
sulfurizing	24	5	337	4	sulfurizing
summating	14	3	794	4	summa__ting
summering	14	5	875	4	summer__ing
summiting	14	4	579	4	su_m_miting
summoning	14	11	569	4	su_m_moning
sunburning	13	4	335	4	sunbur_ning
suntanning	11	4	398	4	sunta_nning
surmising	12	4	768	4	surm__ising
surprinting	14	4	455	4	su_rprinting
surprising	13	4	562	4	su_rprising
surprizing	22	4	565	4	su_rprizing
unmanning	12	4	587	4	_unma_nning
vulgarising	16	5	272	4	vulgarising
vulgarizing	25	5	351	4	vulgarizing

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.403	443402.0
2	DLD Change Limit	148819	80	8.626	17252.4
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	9.075	19690.5