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

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

89 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
submariners	15	5	322	(None)
submariner	14	4	407	1	submariner_
submarines	14	4	691	1	submarine_s
submarine	13	4	784	2	submarine__
submarined	15	4	450	2	submarine_d
summarizers	24	13	282	2	summarizers
mariners	10	31	1386	3	___mariners
submanagers	16	5	170	3	submanagers
submarining	16	5	358	3	submarining
submarkets	18	12	315	3	submar_kets
suborners	11	4	631	3	sub_or_ners
subscribers	17	5	261	3	subscribers
subwriters	15	4	441	3	sub_writers
summaries	13	11	818	3	summari_e_s
summarises	14	11	525	3	summarise_s
summarizer	23	10	427	3	summarizer_
summarizes	23	12	565	3	summarize_s
sustainers	10	4	413	3	susta_iners
aquamarines	22	10	215	4	aquamarine_s
briners	9	43	1563	4	__b__riners
cumarins	12	3	864	4	cu_marin__s
curarines	11	7	1055	4	cu_rarine_s
furriners	12	31	632	4	fu__rriners
humanizers	24	4	395	4	hu_manizers
imaginers	12	4	369	4	__imaginers
mariner	9	33	1599	4	___mariner_
marines	9	39	2801	4	___marine_s
muscarines	14	4	539	4	muscarine_s
obtainers	11	4	485	4	_obta_iners
scariness	11	3	1018	4	s__cariness
semainiers	12	4	338	4	s_ema_iniers
simazines	20	4	486	4	s_imazine_s
smarminess	14	4	430	4	s__marminess
smartness	11	3	614	4	s__martness
stainers	8	32	1217	4	s__ta_iners
stearines	9	3	1128	4	s_tearine_s
strainers	9	5	1038	4	s_tra_iners
subacidness	16	5	198	4	sub_acidness
subareas	10	3	862	4	sub_ar__eas
subbasins	13	4	476	4	subbasin__s
subcabinet	16	5	509	4	subcabine_t
subdividers	18	5	157	4	subdividers
suberins	10	3	1509	4	sub_erin__s
suberises	11	8	1345	4	sub_erise_s
suberizes	20	8	1183	4	sub_erize_s
sublimers	13	4	577	4	sub__limers
sublines	10	3	1578	4	sub__line_s
submanager	15	5	225	4	submanager_
submarginal	16	5	215	4	submargin_al
submarket	17	9	608	4	submar_ke_t
submerges	14	4	628	4	submer_ge_s
submerses	13	4	800	4	submer_se_s
subministers	16	5	187	4	subministers
submitters	14	4	444	4	subm_itters
suborders	12	4	550	4	sub_or_ders
suborner	10	4	738	4	sub_or_ner_
suboscines	14	4	496	4	suboscine_s
subpanels	13	4	439	4	subpa__nels
subrings	11	22	988	4	sub__rin_gs
subscriber	16	4	365	4	subscriber_
subscribes	16	4	487	4	subscribe_s
subseries	11	3	1293	4	subseri_e_s
subsiders	12	4	605	4	sub__siders
subsidizers	23	5	288	4	subsidizers
subsoilers	12	4	406	4	sub_soilers
subtracters	15	7	380	4	subtracters
subtribes	13	4	623	4	sub_tribe_s
subvariety	18	5	262	4	subvari_ety
subverters	15	4	461	4	subver_ters
subwriter	14	4	562	4	sub_writer_
sudaries	9	3	1275	4	su_dari_e_s
sugarers	9	3	630	4	su_gar__ers
sugarier	9	3	739	4	su_gari_er_
sultriness	10	4	556	4	su_ltriness
summarise	13	11	573	4	summarise__
summarised	15	12	391	4	summarise_d
summarists	14	10	470	4	summari_sts
summarize	22	10	565	4	summarize__
summarized	24	11	491	4	summarize_d
summerier	13	4	642	4	summeri_er_
summoners	13	4	473	4	su_m_moners
superliners	13	4	738	4	superliners
surmisers	11	4	520	4	surm__isers
surprisers	12	4	363	4	su_rprisers
sustainer	9	4	478	4	susta_iner_
sybarites	14	6	593	4	syb_arite_s
unwariness	13	6	588	4	_unwariness
vulgarizers	24	17	247	4	vulgarizers
weimaraners	16	5	129	4	weimaraners

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.436	409841.7
2	DLD Change Limit	148819	89	8.220	18104.5
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	8.686	20572.3