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

Here are the results of your fuzzy-string dictionary search for “rowels” 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
rowels	9	45	1545	(None)
bowels	11	43	1559	1	bowels
dowels	10	48	1334	1	dowels
rowel	8	47	2141	1	rowel_
rowens	9	45	1530	1	rowens
rowers	9	49	2457	1	rowers
towels	9	43	1464	1	towels
trowels	10	35	836	1	trowels
vowels	12	44	1048	1	vowels
botels	8	48	1580	2	botels
bowel	10	56	2120	2	bowel_
bowers	11	55	2370	2	bowers
bowls	10	61	2143	2	bow_ls
cowers	11	46	2553	2	cowers
cowls	10	69	2221	2	cow_ls
crewels	12	43	848	2	crewels
crowers	12	46	1489	2	crowers
dowel	9	56	1819	2	dowel_
dowers	10	45	2329	2	dowers
fowls	11	55	1889	2	fow_ls
grovels	11	42	781	2	grovels
growers	11	36	1272	2	growers
growls	10	47	1111	2	grow_ls
hosels	9	42	1860	2	hosels
hotels	9	45	1551	2	hotels
hovels	12	54	1333	2	hovels
howes	11	47	3026	2	howe_s
howls	11	62	1922	2	how_ls
jewels	16	50	861	2	jewels
jowls	15	62	1452	2	jow_ls
koels	9	46	1390	2	ko_els
losels	6	47	1458	2	losels
lowers	9	46	2492	2	lowers
lowes	8	57	3246	2	lowe_s
models	9	42	1635	2	models
mohels	11	50	1132	2	mohels
morels	8	48	2001	2	morels
motels	8	36	1689	2	motels
mowers	11	32	1940	2	mowers
newels	9	37	1082	2	newels
noels	5	64	1870	2	no_els
novels	9	55	1250	2	novels
oriels	6	49	1462	2	oriels
owes	7	51	3710	2	_owe_s
owls	7	60	2293	2	_ow_ls
powers	11	38	2232	2	powers
propels	11	34	1284	2	propels
prowess	12	3	790	2	prowess
prowls	11	55	1108	2	prow_ls
ratels	6	45	1821	2	ratels
ravels	9	47	1707	2	ravels
rebels	8	45	1813	2	rebels
reels	5	53	3326	2	r_eels
refels	9	46	1805	2	refels
repels	8	43	1876	2	repels
revels	9	42	2057	2	revels
reweds	10	44	1230	2	reweds
reweld	10	37	1111	2	reweld
rewelds	11	45	741	2	rewelds
rewets	9	46	1721	2	rewets
riels	5	51	2133	2	r_iels
robes	7	51	3330	2	robe_s
robles	8	53	2169	2	robles
rodeos	7	53	1450	2	rodeos
rodes	6	140	3908	2	rode_s
roes	4	59	5414	2	ro_e_s
rogers	7	45	1791	2	rogers
roils	5	48	2679	2	ro_ils
roles	5	67	4798	2	role_s
rolls	5	53	2623	2	ro_lls
romeos	8	40	1317	2	romeos
rondels	8	25	1005	2	rondels
ronnels	7	31	861	2	ronnels
ropers	8	43	2590	2	ropers
ropes	7	59	4006	2	rope_s
roses	5	64	4577	2	rose_s
rosets	6	58	1995	2	rosets
rotes	5	61	4390	2	rote_s
rotls	5	56	2016	2	ro_tls
rouens	6	48	1444	2	rouens
roues	5	60	3935	2	roue_s
rovers	9	54	2352	2	rovers
roves	8	48	3448	2	rove_s
rowans	9	57	1534	2	rowans
rowed	9	40	3432	2	rowe_d
roweled	11	26	986	2	roweled
rowen	8	49	2115	2	rowe_n
rower	8	54	3049	2	rowe_r
rows	7	59	4175	2	row__s
rowths	12	45	817	2	rowths
royals	9	37	1126	2	royals
rubels	8	41	1299	2	rubels
sorels	6	39	2116	2	sorels
sowens	9	36	1315	2	sowens
sowers	9	49	2344	2	sowers
towel	8	49	2052	2	towel_
towers	9	44	2367	2	towers
trowel	9	42	1146	2	trowel_
vowel	11	55	1501	2	vowel_
vowers	12	43	1718	2	vowers
yodels	10	46	1007	2	yodels
yokels	13	48	806	2	yokels
yowes	11	49	2637	2	yowe_s
yowls	11	57	1543	2	yow_ls

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.126	1418182.5
2	DLD Change Limit	82551	104	2.310	35736.4
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	2.466	72461.9