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

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

177 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
rotls	5	56	2016	(None)
roils	5	48	2679	1	roils
rolls	5	53	2623	1	rolls
rotas	5	48	2772	1	rotas
rotes	5	61	4390	1	rotes
rotis	5	63	2705	1	rotis
rotl	4	50	2968	1	rotl_
rotos	5	60	2788	1	rotos
rots	4	64	5409	1	rot_s
boils	7	54	2719	2	boils
bolls	7	55	3131	2	bolls
bolts	7	62	3211	2	bolts
botas	7	53	2878	2	botas
botels	8	48	1580	2	botels
bots	6	64	5395	2	bot_s
botts	7	52	2486	2	botts
bowls	10	61	2143	2	bowls
broils	8	41	1417	2	broils
broths	11	50	1392	2	broths
coals	7	61	2960	2	coals
coils	7	50	3008	2	coils
cols	6	65	5308	2	co_ls
colts	7	66	3329	2	colts
cools	7	56	3263	2	cools
cotes	7	63	4784	2	cotes
cots	6	80	5484	2	cot_s
cowls	10	69	2221	2	cowls
dolls	6	61	2692	2	dolls
dols	5	69	4305	2	do_ls
dolts	6	56	2631	2	dolts
dotes	6	58	3669	2	dotes
dots	5	56	4766	2	dot_s
drolls	7	53	1239	2	drolls
drools	7	44	1281	2	drools
foals	8	57	2169	2	foals
foils	8	50	2581	2	foils
fools	8	68	2420	2	fools
fouls	8	72	2143	2	fouls
fowls	11	55	1889	2	fowls
froths	12	54	1144	2	froths
goals	6	55	2129	2	goals
goths	9	65	1300	2	goths
grots	6	50	2585	2	grot_s
growls	10	47	1111	2	growls
hols	7	69	4629	2	ho_ls
holts	8	56	2791	2	holts
hotels	9	45	1550	2	hotels
hotly	11	58	1547	2	hotly
hots	7	83	4932	2	hot_s
howls	11	62	1922	2	howls
iotas	5	48	2111	2	iotas
jolts	12	50	1888	2	jolts
jotas	12	57	1744	2	jotas
jots	11	63	3614	2	jot_s
jowls	15	62	1452	2	jowls
koels	9	46	1390	2	koels
kohls	12	43	780	2	kohls
kotos	9	57	1769	2	kotos
lolls	5	121	2173	2	lolls
lotas	5	59	2630	2	lotas
lotos	5	47	2463	2	lotos
lots	4	76	5209	2	lot_s
lotus	5	57	1806	2	lotus
moils	7	61	2575	2	moils
molls	7	51	2978	2	molls
mols	6	59	4857	2	mo_ls
molts	7	60	3209	2	molts
mools	7	60	2717	2	mools
motels	8	36	1689	2	motels
motes	7	59	4400	2	motes
moths	10	60	2155	2	moths
mots	6	68	5316	2	mot_s
motts	7	65	2700	2	motts
noels	5	64	1870	2	noels
noils	5	50	2433	2	noils
notes	5	50	3458	2	notes
oils	4	63	3797	2	_oils
oots	4	64	4644	2	oot_s
orals	5	58	2648	2	orals
orts	4	65	3833	2	ort_s
owls	7	60	2293	2	_owls
polls	7	46	2772	2	polls
pols	6	60	4456	2	po_ls
pools	7	44	2770	2	pools
pots	6	64	5236	2	pot_s
protyls	12	29	846	2	protyls
prowls	11	55	1108	2	prowls
rails	5	59	3740	2	rails
ratals	6	42	1958	2	ratals
ratels	6	45	1821	2	ratels
rates	5	53	5201	2	rates
ratos	5	55	2876	2	ratos
rats	4	62	6037	2	rat_s
reals	5	50	3865	2	reals
reels	5	53	3326	2	reels
reoils	6	45	1687	2	reoils
rets	4	53	5256	2	ret_s
rials	5	50	2667	2	rials
riels	5	51	2133	2	riels
rills	5	50	3271	2	rills
riots	5	49	2201	2	riot_s
rites	5	44	4255	2	rites
roads	6	65	2361	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2223	2	roars
robes	7	51	3330	2	robes
roble	7	52	2302	2	roble
robles	8	53	2169	2	robles
robs	6	58	3787	2	ro_bs
rocks	11	46	2641	2	rocks
rocs	6	55	3366	2	ro_cs
rodes	6	140	3908	2	rodes
rods	5	64	4206	2	ro_ds
roes	4	59	5413	2	ro_es
roil	4	62	3529	2	roil_
roily	8	61	2111	2	roily
role	4	58	5182	2	ro_le
roles	5	67	4798	2	roles
rolf	7	51	3487	2	ro_lf
rolfs	8	48	1712	2	rolfs
roll	4	63	3165	2	ro_ll
romps	9	46	1754	2	romps
roms	6	70	3896	2	ro_ms
roods	6	51	2528	2	roods
roofs	8	53	2115	2	roofs
rooks	9	53	2504	2	rooks
rooms	7	53	2468	2	rooms
rootle	6	32	1445	2	rootle
rootles	7	32	1563	2	rootles
roots	5	59	3367	2	roots
ropes	7	59	4006	2	ropes
roses	5	64	4577	2	roses
rot	3	72	8295	2	rot__
rota	4	58	3434	2	rot_a
rotch	10	58	1593	2	rotch
rote	4	62	4902	2	rot_e
roti	4	63	3292	2	rot_i
roto	4	59	3505	2	rot_o
rotor	5	55	1973	2	rotor
rotors	6	49	1793	2	rotors
rotte	5	46	2593	2	rotte
rottes	6	45	2483	2	rottes
roues	5	60	3935	2	roues
roups	7	51	1890	2	roups
routes	6	61	2931	2	routes
rouths	9	54	1682	2	rouths
routs	5	71	3341	2	routs
roves	8	48	3448	2	roves
rowels	9	45	1545	2	rowels
rows	7	59	4175	2	ro_ws
rowths	12	45	817	2	rowths
royals	9	37	1126	2	royals
ruths	8	57	1464	2	ruths
ruts	4	45	4149	2	rut_s
ryots	8	53	1378	2	ryot_s
soils	5	53	2798	2	soils
sols	4	54	4816	2	so_ls
soths	8	62	1862	2	soths
sotols	6	37	1445	2	sotols
sots	4	55	5244	2	sot_s
souls	5	51	2736	2	souls
toils	5	45	2749	2	toils
tolls	5	47	2843	2	tolls
tools	5	53	2524	2	tools
totals	6	31	1516	2	totals
totes	5	51	3968	2	totes
tots	4	66	5412	2	tot_s
trolls	6	46	1394	2	trolls
troths	9	54	1415	2	troths
trots	5	66	2994	2	trot_s
trotyls	10	23	603	2	trotyls
volts	8	54	2129	2	volts
votes	8	46	2708	2	votes
wools	8	44	2146	2	wools
wots	7	63	4289	2	wot_s
yowls	11	57	1543	2	yowls

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	177	1.610	33416.1
3	Display Results	177	177	0.046	3847.8
	(SQL Overall)	178691	177	1.749	102167.5