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

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

76 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
jokier	17	61	875	(None)
hokier	13	42	1403	1	hokier
joker	16	57	1589	1	jok_er
pokier	12	49	1463	1	pokier
bonier	8	43	2199	2	bonier
boskier	13	30	917	2	boskier
boxier	15	43	1174	2	boxier
cakier	12	31	1524	2	cakier
chokier	16	3	804	2	chokier
cockier	15	40	1362	2	cockier
copier	10	37	2289	2	copier
corkier	13	31	1430	2	corkier
cosier	8	44	2375	2	cosier
cowier	11	36	1616	2	cowier
cozier	17	33	1514	2	cozier
dopier	9	35	1592	2	dopier
dorkier	12	28	1002	2	dorkier
dotier	7	39	1703	2	dotier
dozier	16	36	1163	2	dozier
folkier	14	35	904	2	folkier
forkier	14	43	1158	2	forkier
foxier	16	39	1003	2	foxier
fozier	18	37	1066	2	fozier
gooier	7	35	1621	2	gooier
gorier	7	37	1937	2	gorier
holier	9	49	2162	2	holier
homier	11	64	1699	2	homier
hookier	14	38	1167	2	hookier
hosier	9	42	1961	2	hosier
ickier	12	43	992	2	ickier
inkier	10	40	1378	2	inkier
jerkier	18	40	727	2	jerkier
jivier	16	43	861	2	jivier
jobber	17	38	1335	2	jobber
jogger	15	47	1316	2	jogger
joiner	13	41	1413	2	joiner
joke	15	59	2616	2	jok_e_
joked	17	52	1791	2	jok_ed
jokers	17	55	1119	2	jok_ers
jokes	16	54	2333	2	jok_es
jokey	19	50	1469	2	jok_ey
jokiest	18	37	919	2	jokiest
jokily	20	30	653	2	jokily
joking	18	41	1302	2	joking
jollier	14	29	1100	2	jollier
jolter	13	35	1309	2	jolter
joltier	14	31	849	2	joltier
josher	16	43	1296	2	josher
jotter	13	43	1563	2	jotter
jowlier	17	32	756	2	jowlier
junkier	18	33	949	2	junkier
kier	8	65	2680	2	__kier
kookier	10	39	828	2	kookier
lakier	10	47	1627	2	lakier
logier	7	50	1573	2	logier
mopier	10	39	1478	2	mopier
nosier	6	37	1632	2	nosier
oakier	10	40	1139	2	oakier
oozier	15	36	1025	2	oozier
osier	5	35	1801	2	_osier
pockier	15	39	1160	2	pockier
poker	11	51	2288	2	pok_er
pokies	12	59	2133	2	pokies
porkier	13	37	1234	2	porkier
poxier	15	38	1211	2	poxier
rockier	13	49	1188	2	rockier
rookier	11	40	1238	2	rookier
ropier	8	41	1880	2	ropier
rosier	6	42	2126	2	rosier
skier	9	51	1959	2	_skier
smokier	13	5	670	2	smokier
toker	9	59	2491	2	tok_er
tonier	6	55	2071	2	tonier
wonkier	14	3	742	2	wonkier
yolkier	14	33	612	2	yolkier
zooier	15	34	1123	2	zooier

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.123	1452772.4
2	DLD Change Limit	82551	76	2.313	35690.0
3	Display Results	76	76	0.016	4750.0
	(SQL Overall)	178691	76	2.452	72875.6