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

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

83 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
urticates	11	4	889	(None)
urticate	10	4	986	1	urticate_
urticated	12	4	769	1	urticated
busticates	14	5	661	2	busticates
rusticates	12	4	805	2	rusticates
suricates	11	3	1174	2	sur_icates
ultimates	11	4	843	2	ultimates
urinates	8	3	1413	2	ur_inates
urticants	11	4	446	2	urticants
abdicates	14	4	815	3	abdicates
activates	14	4	968	3	activates
articles	10	3	1024	3	artic_les
articulates	13	4	904	3	articulates
artistes	8	32	1334	3	arti_stes
auspicates	14	4	491	3	auspicates
busticate	13	5	775	3	busticate_
busticated	15	4	573	3	busticated
corticate	13	4	1076	3	corticate_
cultivates	15	4	651	3	cultivates
curtilages	13	4	319	3	curtilages
dedicates	13	3	1169	3	dedicates
delicates	12	3	1431	3	delicates
duplicates	15	4	663	3	duplicates
eradicates	13	4	826	3	eradicates
estimates	11	9	1136	3	estimates
estivates	12	10	975	3	estivates
extricates	19	9	824	3	extricates
fornicates	15	4	584	3	fornicates
frigates	12	3	1093	3	fr_igates
furcates	13	3	988	3	fur__cates
fustigates	14	4	514	3	fustigates
hurricanes	15	4	333	3	hurricanes
indicates	12	3	1258	3	indicates
intimates	11	10	1331	3	intimates
irrigates	10	5	725	3	irrigates
irritates	9	7	722	3	irritates
litigates	10	4	800	3	litigates
loricates	11	3	1012	3	loricates
lubricates	14	4	605	3	lubricates
masticates	14	4	984	3	masticates
medicates	14	3	1211	3	medicates
metricates	14	4	911	3	metricates
mitigates	12	4	825	3	mitigates
motivates	14	4	707	3	motivates
muriates	10	3	1208	3	mur_i_ates
muricate	12	3	1111	3	mur_icate_
muricated	14	4	824	3	mur_icated
mutilates	11	3	1095	3	mutilates
ordinates	10	4	900	3	ordinates
patinates	11	38	1469	3	patinates
predicates	15	4	1082	3	predicates
primates	12	15	1593	3	pr_imates
privates	13	18	1237	3	pr_ivates
radicates	12	4	1207	3	radicates
rubricates	14	4	589	3	rubricates
ruinates	8	3	1188	3	_ruinates
ruminates	11	4	1019	3	ruminates
rusticate	11	4	903	3	rusticate_
rusticated	13	4	699	3	rusticated
satiates	8	3	1463	3	sati_ates
silicates	11	3	1152	3	silicates
sonicates	11	4	1038	3	sonicates
striates	8	34	1708	3	stri_ates
suricate	10	3	1261	3	sur_icate_
titivates	12	4	643	3	titivates
triticales	12	4	626	3	triticales
truncates	11	4	584	3	truncates
tunicates	11	26	874	3	tunicates
turbinates	12	4	577	3	turbinates
ultimate	10	4	920	3	ultimate_
ultimated	12	4	731	3	ultimated
urates	6	50	2776	3	ur___ates
urinate	7	3	1536	3	ur_inate_
urinated	9	3	1161	3	ur_inated
urticant	10	6	823	3	urtica_nt
urticaria	11	5	355	3	urticaria
urticarias	12	5	379	3	urticarias
urticating	13	4	735	3	urticating
urtication	12	4	911	3	urtication
urtications	13	4	803	3	urtications
utricles	10	3	722	3	utric_les
vesicates	14	11	903	3	vesicates
vitiates	11	23	1143	3	viti_ates

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	148641	0.436	409841.7
2	DLD Change Limit	148641	83	6.673	22275.0
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	7.155	24974.3