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

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

73 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
balkier	13	41	1198	(None)
balker	12	45	1916	1	balk_er
balmier	11	38	1151	1	balmier
barkier	13	38	1448	1	barkier
baulkier	14	3	353	1	baulkier
bulkier	13	41	1151	1	bulkier
talkier	11	40	1184	1	talkier
alkie	9	55	2003	2	_alkie_
alkies	10	45	1809	2	_alkies
babier	10	35	1557	2	ba_bier
backer	14	45	2553	2	back_er
baggier	11	36	1164	2	baggier
baker	11	56	2954	2	ba_k_er
balder	9	53	1886	2	bal_der
baldies	10	53	1770	2	baldies
baler	7	56	3527	2	bal__er
balked	13	52	1941	2	balk_ed
balkers	13	49	1572	2	balk_ers
balkiest	14	41	1245	2	balkiest
balkily	16	26	669	2	balkily
balking	14	37	1735	2	balking
baller	8	38	2520	2	bal_ler
ballies	9	37	2574	2	ballies
ballsier	10	3	652	2	ballsier
banker	12	42	2273	2	bank_er
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
battier	9	35	1572	2	battier
bawdier	13	37	820	2	bawdier
beakier	13	40	1216	2	beakier
belier	8	44	2356	2	bel_ier
bilgier	10	35	853	2	bilgier
bilker	12	49	1344	2	bilk_er
boskier	13	30	917	2	boskier
brakier	13	38	1236	2	brakier
bulgier	10	39	1121	2	bulgier
bullier	9	41	1643	2	bullier
cakier	12	31	1524	2	ca_kier
calker	12	49	1708	2	calk_er
chalkier	17	3	675	2	chalkier
dallier	8	42	1537	2	dallier
flakier	14	39	1020	2	flakier
folkier	14	35	904	2	folkier
gawkier	15	32	652	2	gawkier
hulkier	14	32	897	2	hulkier
lakier	10	47	1627	2	la_kier
lankier	11	37	1163	2	lankier
larkier	11	37	1152	2	larkier
malmier	11	36	1195	2	malmier
maltier	9	30	1548	2	maltier
milkier	13	34	1116	2	milkier
oakier	10	40	1139	2	oa_kier
palier	8	50	2356	2	pal_ier
pallier	9	44	1716	2	pallier
palmier	11	33	1217	2	palmier
pawkier	16	23	661	2	pawkier
rallier	7	38	1627	2	rallier
sallier	7	33	2042	2	sallier
saltier	7	43	1863	2	saltier
sarkier	11	34	1331	2	sarkier
silkier	11	44	1164	2	silkier
stalkier	12	5	707	2	stalkier
sulkier	11	38	1196	2	sulkier
tackier	13	37	1252	2	tackier
talker	10	39	1622	2	talk_er
talkie	10	39	1444	2	talkie_
talkies	11	34	1573	2	talkies
tallier	7	28	1721	2	tallier
wackier	16	36	973	2	wackier
walker	13	39	1399	2	walk_er
yolkier	14	33	612	2	yolkier

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.376	475242.0
2	DLD Change Limit	107671	73	3.216	33479.8
3	Display Results	73	73	0.016	4562.5
	(SQL Overall)	178691	73	3.608	49526.3