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

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

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.

81 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
hardier	11	47	2154	(None)
handier	11	38	1744	1	handier
harder	10	50	2240	1	hard_er
hardies	11	49	2323	1	hardies
harrier	10	44	1775	1	harrier
lardier	8	35	1834	1	lardier
tardier	8	597	1999	1	tardier
arider	7	47	1774	2	_arider
artier	6	34	1973	2	_artier
barkier	13	38	1448	2	barkier
barmier	11	43	1304	2	barmier
barnier	9	32	1367	2	barnier
barrier	9	40	1773	2	barrier
bawdier	13	37	820	2	bawdier
carder	9	45	2418	2	card_er
carrier	9	36	1958	2	carrier
charier	12	43	1790	2	char_ier
charrier	13	7	868	2	charrier
curdier	10	33	1262	2	curdier
dandier	9	37	1457	2	dandier
earlier	7	26	1274	2	earlier
faddier	12	3	778	2	faddier
farrier	10	35	1489	2	farrier
gaudier	9	3	845	2	gaudier
hagrider	13	3	448	2	hagrider
hairier	10	31	1105	2	hairier
hammier	14	35	1065	2	hammier
hander	10	45	2643	2	hand_er
handler	11	35	1616	2	handler
happier	14	33	1203	2	happier
harden	10	57	1853	2	hard_en
hardener	12	3	888	2	hardener
hardiest	12	34	1633	2	hardiest
hardily	14	33	1027	2	hardily
hardset	11	34	1583	2	hardset
hardwire	15	4	462	2	hardwire
harmer	11	47	1955	2	har_mer
harper	11	50	1840	2	har_per
harpies	12	38	1831	2	harpies
harried	11	38	1553	2	harried
harriers	11	37	1243	2	harriers
harries	10	35	2549	2	harries
harsher	13	3	1036	2	harsher
hastier	10	39	1662	2	hastier
haulier	10	5	994	2	haulier
hazier	18	47	1240	2	ha_zier
headier	11	32	1295	2	headier
heartier	11	3	909	2	heartier
herbier	12	3	959	2	herbier
herder	10	45	1646	2	herd_er
hoarder	11	32	923	2	hoard_er
hoarier	10	42	1174	2	hoar_ier
hoodier	11	38	1297	2	hoodier
hornier	10	30	1246	2	hornier
horsier	10	30	1324	2	horsier
hurdies	11	40	1566	2	hurdies
hurdler	11	36	1000	2	hurdler
hurrier	10	34	1294	2	hurrier
larder	7	37	2097	2	lard_er
larkier	11	37	1152	2	larkier
marlier	9	26	1477	2	marlier
marrier	9	38	1752	2	marrier
nerdier	8	31	1035	2	nerdier
pardie	9	60	2144	2	pardie_
pardner	10	23	947	2	pardner
parrier	9	37	1765	2	parrier
partier	9	35	2071	2	partier
randier	8	36	1847	2	randier
sandier	8	40	1784	2	sandier
sarkier	11	34	1331	2	sarkier
shadier	11	31	1115	2	sha_dier
tardies	8	42	2586	2	tardies
tarrier	7	43	2317	2	tarrier
tarsier	7	41	1925	2	tarsier
tartier	7	41	2326	2	tartier
varier	9	46	1935	2	var_ier
warder	10	40	2027	2	ward_er
warier	9	37	2289	2	war_ier
wartier	10	34	1391	2	wartier
wordier	11	25	1121	2	wordier
yarder	10	38	1397	2	yard_er

Search took 4 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	107671	0.390	458182.1
2	DLD Change Limit	107671	81	2.983	36094.9
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	3.403	52509.8