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

Here are the results of your fuzzy-string dictionary search for “rawly” 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
rawly	11	51	1583	(None)
brawly	14	43	1235	1	brawly
crawly	14	46	1076	1	crawly
drawly	13	49	1072	1	drawly
rally	8	47	2590	1	rally
ably	9	97	2513	2	_ably
agly	8	68	2180	2	_agly
ally	7	69	3564	2	_ally
away	10	80	2422	2	_away
awl	6	76	3530	2	_awl_
awls	7	59	2609	2	_awls
awny	10	59	1930	2	_awny
awry	10	76	1968	2	_awry
badly	11	49	1876	2	badly
bally	10	55	3010	2	bally
bawdy	14	75	1328	2	bawdy
bawl	9	53	2606	2	bawl_
bawls	10	57	1932	2	bawls
bawty	13	56	1410	2	bawty
brawl	10	62	1796	2	brawl_
brawls	11	52	1433	2	brawls
brawny	14	47	1060	2	brawny
crawl	10	49	1671	2	crawl_
crawls	11	47	1208	2	crawls
daily	9	59	2233	2	daily
dally	9	53	2474	2	dally
drably	12	35	1161	2	drably
drawl	9	55	1601	2	drawl_
drawls	10	55	1139	2	drawls
early	8	53	2412	2	early
fatly	11	57	1680	2	fatly
fawny	14	47	1171	2	fawny
gaily	9	50	2097	2	gaily
gally	9	50	2617	2	gally
gawky	16	56	999	2	gawky
gawsy	12	45	909	2	gawsy
gayly	12	45	1309	2	gayly
grayly	13	28	796	2	grayly
growly	13	49	917	2	growly
haply	13	59	1506	2	haply
jowly	18	64	1090	2	jowly
lawny	11	59	1201	2	lawny
laxly	15	6	1010	2	laxly
lowly	11	41	1333	2	lowly
madly	11	52	1813	2	madly
manly	10	50	2295	2	manly
marly	10	69	2561	2	marly
newly	11	46	1020	2	newly
orally	9	31	1359	2	orally
pally	10	57	2712	2	pally
paly	9	58	3553	2	pa_ly
patly	10	50	2058	2	patly
pawky	17	38	1015	2	pawky
pawl	9	51	2326	2	pawl_
pawls	10	56	1766	2	pawls
racily	11	7	1517	2	racily
racy	9	58	2568	2	ra_cy
raggy	10	61	1657	2	raggy
rail	4	61	4776	2	rail_
rails	5	59	3740	2	rails
rainy	8	59	2108	2	rainy
rale	4	50	5056	2	ra_le
rallye	9	51	1016	2	rallye
rammy	12	43	1249	2	rammy
randy	9	50	2208	2	randy
rangy	9	53	2038	2	rangy
rankly	13	39	1045	2	rankly
raptly	11	33	891	2	raptly
rarely	9	35	1365	2	rarely
rashly	12	34	1021	2	rashly
raspy	10	65	1170	2	raspy
rattly	9	41	1154	2	rattly
ratty	8	48	1959	2	ratty
raw	6	72	5225	2	raw__
rawer	8	46	2373	2	rawer
rawin	8	55	2147	2	rawin
raws	7	52	3821	2	raw_s
ray	6	63	6199	2	ra__y
really	9	33	1561	2	really
redly	9	42	1720	2	redly
refly	11	39	1456	2	refly
rely	7	54	2895	2	r_ely
reply	10	40	1585	2	reply
roily	8	61	2111	2	roily
rowdy	12	57	1153	2	rowdy
ruly	7	63	2314	2	r_uly
sadly	9	45	1912	2	sadly
sally	8	51	2971	2	sally
sawfly	15	3	513	2	sawfly
scrawly	15	19	719	2	scrawly
sprawly	15	16	604	2	sprawly
tally	8	45	2686	2	tally
tawny	11	47	1365	2	tawny
trawl	8	49	1587	2	trawl_
trawley	13	31	730	2	trawley
trawls	9	44	1239	2	trawls
wally	11	46	2509	2	wally
waly	10	58	3090	2	wa_ly
wanly	11	51	1802	2	wanly
wawl	10	53	2194	2	wawl_
wawls	11	54	1647	2	wawls
yawey	14	45	827	2	yawey
yawl	10	49	1897	2	yawl_
yawls	11	46	1360	2	yawls

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.313	570897.8
2	DLD Change Limit	53800	104	1.483	36277.8
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	1.826	97859.3