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

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

63 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
residential	12	5	527	(None)
presidential	15	5	457	1	presidential
coresidential	16	6	298	2	coresidential
evidential	14	5	545	2	_evidential
residentially	17	7	383	2	residentially
credential	13	4	640	3	cre__dential
essential	9	4	608	3	_es_sential
nonresidential	15	6	288	3	~~non~~residential
penitential	13	5	552	3	penitential
pestilential	14	6	318	3	pestilential
presidentially	20	6	321	3	presidentially
providential	18	6	297	3	providential
referential	14	5	468	3	referential
regimental	13	11	576	3	regiment_al
reidentify	17	5	313	3	re_identify
residencies	14	4	597	3	residencies
resident	9	3	1375	3	resident___
residents	10	3	842	3	resident__s
reverential	14	8	446	3	reverential
accidental	15	5	381	4	accident_al
bidental	11	4	658	4	__bident_al
cadential	12	4	639	4	__cadential
confidential	18	5	428	4	confidential
credentials	14	5	470	4	cre__dentials
deferential	15	5	471	4	deferential
demential	12	4	868	4	de__mential
epicentral	14	5	437	4	_epicentral
essentials	10	5	458	4	_es_sentials
evidentially	19	5	404	4	_evidentially
evidentiary	18	7	221	4	_evidentiary
existential	18	5	388	4	_existential
identical	12	4	631	4	___identical
incidental	13	13	561	4	incident_al
inessential	11	5	464	4	ines_sential
misidentify	20	9	185	4	misidentify
nonidentical	15	5	433	4	nonidentical
occidental	15	5	360	4	occident_al
pedimental	15	5	643	4	pediment_al
preferential	17	5	387	4	preferential
prepresidential	20	7	95	4	~~prep~~residential
presidencies	17	5	448	4	presidencies
president	12	4	1099	4	president___
presidents	13	4	702	4	president__s
presidial	12	4	721	4	presid___ial
prudential	13	7	512	4	_prudential
regental	9	4	894	4	re__gent_al
regimentals	14	9	465	4	regiment_als
regimenting	15	4	466	4	regimenting
resentful	12	4	426	4	res__entful
resenting	10	26	1929	4	res__enting
resentive	12	4	1072	4	res__entive
residence	12	6	890	4	residen__ce
residences	13	6	823	4	residen_ces
residency	15	6	551	4	residen__cy
residual	9	24	544	4	resid___ual
rewidening	15	4	408	4	rewiden_ing
rudimental	13	5	382	4	rudiment_al
sciential	11	4	632	4	__sciential
sentential	10	4	753	4	se_ntential
sequential	19	5	481	4	se_quential
tridental	10	4	662	4	_trident_al
unessential	11	5	387	4	unes_sential
vestmental	15	5	403	4	vestment_al

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.420	425454.8
2	DLD Change Limit	148819	63	8.796	16918.9
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	9.249	19320.0