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

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

66 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
credentials	14	5	471	(None)
credential	13	4	641	1	credential_
credentialed	16	5	276	2	credentialed
credentialism	18	6	382	2	credentialism
cadential	12	4	639	3	c_adential_
celestials	12	5	409	3	c_elestials
credentialing	17	10	279	3	credentialing
credentialisms	19	6	317	3	credential~~ism~~s
credentialled	17	6	188	3	credentialled
credenzas	21	4	218	3	creden_za_s
prudential	13	7	512	3	prudential_
accidentals	16	5	288	4	accident_als
celestial	11	4	615	4	c_elestial_
cementites	14	7	618	4	c_ementites
centals	9	43	1705	4	c___ent_als
centennials	13	13	353	4	centennials
centrals	10	27	1203	4	c___entrals
ceremonials	15	5	305	4	ceremon_ials
conventuals	16	6	516	4	conventuals
coresidential	16	6	299	4	coresidential_
credences	14	9	814	4	creden__ces
credenda	12	4	339	4	creden_da__
credent	10	3	1397	4	credent____
credentialling	18	12	153	4	credentialling
credenza	20	4	228	4	creden_za__
decennials	13	5	334	4	_decennials
demential	12	4	869	4	_demential_
dementias	12	5	741	4	_dementia_s
denials	8	41	1413	4	___den_ials
dentals	8	39	1539	4	___dent_als
dentils	8	41	1558	4	___denti_ls
elementals	12	5	479	4	element_als
essentials	10	5	458	4	_essentials
evidential	14	5	545	4	evidential_
greenmails	13	8	278	4	gre_enmails
inessentials	12	6	358	4	inessentials
irredentas	11	7	335	4	irredent_a_s
irredentisms	15	6	225	4	irredentisms
irredentists	13	6	269	4	irredentists
orientals	9	4	690	4	or_ient_als
pedestals	12	5	520	4	_pedest_als
perennials	12	4	489	4	_perennials
potentials	12	4	554	4	_potentials
predestines	14	4	699	4	predestines
pregenital	13	4	515	4	pregenital_
presentisms	15	5	521	4	presentisms
presidential	15	5	457	4	presidential_
pretentious	13	12	559	4	pretentious
preventible	18	5	442	4	preventible
preventions	16	4	853	4	preventions
preventives	19	4	572	4	preventives
prudentially	18	5	415	4	prudentially
redenies	9	6	1571	4	_reden_i_es
redials	8	44	1688	4	_red___ials
redistills	11	4	316	4	_redistills
redtails	9	6	800	4	_red__tails
regental	9	4	894	4	_regent_al_
rentals	7	40	1747	4	_r__ent_als
residential	12	5	527	4	_residential_
retentions	10	16	1111	4	_retentions
sexennials	17	5	262	4	_sexennials
treenails	9	4	556	4	tre_enai_ls
tridental	10	4	662	4	trident_al_
triennials	10	4	362	4	tr_iennials
uncredentialed	18	8	176	4	uncredentialed
uredinial	10	4	391	4	uredin_ial_

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.470	380193.6
2	DLD Change Limit	148819	66	9.406	15821.7
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	9.906	18038.7