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

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

62 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
herniated	13	4	601	(None)
herniate	11	4	811	1	herniate_
herniates	12	4	733	1	herniates
herniae	10	3	904	2	hernia_e_
seriated	9	27	1702	2	ser_iated
aerated	8	53	2237	3	aer__ated
berated	10	44	2213	3	ber__ated
carinated	12	34	1426	3	carinated
cerated	10	39	2247	3	cer__ated
crenated	11	30	1391	3	cren_ated
dentated	10	4	1170	3	de_ntated
derated	9	36	2350	3	der__ated
derogated	12	3	867	3	derogated
deviated	13	3	1104	3	de_viated
eradiated	11	17	881	3	_eradiated
expiated	18	16	852	3	_expiated
fornicated	16	4	482	3	fornicated
geminated	13	3	854	3	geminated
germinated	14	4	656	3	germinated
heated	10	45	2559	3	he___ated
hebetated	15	4	466	3	hebetated
heisted	11	32	1065	3	he__isted
hennaed	11	3	510	3	he_nna_ed
hented	10	42	1875	3	he_n__ted
herbaged	15	5	452	3	her_baged
hernia	9	3	1229	3	hernia___
hernial	10	3	1043	3	hernia__l
hernias	10	3	1077	3	hernia__s
herniating	14	4	598	3	herniating
herniation	13	4	844	3	herniation
heroized	21	29	845	3	heroi_zed
herried	11	35	1445	3	herri__ed
hesitated	13	7	778	3	hesitated
hibernated	16	4	322	3	hibern_ated
kernite	11	5	947	3	kerni_te_
kernites	12	6	911	3	kerni_tes
lariated	9	12	1206	3	lar_iated
lenited	8	8	1243	3	le_ni_ted
marinated	12	25	1317	3	marinated
mediated	12	30	1187	3	me_diated
merited	10	3	1385	3	mer_i_ted
muriated	11	3	979	3	mur_iated
pennated	11	29	954	3	pe_nnated
perennated	13	4	569	3	perennated
permeated	14	3	937	3	permeated
permitted	14	4	665	3	permitted
perorated	12	4	1246	3	perorated
persisted	12	4	714	3	persisted
reanimated	13	4	700	3	reanimated
reknitted	14	4	402	3	reknitted
reradiated	12	17	753	3	reradiated
resinated	10	4	1328	3	resinated
reunited	9	3	971	3	reuni_ted
sensated	9	3	819	3	se_nsated
seriate	7	37	2247	3	ser_iate_
seriates	8	26	2067	3	ser_iates
serrated	9	25	1343	3	ser_rated
striated	9	34	1415	3	str_iated
terminated	13	4	816	3	terminated
ternate	7	4	1548	3	tern_ate_
urinated	9	3	1161	3	_urinated
variated	12	12	1139	3	var_iated

Search took 9 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.423	422437.4
2	DLD Change Limit	148641	62	8.093	18366.6
3	Display Results	62	62	0.016	3875.0
	(SQL Overall)	178691	62	8.532	20943.6