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

Here are the results of your fuzzy-string dictionary search for “discrete” with Change Limit: [1] [2] [3] [4]

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.

73 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
discrete	11	4	1028	(None)
discreet	11	4	1318	1	discreet
discreeter	13	4	473	2	discreeter
discretely	16	5	369	2	discretely
disrate	8	14	1852	2	dis_rate
miscreate	13	4	889	2	miscreate
accrete	11	3	784	3	_accrete
concrete	12	4	1108	3	concrete
decree	9	31	1778	3	d_ecre_e
describe	13	4	624	3	describe
desecrate	12	4	908	3	desecrate
dictate	10	3	1166	3	di_ctate
diocese	10	3	685	3	dioc_ese
diorite	8	3	1491	3	di_orite
disagree	10	4	835	3	disagre_e
discant	10	30	1726	3	discant_
discanted	13	3	933	3	discanted
discants	11	29	1202	3	discants
discarnate	13	4	604	3	discarnate
discase	10	29	1286	3	disc_ase
disced	10	49	1465	3	disc_e_d
discept	12	3	1062	3	disc_ept
discepted	15	4	752	3	discepted
discepts	13	3	674	3	discepts
discern	10	3	849	3	disc_ern
discerned	13	4	786	3	discerned
discerner	12	4	694	3	discerner
discerns	11	3	816	3	discerns
disciple	13	4	667	3	disciple
disclike	15	20	865	3	disclike
disclose	11	4	874	3	disclose
discoed	11	3	1248	3	discoe_d
discredit	13	4	536	3	discredit
discredited	16	5	360	3	discredited
discredits	14	5	377	3	discredits
discreetest	14	5	391	3	discreetest
discreetly	16	5	351	3	discreetly
discretion	13	4	752	3	discretion
discrown	14	4	528	3	discrown
disgrace	12	4	828	3	disgrace
diskette	13	4	675	3	diskette
disparate	12	4	905	3	disparate
disperse	11	10	1135	3	disperse
dispread	12	4	710	3	dispread
disprize	20	4	843	3	disprize
disprove	14	13	819	3	disprove
dispute	10	3	908	3	dis_pute
disrated	10	9	1557	3	dis_rated
disrates	9	11	1815	3	dis_rates
disrepute	12	14	493	3	dis_repute
disrobe	10	3	899	3	dis_robe
dissert	8	37	2069	3	dissert_
disserted	11	10	981	3	disserted
disserts	9	24	1181	3	disserts
disserve	12	8	744	3	disserve
distaste	9	3	994	3	distaste
distraite	10	6	1148	3	distraite
distress	9	3	1171	3	distress
disunite	9	9	930	3	disunite
excrete	16	6	716	3	_excrete
increate	10	3	1220	3	_increate
indiscreet	13	5	350	3	indiscreet
miscite	11	3	1438	3	misc_ite
miscreated	15	4	742	3	miscreated
miscreates	14	4	810	3	miscreates
miserere	10	4	927	3	miserere
misrate	9	13	1914	3	mis_rate
miswrite	13	4	892	3	miswrite
miswrote	13	4	618	3	miswrote
picrate	11	20	1414	3	pi_crate
picrite	11	19	1131	3	pi_crite
scree	7	200	3171	3	__scre_e
secrete	9	3	1107	3	_secrete

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	73	6.906	21164.5
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.359	24282.0