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

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

91 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
oakier	10	40	1139	(None)
cakier	12	31	1524	1	cakier
lakier	10	47	1627	1	lakier
babier	10	35	1557	2	babier
baker	11	56	2954	2	bak_er
balkier	13	41	1198	2	balkier
barkier	13	38	1448	2	barkier
beakier	13	40	1216	2	beakier
boskier	13	30	917	2	boskier
brakier	13	38	1236	2	brakier
cagier	9	37	1593	2	cagier
cahier	11	36	1577	2	cahier
coalier	9	34	1617	2	coalier
cockier	15	40	1362	2	cockier
corkier	13	31	1430	2	corkier
croakier	14	43	626	2	croakier
daiker	11	51	1303	2	daiker
dorkier	12	28	1002	2	dorkier
easier	6	42	1846	2	easier
fakeer	13	37	874	2	fakeer
faker	12	48	2459	2	fak_er
fakir	12	51	1149	2	faki_r
flakier	14	39	1020	2	flakier
foamier	12	33	900	2	foamier
folkier	14	35	904	2	folkier
forkier	14	43	1158	2	forkier
gamier	9	36	1793	2	gamier
gawkier	15	32	652	2	gawkier
hazier	18	47	1240	2	hazier
hoarier	10	42	1174	2	hoarier
hokier	13	42	1403	2	hokier
hookier	14	38	1167	2	hookier
ickier	12	43	992	2	ickier
inkier	10	40	1378	2	inkier
jokier	17	61	875	2	jokier
kier	8	65	2680	2	__kier
kookier	10	39	828	2	kookier
lacier	8	40	2009	2	lacier
laker	9	54	3287	2	lak_er
lankier	11	37	1163	2	lankier
larkier	11	37	1152	2	larkier
lazier	15	42	1461	2	lazier
leakier	11	40	1099	2	leakier
loamier	9	34	916	2	loamier
maker	11	41	2781	2	mak_er
matier	8	43	2152	2	matier
mazier	17	50	1306	2	mazier
oaken	9	58	1438	2	oak_en
oakiest	11	29	1392	2	oakiest
oater	5	54	3373	2	oa_ter
ocker	11	39	1575	2	ock_er
oilier	6	44	1723	2	oilier
oozier	15	36	1025	2	oozier
orbier	8	3	999	2	orbier
osier	5	35	1801	2	o_sier
pacier	10	50	1868	2	pacier
palier	8	50	2356	2	palier
panier	8	44	2550	2	panier
pawkier	16	23	661	2	pawkier
peakier	13	44	1144	2	peakier
pockier	15	39	1160	2	pockier
pokier	12	49	1463	2	pokier
porkier	13	37	1234	2	porkier
quakier	20	23	920	2	quakier
racier	8	51	2097	2	racier
raker	9	45	2979	2	rak_er
rapier	8	40	1999	2	rapier
rockier	13	49	1188	2	rockier
rookier	11	40	1238	2	rookier
sagier	7	37	1716	2	sagier
saker	9	51	3202	2	sak_er
sarkier	11	34	1331	2	sarkier
shakier	14	34	1115	2	shakier
skier	9	51	1959	2	_skier
snakier	11	28	1000	2	snakier
soaker	10	57	1753	2	soak_er
soapier	9	34	1171	2	soapier
tackier	13	37	1252	2	tackier
taker	9	52	2900	2	tak_er
talkier	11	40	1184	2	talkier
varier	9	46	1935	2	varier
wackier	16	36	973	2	wackier
waker	12	55	2659	2	wak_er
wanier	9	39	2068	2	wanier
warier	9	37	2289	2	warier
wavier	12	46	1308	2	wavier
waxier	16	43	990	2	waxier
wonkier	14	3	742	2	wonkier
yakker	12	40	553	2	yakker
yolkier	14	33	612	2	yolkier
zanier	15	43	1471	2	zanier

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.190	940478.9
2	DLD Change Limit	82551	91	2.750	30018.5
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	2.970	60165.3