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

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

70 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
lardier	8	35	1834	(None)
hardier	11	47	2154	1	hardier
larder	7	37	2097	1	lard_er
larkier	11	37	1152	1	larkier
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
curdier	10	33	1261	2	curdier
dandier	9	37	1457	2	dandier
earlier	7	26	1274	2	earlier
faddier	12	3	778	2	faddier
farrier	10	35	1488	2	farrier
gaudier	9	3	845	2	gaudier
gladier	9	38	1099	2	gla_dier
glarier	8	41	1220	2	glar_ier
handier	11	38	1744	2	handier
harder	10	50	2240	2	hard_er
hardies	11	49	2323	2	hardies
harrier	10	44	1775	2	harrier
lacier	8	40	2009	2	la_cier
ladder	8	46	1762	2	la_dder
laddie	8	37	1317	2	laddie_
laddies	9	37	1505	2	laddies
lader	6	56	3372	2	la_d_er
ladies	7	51	2488	2	la_dies
ladler	7	43	1493	2	la_dler
lakier	10	47	1627	2	la_kier
lambier	11	36	1163	2	lambier
lander	7	40	2848	2	land_er
landler	8	41	1320	2	landler
lankier	11	37	1163	2	lankier
larded	8	43	1909	2	lard_ed
larders	8	35	1694	2	lard_ers
lardiest	9	38	1388	2	lardiest
larding	9	29	1787	2	larding
larger	7	44	1751	2	lar_ger
larker	10	45	1924	2	lar_ker
lathier	10	3	1083	2	lathier
lauder	7	38	1501	2	laud_er
lazier	15	42	1461	2	la_zier
leadier	8	32	1272	2	leadier
learier	7	34	1566	2	lear_ier
lordlier	9	3	535	2	lordlier
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
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	1120	2	wordier
yarder	10	38	1397	2	yard_er

Search took 5 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.140	1276364.3
2	DLD Change Limit	107671	70	4.030	26717.4
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	4.203	42515.1