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

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

79 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
consistence	15	5	567	(None)
consistences	16	5	543	1	consistences
consistency	18	5	397	1	consistency
coexistence	22	5	326	2	coexistence
consistencies	17	5	384	2	consistencies
consistent	12	4	855	2	consisten_t
inconsistence	17	8	391	2	inconsistence
insistence	12	4	601	2	_insistence
coexistences	23	5	287	3	coexistences
confidence	18	4	706	3	confi_dence
conscience	13	4	705	3	cons_cience
consequence	24	5	503	3	consequence
consisted	12	3	851	3	consiste__d
consistently	17	5	361	3	consistently
consisting	13	4	952	3	consistin_g
continence	14	8	913	3	conti_nence
contingence	16	10	545	3	contingence
inconsistences	18	8	372	3	inconsistences
inconsistency	20	6	293	3	inconsistency
insistences	13	5	558	3	_insistences
insistency	15	5	397	3	_insistency
nonexistence	21	17	352	3	nonexistence
nonsentence	13	5	588	3	nonsentence
persistence	15	5	415	3	persistence
subsistence	15	5	326	3	subsistence
assistance	12	5	345	4	_assistance
candescence	15	5	480	4	candescence
coalescence	14	5	509	4	coalescence
coexistent	19	8	424	4	coexisten_t
coincidence	15	8	360	4	coinci_dence
competence	18	4	672	4	co_mpetence
concrescence	14	8	450	4	concrescence
concupiscence	17	14	164	4	concupiscence
concurrence	14	5	479	4	concurrence
condolence	15	6	531	4	con_dolence
conductance	15	5	340	4	conductance
conference	17	9	901	4	con_ference
conferrence	18	9	657	4	conferrence
confidences	19	4	663	4	confi_dences
confluence	17	5	534	4	con_fluence
congruence	15	5	507	4	con_gruence
connivance	17	5	425	4	conni_vance
consciences	14	4	702	4	cons_ciences
consequences	25	5	485	4	consequences
consignee	12	4	656	4	consi__gnee
consist	9	3	1603	4	consist____
consistories	14	5	509	4	consistories
consistory	15	4	557	4	consist_ory
consists	10	3	1059	4	consist___s
consonance	14	4	618	4	cons_onance
constancy	16	4	602	4	con__stancy
constituency	19	8	213	4	constituency
consultancy	18	5	306	4	consultancy
continences	15	8	858	4	conti_nences
contingences	17	9	499	4	contingences
contingency	19	9	404	4	contingency
continuance	15	5	512	4	continuance
convenience	18	8	644	4	convenience
convergence	19	11	654	4	convergence
convince	15	4	736	4	convi___nce
desistance	13	4	458	4	_desistance
existence	18	4	541	4	__existence
inconsistencies	19	13	259	4	inconsistencies
inconsistent	14	6	410	4	inconsisten_t
inexistence	20	5	421	4	inexistence
insistencies	14	5	405	4	_insistencies
insistent	9	4	825	4	_insisten_t
nonexistences	22	11	295	4	nonexistences
nonhistone	13	5	423	4	nonhiston_e
nonresistance	15	6	265	4	nonresistance
nonscience	14	5	623	4	nons_cience
nonsentences	14	5	571	4	nonsentences
nonviolence	16	5	343	4	nonviolence
penitence	13	4	809	4	pen_i_tence
persistences	16	5	387	4	persistences
persistency	18	5	265	4	persistency
renitence	11	4	906	4	ren_i_tence
resistance	12	4	588	4	_resistance
subsistences	16	5	300	4	subsistences

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	79	9.173	16223.6
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	9.639	18538.3