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

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

74 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
larkier	11	37	1152	(None)
barkier	13	38	1448	1	barkier
lakier	10	47	1627	1	la_kier
lankier	11	37	1163	1	lankier
lardier	8	35	1834	1	lardier
larker	10	45	1924	1	lark_er
sarkier	11	34	1331	1	sarkier
artier	6	34	1973	2	_artier
balkier	13	41	1198	2	balkier
barker	12	48	2286	2	bark_er
barmier	11	43	1304	2	barmier
barnier	9	32	1367	2	barnier
barrier	9	40	1775	2	barrier
brakier	13	38	1236	2	brakier
cakier	12	31	1524	2	ca_kier
carrier	9	36	1958	2	carrier
clankier	14	32	708	2	clankier
corkier	13	31	1430	2	corkier
darker	11	47	1869	2	dark_er
darkie	11	37	1401	2	darkie_
darkies	12	40	1575	2	darkies
darklier	13	3	501	2	darklier
dorkier	12	28	1002	2	dorkier
earlier	7	26	1274	2	earlier
farrier	10	35	1489	2	farrier
flakier	14	39	1020	2	fla_kier
forkier	14	43	1159	2	forkier
gawkier	15	32	652	2	gawkier
glarier	8	41	1221	2	glar_ier
hardier	11	47	2154	2	hardier
harrier	10	44	1776	2	harrier
jerkier	18	40	727	2	jerkier
lacier	8	40	2009	2	la_cier
lacker	12	53	2562	2	lack_er
laker	9	54	3287	2	la_k_er
lambier	11	36	1164	2	lambier
lanker	10	41	2300	2	lank_er
larder	7	37	2097	2	lar_der
larger	7	44	1751	2	lar_ger
larked	11	45	1947	2	lark_ed
larkers	11	30	1451	2	lark_ers
larkiest	12	37	1332	2	larkiest
larking	12	37	1825	2	larking
larkish	14	3	908	2	larkish
lathier	10	3	1083	2	lathier
lazier	15	42	1461	2	la_zier
leakier	11	40	1099	2	leakier
learier	7	34	1566	2	lear_ier
luckier	13	38	1153	2	luckier
lurker	10	36	1329	2	lurk_er
marker	12	44	2039	2	mark_er
marlier	9	26	1478	2	marlier
marrier	9	38	1752	2	marrier
mirkier	13	31	905	2	mirkier
murkier	13	31	1027	2	murkier
oakier	10	40	1139	2	oa_kier
parker	12	41	2137	2	park_er
parrier	9	37	1765	2	parrier
partier	9	35	2071	2	partier
pawkier	16	23	661	2	pawkier
perkier	13	38	1312	2	perkier
porkier	13	37	1234	2	porkier
snarkier	12	33	651	2	snarkier
sparkier	14	29	803	2	sparkier
tackier	13	37	1252	2	tackier
talkier	11	40	1184	2	talkier
tardier	8	597	1999	2	tardier
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
wackier	16	36	973	2	wackier
warier	9	37	2289	2	war_ier
wartier	10	34	1391	2	wartier

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.406	440125.6
2	DLD Change Limit	107671	74	3.313	32499.5
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	3.749	47663.6