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

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

98 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
jouked	18	56	815	(None)
jauked	18	48	901	1	jauked
joked	17	52	1791	1	jo_ked
juked	17	57	1407	1	j_uked
bonked	13	55	1731	2	bonked
booked	13	53	1950	2	booked
borked	13	51	1729	2	borked
boused	9	53	2288	2	boused
cocked	15	50	2256	2	cocked
coked	12	47	3069	2	co_ked
conked	13	50	1911	2	conked
cooked	13	59	2136	2	cooked
corked	13	50	2078	2	corked
couped	11	50	1931	2	couped
docked	14	50	1833	2	docked
doused	8	48	2116	2	doused
drouked	13	3	554	2	drouked
duked	11	52	1846	2	_duked
fluked	14	51	1209	2	fluked
forked	14	52	1714	2	forked
fouled	10	43	1597	2	fouled
gouged	9	62	1459	2	gouged
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	ho_ked
holked	14	49	1366	2	holked
honked	14	45	1791	2	honked
hooked	14	53	2055	2	hooked
housed	10	56	2410	2	housed
howked	17	73	1234	2	howked
jacked	20	48	1752	2	jacked
jauped	16	45	790	2	jauped
jerked	18	47	959	2	jerked
jinked	18	40	1314	2	jinked
jobbed	18	42	1213	2	jobbed
jockey	22	40	803	2	jockey
jogged	16	60	1592	2	jogged
joined	14	46	1307	2	joined
joke	15	59	2616	2	jo_ke_
joker	16	57	1589	2	jo_ker
jokes	16	54	2333	2	jo_kes
jokey	19	50	1469	2	jo_key
jolted	14	35	1063	2	jolted
joshed	17	46	1090	2	joshed
jotted	14	36	1517	2	jotted
jouk	15	60	1599	2	jouk__
jouks	16	56	1234	2	jouk_s
joule	12	49	1820	2	joule_
joules	13	41	1682	2	joules
jounced	17	33	761	2	jounced
jousted	15	33	914	2	jousted
jowed	16	47	2442	2	jo_wed
jowled	17	42	1079	2	jowled
joyed	16	48	1183	2	jo_yed
juke	15	47	2166	2	j_uke_
jukes	16	53	1910	2	j_ukes
junked	18	43	1169	2	junked
konked	10	40	1058	2	konked
locked	13	49	2166	2	locked
looked	11	47	1707	2	looked
louped	9	53	1638	2	louped
loured	7	46	1740	2	loured
loused	7	48	2291	2	loused
louted	7	49	2069	2	louted
mocked	15	47	1661	2	mocked
moused	9	44	2330	2	moused
nocked	13	46	1738	2	nocked
nuked	10	40	1418	2	_nuked
outed	6	54	2906	2	_outed
pocked	15	48	1898	2	pocked
poked	12	54	2539	2	po_ked
porked	13	47	1762	2	porked
poufed	12	44	971	2	poufed
poured	9	51	1674	2	poured
pouted	9	40	2139	2	pouted
puked	12	47	1622	2	_puked
rocked	13	50	2232	2	rocked
rooked	11	49	1814	2	rooked
rouged	8	67	1732	2	rouged
rouped	9	57	1735	2	rouped
roused	7	54	2644	2	roused
routed	7	56	2433	2	routed
soaked	11	47	1759	2	soaked
socked	13	47	2150	2	socked
souled	7	54	1982	2	souled
souped	9	50	1767	2	souped
soured	7	49	2186	2	soured
soused	7	48	2298	2	soused
toked	10	56	2649	2	to_ked
toured	7	42	1615	2	toured
toused	7	41	2201	2	toused
touted	7	44	1974	2	touted
wauked	14	42	1057	2	wauked
worked	14	53	1470	2	worked
yeuked	14	45	623	2	yeuked
yocked	16	41	1442	2	yocked
yoked	13	48	2162	2	yo_ked
yolked	14	36	715	2	yolked
zonked	20	42	947	2	zonked

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	82551	0.156	1145455.1
2	DLD Change Limit	82551	98	4.546	18159.0
3	Display Results	98	98	0.063	1555.6
	(SQL Overall)	178691	98	4.765	37500.7