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

Here are the results of your fuzzy-string dictionary search for “joules” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
joules	13	41	1682	(None)
boules	8	49	2597	1	boules
joles	12	52	3083	1	jo_les
joule	12	49	1820	1	joule_
bogles	9	50	2083	2	bogles
boles	7	54	4860	2	bo_les
boucles	11	31	1300	2	boucles
boule	7	48	2804	2	boule_
boulles	9	31	1412	2	boulles
bouses	8	49	3178	2	bouses
caules	8	59	2725	2	caules
cobles	10	46	2288	2	cobles
coles	7	60	5506	2	co_les
coulee	8	3	2350	2	coulee
coulees	9	3	1550	2	coulees
coulis	8	40	1875	2	coulis
coupes	10	50	2252	2	coupes
couples	11	53	1705	2	couples
doles	6	78	4375	2	do_les
doubles	10	31	1335	2	doubles
doulas	7	51	1499	2	doulas
douses	7	49	2893	2	douses
folles	9	38	2047	2	folles
fouled	10	43	1597	2	fouled
fouler	9	36	1490	2	fouler
foulest	10	3	1331	2	foulest
fouls	8	72	2143	2	foul_s
gouges	8	63	1869	2	gouges
gules	6	48	3104	2	_gules
holes	8	47	4865	2	ho_les
houses	9	60	3227	2	houses
hoyles	12	3	1501	2	hoyles
jobless	16	23	756	2	jobless
joes	11	66	3589	2	jo__es
joggles	16	44	1041	2	joggles
jokes	16	54	2333	2	jo_kes
jole	11	72	3382	2	jo_le_
jollies	14	35	1627	2	jollies
jolts	12	50	1888	2	jo_lts
jones	12	50	2818	2	jo_nes
joshes	16	51	1485	2	joshes
josses	13	51	1768	2	josses
jostles	14	34	1114	2	jostles
jouals	13	3	892	2	jouals
jouked	18	56	815	2	jouked
jouks	16	56	1234	2	jou_ks
jounces	16	36	985	2	jounces
jousts	13	50	1127	2	jousts
jowled	17	42	1079	2	jowled
jowls	15	62	1452	2	jowl_s
joyless	17	22	651	2	joyless
jubes	14	54	2074	2	j_ubes
jukes	16	53	1910	2	j_ukes
julep	14	3	1053	2	j_ulep
juleps	15	3	562	2	j_uleps
jupes	14	52	1855	2	j_upes
jutes	12	51	2513	2	j_utes
lobules	9	25	1081	2	lobules
locules	9	28	1260	2	locules
louies	6	45	2510	2	louies
loupes	8	49	1805	2	loupes
louses	6	62	3028	2	louses
modules	10	25	1100	2	modules
moles	7	47	4792	2	mo_les
moues	7	57	3284	2	mou_es
moulds	9	49	1099	2	moulds
moults	8	47	1370	2	moults
mouses	8	55	3142	2	mouses
mules	7	50	3429	2	_mules
nobles	8	33	1972	2	nobles
nodules	8	26	970	2	nodules
nouses	6	46	2716	2	nouses
ogles	6	52	2318	2	_ogles
oles	4	64	5347	2	_o_les
oodles	7	35	1718	2	oodles
orles	5	53	2621	2	_orles
ovules	9	3	822	2	ovules
poles	7	53	5100	2	po_les
poults	8	46	1348	2	poults
pules	7	45	3881	2	_pules
robles	8	53	2169	2	robles
roles	5	67	4798	2	ro_les
roubles	9	34	1350	2	roubles
roues	5	60	3935	2	rou_es
rouges	7	60	2238	2	rouges
rouses	6	54	3628	2	rouses
routes	6	61	2931	2	routes
rules	5	52	3425	2	_rules
socles	8	4	1845	2	socles
soles	5	55	4792	2	so_les
souled	7	54	1982	2	souled
souls	5	51	2736	2	soul_s
souses	6	42	2924	2	souses
toiles	6	39	2351	2	toiles
toles	5	51	4713	2	to_les
touses	6	42	2967	2	touses
tousles	7	41	1393	2	tousles
touzles	16	35	922	2	touzles
tules	5	45	3279	2	_tules
voiles	9	46	1644	2	voiles
voles	8	62	3404	2	vo_les
yodles	10	37	1433	2	yodles
yules	8	45	2158	2	_yules
zonules	16	4	779	2	zonules

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.106	1685764.2
2	DLD Change Limit	82551	104	2.470	33421.5
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	2.606	68569.1