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

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

65 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
submittals	14	5	288	(None)
submittal	13	4	388	1	submittal_
submitters	14	4	444	2	submitters
committals	16	5	308	3	committals
remittals	11	4	488	3	_remittals
subcostals	14	5	343	3	subcostals
sublittorals	14	11	140	3	sublittorals
submits	11	3	975	3	submi_t__s
submitted	14	4	523	3	submitt_ed
submitter	13	4	528	3	submitt_er
submitting	15	4	497	3	submitting
subtotals	11	4	499	3	sub_totals
summital	12	4	470	3	summi_tal_
abettals	10	5	472	4	_ab_ettals
abuttals	10	4	392	4	_ab_uttals
acquittals	21	5	150	4	acquittals
aubrietas	11	4	283	4	aubrieta_s
bimetals	12	4	695	4	__bimetals
buttals	9	3	850	4	__b_uttals
committal	15	4	372	4	committal_
cubital	11	3	710	4	cub_i_tal_
gunmetals	12	4	290	4	gunm_etals
orbitals	10	4	571	4	orb_i_tals
quintals	17	28	800	4	qu__intals
rebuttals	11	4	286	4	reb_uttals
remittal	10	4	651	4	_remittal_
sagittal	9	4	328	4	s_agittal_
scimitars	13	4	317	4	scimi_tars
semimetals	14	5	467	4	s_emimetals
shittahs	14	11	410	4	s__hittahs
simitars	10	4	648	4	s_imi_tars
somital	9	3	940	4	s_omi_tal_
spirituals	12	5	355	4	spirituals
spitals	9	30	1159	4	s__pi_tals
subastral	11	4	405	4	subastral_
subcostal	13	4	456	4	subcostal_
subduals	11	5	629	4	sub__duals
subgoals	11	4	555	4	sub__goals
subideas	11	4	644	4	sub_idea_s
subitems	12	4	549	4	sub_i_tems
sublethal	14	4	348	4	sublethal_
sublimates	14	4	717	4	sublimates
sublittoral	13	9	196	4	sublittoral_
subminimal	16	5	278	4	subminimal_
submiss	11	3	808	4	submi___ss
submit	10	3	1267	4	submi_t___
subnormals	14	5	262	4	subnormals
subsisters	12	4	502	4	subsisters
subsists	10	3	799	4	subsist__s
subsites	10	3	1278	4	subsi_t_es
substates	11	14	1033	4	sub_states
subtilties	12	4	611	4	subtilties
subtitle	10	4	660	4	subti_t_le
subtitles	11	5	685	4	subti_tles
subtotal	10	4	626	4	sub_total_
subvassals	15	5	189	4	subvassals
subvicars	16	4	383	4	subvi_cars
subviral	13	4	526	4	subvi_ral_
subvisual	14	5	259	4	subvisual_
summiteers	14	4	234	4	summiteers
summitries	14	4	464	4	summitries
summits	11	3	798	4	summi_t__s
sundials	9	4	675	4	sundi__als
survivals	15	4	301	4	survi_vals
suttas	6	38	1379	4	su___tta_s

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	161450	0.440	406115.9
2	DLD Change Limit	161450	65	9.373	17225.0
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	9.846	18148.6