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

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

77 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
urticated	12	4	769	(None)
urticate	10	4	986	1	urticate_
urticates	11	4	889	1	urticates
busticated	15	4	573	2	busticated
muricated	14	4	824	2	mur_icated
rusticated	13	4	699	2	rusticated
ultimated	12	4	731	2	ultimated
urinated	9	3	1161	2	ur_inated
abdicated	15	4	701	3	abdicated
activated	15	6	788	3	activated
articled	11	3	706	3	artic_led
articulated	14	4	762	3	articulated
auspicated	15	4	430	3	auspicated
busticate	13	5	775	3	busticate_
busticates	14	5	661	3	busticates
corticate	13	4	1076	3	corticate_
cultivated	16	4	567	3	cultivated
dedicated	14	3	1025	3	dedicated
duplicated	16	5	583	3	duplicated
eradicated	14	4	687	3	eradicated
estimated	12	10	944	3	estimated
estivated	13	10	832	3	estivated
extricated	20	6	708	3	extricated
fornicated	16	4	482	3	fornicated
furcated	14	3	759	3	fur__cated
fustigated	15	4	447	3	fustigated
indicated	13	3	1095	3	indicated
intimated	12	10	1089	3	intimated
irrigated	11	7	631	3	irrigated
irritated	10	7	613	3	irritated
litigated	11	4	656	3	litigated
loricated	12	4	789	3	loricated
lubricated	15	4	503	3	lubricated
masticated	15	4	823	3	masticated
medicated	15	4	1007	3	medicated
metricated	15	4	729	3	metricated
mitigated	13	4	708	3	mitigated
motivated	15	4	596	3	motivated
multicoated	16	5	457	3	multicoated
muriated	11	3	979	3	mur_i_ated
muricate	12	3	1111	3	mur_icate_
mutilated	12	3	945	3	mutilated
patinated	12	39	1141	3	patinated
plicated	13	3	1064	3	_plicated
predicated	16	4	914	3	predicated
radicated	13	4	1012	3	radicated
rubricated	15	4	504	3	rubricated
ruinated	9	3	952	3	_ruinated
ruminated	12	5	866	3	ruminated
rusticate	11	4	903	3	rusticate_
rusticates	12	4	805	3	rusticates
satiated	9	3	1160	3	sati_ated
sonicated	12	4	845	3	sonicated
spicated	13	30	990	3	_spicated
striated	9	34	1415	3	stri_ated
suricate	10	3	1261	3	sur_icate_
suricates	11	3	1174	3	sur_icates
titivated	13	4	544	3	titivated
tritiated	10	4	752	3	tritiated
truncated	12	4	458	3	truncated
tunicated	12	25	749	3	tunicated
turbinated	13	4	441	3	turbinated
ultimate	10	4	920	3	ultimate_
ultimates	11	4	843	3	ultimates
unlocated	12	3	838	3	unlocated
untilted	9	6	1089	3	unti_lted
untreated	10	3	1290	3	untreated
uptilted	11	7	468	3	upti_lted
urinate	7	3	1536	3	ur_inate_
urinates	8	3	1413	3	ur_inates
urticant	10	6	823	3	urtica_nt
urticants	11	4	446	3	urticants
urticaria	11	5	355	3	urticaria
urticating	13	4	735	3	urticating
urtication	12	4	911	3	urtication
vesicated	15	11	765	3	vesicated
vitiated	12	28	922	3	viti_ated

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.403	443402.0
2	DLD Change Limit	148641	77	7.173	20722.3
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.606	23493.4