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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

132 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
herded	11	42	1564	(None)
headed	11	40	2047	1	headed
heeded	11	42	1576	1	heeded
herbed	12	35	1345	1	herbed
herder	10	45	1646	1	herder
horded	11	54	2048	1	horded
aeried	7	42	2187	2	aeried
barded	10	54	2642	2	barded
beaded	10	49	2242	2	beaded
bearded	11	42	1213	2	bearded
bedded	11	51	1407	2	bedded
bended	10	55	2123	2	bended
bermed	11	52	1772	2	bermed
birded	10	44	1430	2	birded
carded	10	54	2490	2	carded
ceded	9	61	1856	2	ce_ded
cered	8	52	2744	2	cer_ed
chorded	14	47	1055	2	chorded
corded	10	59	2335	2	corded
curded	10	42	1716	2	curded
deeded	9	46	1554	2	deeded
derided	10	29	1425	2	derided
ended	7	44	2126	2	_ended
eroded	8	43	1359	2	_eroded
erred	6	59	1567	2	_erred
farded	11	45	1895	2	farded
fended	11	42	1691	2	fended
feuded	11	40	1000	2	feuded
forded	11	50	2039	2	forded
gelded	9	45	1211	2	gelded
girded	9	37	1249	2	girded
haded	10	52	2762	2	h_aded
handed	11	49	1998	2	handed
harden	10	57	1853	2	harden
harder	10	50	2240	2	harder
hared	9	57	4218	2	har_ed
harked	14	54	2255	2	harked
harmed	12	52	1884	2	harmed
harped	12	44	1840	2	harped
headend	12	39	836	2	headend
header	10	44	2254	2	header
healed	10	51	2144	2	healed
heaped	12	45	1690	2	heaped
hearsed	11	38	1142	2	hearsed
hearted	11	33	1403	2	hearted
heated	10	45	2559	2	heated
heaved	13	47	1786	2	heaved
heder	9	56	2364	2	he_der
hedged	12	52	1181	2	hedged
heed	8	64	3760	2	he__ed
heeder	10	42	1604	2	heeder
heeled	10	40	1842	2	heeled
heezed	19	42	1051	2	heezed
hefted	13	49	1142	2	hefted
heiled	10	44	1561	2	heiled
heired	10	38	1304	2	heired
helled	10	40	2470	2	helled
helmed	12	45	1369	2	helmed
helped	12	47	1415	2	helped
helved	13	43	1370	2	helved
hemmed	14	42	1146	2	hemmed
hented	10	42	1875	2	hented
herald	10	3	1134	2	herald
heralded	13	3	544	2	heralded
herd	8	49	3306	2	her__d
herders	11	39	1412	2	herders
herdic	12	31	1230	2	herdic
herdmen	13	23	845	2	herdmen
herds	9	64	2468	2	herd_s
here	7	64	4710	2	her_e_
heredes	11	3	1313	2	heredes
heres	8	62	4590	2	her_es
heroes	9	49	2383	2	heroes
herpes	11	55	1732	2	herpes
herried	11	35	1447	2	herried
hewed	12	56	1943	2	he_wed
hexed	16	56	1576	2	he_xed
heydey	16	3	463	2	heydey
hided	10	52	2245	2	h_ided
hired	9	52	2626	2	hir_ed
hoarded	12	36	834	2	hoarded
hooded	11	46	1674	2	hooded
horde	9	46	2305	2	horde_
hordes	10	49	2163	2	hordes
horned	10	57	1870	2	horned
horsed	10	53	2108	2	horsed
hurdled	12	37	983	2	hurdled
hurled	10	46	1745	2	hurled
jereed	14	40	1207	2	jereed
jerked	18	47	959	2	jerked
kerbed	13	33	970	2	kerbed
kerfed	14	35	823	2	kerfed
kerned	11	41	1293	2	kerned
larded	8	43	1909	2	larded
leaded	8	42	2154	2	leaded
lorded	8	49	1673	2	lorded
melded	10	47	1471	2	melded
mended	10	44	1868	2	mended
merde	8	43	2012	2	merde_
merdes	9	45	1860	2	merdes
merged	10	42	1495	2	merged
needed	8	41	1444	2	needed
nerved	10	41	1169	2	nerved
pended	10	38	1901	2	pended
perked	13	46	1769	2	perked
permed	11	52	1735	2	permed
redded	9	40	1955	2	redded
reded	7	48	2912	2	re_ded
reeded	8	40	2256	2	reeded
rended	8	45	2410	2	rended
seeded	8	45	2046	2	seeded
sended	8	51	2123	2	sended
sered	6	57	3729	2	ser_ed
serged	8	41	1877	2	serged
served	10	46	1681	2	served
shedded	13	41	906	2	shedded
tedded	9	38	1090	2	tedded
tended	8	38	1948	2	tended
termed	9	48	1670	2	termed
vended	11	44	1635	2	vended
verged	11	48	1516	2	verged
versed	10	45	1552	2	versed
warded	11	50	2104	2	warded
wedded	12	38	1184	2	wedded
weeded	11	39	1487	2	weeded
weirded	12	3	451	2	weirded
welded	11	40	1338	2	welded
wended	11	36	1615	2	wended
worded	11	43	1662	2	worded
yarded	11	47	1402	2	yarded
yerked	14	50	937	2	yerked
zeroed	16	40	942	2	zeroed

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	132	2.343	35233.0
3	Display Results	132	132	0.033	4000.0
	(SQL Overall)	178691	132	2.719	65719.4