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

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

90 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
urticate	10	4	986	(None)
urticated	12	4	769	1	urticated
urticates	11	4	889	1	urticates
busticate	13	5	775	2	busticate
corticate	13	4	1076	2	corticate
muricate	12	3	1111	2	mur_icate
rusticate	11	4	903	2	rusticate
suricate	10	3	1261	2	sur_icate
ultimate	10	4	920	2	ultimate
urinate	7	3	1536	2	ur_inate
urticant	10	6	823	2	urticant
urticants	11	4	446	2	urticants
abdicate	13	4	890	3	abdicate
activate	13	5	1037	3	activate
article	9	3	1092	3	artic_le
articulate	12	4	1024	3	articulate
artiste	7	38	1369	3	arti_ste
auspicate	13	4	574	3	auspicate
busticated	15	4	573	3	busticated
busticates	14	5	661	3	busticates
cruciate	12	8	731	3	cruciate
cultivate	14	4	708	3	cultivate
curtate	9	3	1264	3	curt__ate
curtilage	12	4	320	3	curtilage
dedicate	12	3	1280	3	dedicate
delicate	11	3	1549	3	delicate
duplicate	14	4	700	3	duplicate
eradicate	12	5	918	3	eradicate
estimate	10	9	1200	3	estimate
estivate	11	10	1000	3	estivate
extricate	18	6	907	3	extricate
forficate	17	4	512	3	forficate
fornicate	14	4	608	3	fornicate
frigate	11	3	1106	3	fr_igate
furcate	12	3	1045	3	fur__cate
fustigate	13	4	562	3	fustigate
hurricane	14	4	313	3	hurricane
indicate	11	3	1335	3	indicate
intimate	10	10	1383	3	intimate
intricate	11	4	1119	3	intricate
irrigate	9	6	763	3	irrigate
irritate	8	6	787	3	irritate
litigate	9	4	830	3	litigate
loricate	10	3	1066	3	loricate
lubricate	13	4	644	3	lubricate
masticate	13	4	1128	3	masticate
medicate	13	5	1324	3	medicate
metricate	13	4	992	3	metricate
mitigate	11	4	869	3	mitigate
motivate	13	4	769	3	motivate
muriate	9	3	1336	3	mur_i_ate
muricated	14	4	824	3	mur_icated
mutilate	10	3	1227	3	mutilate
ordinate	9	3	1025	3	ordinate
patinate	10	30	1631	3	patinate
plicate	11	3	1451	3	_plicate
predicate	14	4	1178	3	predicate
primate	11	15	1628	3	pr_imate
private	12	15	1326	3	pr_ivate
radicate	11	4	1287	3	radicate
rubricate	13	4	648	3	rubricate
ruinate	7	3	1283	3	_ruinate
ruminate	10	5	1147	3	ruminate
rusticated	13	4	699	3	rusticated
rusticates	12	4	805	3	rusticates
satiate	7	3	1540	3	sati_ate
silicate	10	3	1262	3	silicate
sonicate	10	3	1093	3	sonicate
spicate	11	32	1419	3	_spicate
striate	7	42	1895	3	stri_ate
suricates	11	3	1174	3	sur_icates
titivate	11	4	680	3	titivate
triticale	11	4	751	3	triticale
truncate	10	4	628	3	truncate
tunicate	10	33	1004	3	tunicate
turbinate	11	4	667	3	turbinate
ultimata	10	5	556	3	ultimata
ultimated	12	4	731	3	ultimated
ultimates	11	4	843	3	ultimates
uncinate	10	3	1239	3	uncinate
urate	5	54	3216	3	ur___ate
urinated	9	3	1161	3	ur_inated
urinates	8	3	1413	3	ur_inates
urticaria	11	5	355	3	urticaria
urticating	13	4	735	3	urticating
urtication	12	4	911	3	urtication
ustulate	8	6	832	3	ustulate
utricle	9	3	791	3	utric_le
vesicate	13	12	1005	3	vesicate
vitiate	10	34	1295	3	viti_ate

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.440	406115.9
2	DLD Change Limit	146162	90	7.170	20385.2
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	7.643	23379.7