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

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

112 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
roaring	8	29	1600	(None)
oaring	7	42	2530	1	_oaring
raring	7	43	3287	1	r_aring
rearing	8	31	2878	1	rearing
roaming	10	32	1579	1	roaming
roarings	9	24	829	1	roarings
soaring	8	35	2189	1	soaring
baring	9	51	3585	2	_baring
bearing	10	36	2477	2	bearing
blaring	10	43	1711	2	blaring
boarding	12	31	1023	2	boarding
boating	10	37	2130	2	boating
boring	9	47	2487	2	bo_ring
caring	9	51	3799	2	_caring
charing	13	37	2132	2	charing
coaling	10	37	2282	2	coaling
coaming	12	38	1832	2	coaming
coating	10	35	2531	2	coating
coaxing	17	35	1170	2	coaxing
coring	9	44	3396	2	co_ring
croaking	15	37	1216	2	croaking
daring	8	49	2868	2	_daring
doating	9	38	1686	2	doating
earing	7	52	3548	2	_earing
faring	10	52	3128	2	_faring
fearing	11	35	2003	2	fearing
flaring	11	41	1680	2	flaring
foaling	11	35	1584	2	foaling
foaming	13	36	1299	2	foaming
gearing	9	28	1884	2	gearing
glaring	9	37	1488	2	glaring
goading	10	31	1285	2	goading
goaling	9	35	1533	2	goaling
goring	8	41	1957	2	go_ring
groaning	10	24	1028	2	groaning
haring	10	42	3300	2	_haring
hearing	11	33	2416	2	hearing
hoarding	13	28	864	2	hoarding
hoaxing	18	30	776	2	hoaxing
loading	9	41	1461	2	loading
loafing	11	31	979	2	loafing
loaming	10	36	1373	2	loaming
loaning	8	36	1483	2	loaning
louring	8	39	1650	2	louring
moaning	10	37	1444	2	moaning
moating	10	42	1815	2	moating
mooring	10	25	1444	2	mooring
nearing	8	30	2033	2	nearing
orating	8	35	2032	2	orating
paring	9	42	3649	2	_paring
poring	9	42	2727	2	po_ring
pouring	10	31	1586	2	pouring
racing	9	50	3053	2	r_acing
raging	8	51	2643	2	r_aging
raking	11	47	2842	2	r_aking
raping	9	48	2985	2	r_aping
rasing	7	43	3083	2	r_asing
rating	7	49	3870	2	r_ating
raving	10	51	2885	2	r_aving
raxing	14	43	2102	2	r_axing
raying	10	50	2719	2	r_aying
razing	16	45	2454	2	r_azing
reading	9	33	2721	2	reading
reaming	10	39	2401	2	reaming
reaping	10	36	2121	2	reaping
rearming	11	14	1361	2	rearming
reaving	11	38	2053	2	reaving
roaching	14	32	1043	2	roaching
roaringly	13	3	645	2	roaringly
roasting	9	30	1269	2	roasting
robbing	12	33	1321	2	robbing
robing	9	36	1800	2	ro_bing
rocking	14	36	1963	2	rocking
rodding	10	38	1453	2	rodding
rogering	10	3	1027	2	rogering
roguing	9	30	956	2	roguing
roiling	8	32	2045	2	roiling
rolfing	11	37	1065	2	rolfing
rolling	8	36	2041	2	rolling
romping	12	31	1303	2	romping
roofing	11	38	1435	2	roofing
rooking	12	35	1736	2	rooking
rooming	10	41	1704	2	rooming
roosing	8	40	1813	2	roosing
rooting	8	35	2243	2	rooting
roping	9	40	2302	2	ro_ping
rosing	7	39	2559	2	ro_sing
rotating	9	26	1455	2	rotating
rotting	8	29	1968	2	rotting
rouging	9	31	1470	2	rouging
rouping	10	37	1579	2	rouping
rousing	8	39	2055	2	rousing
routing	8	38	2109	2	routing
roving	10	36	1874	2	ro_ving
rowing	10	36	2330	2	ro_wing
scaring	10	34	2197	2	scaring
searing	8	33	3092	2	searing
sharing	11	37	2324	2	sharing
snaring	8	39	2095	2	snaring
soaking	12	31	1661	2	soaking
soaping	10	36	1622	2	soaping
soarings	9	32	1039	2	soarings
soring	7	47	3188	2	so_ring
souring	8	32	1906	2	souring
sparing	10	48	2387	2	sparing
staring	8	45	2705	2	staring
taring	7	39	3228	2	_taring
tearing	8	40	2149	2	tearing
touring	8	29	1519	2	touring
troaking	13	33	1097	2	troaking
waring	10	50	2944	2	_waring
wearing	11	33	1886	2	wearing

Search took 6 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	107671	0.123	1452772.4
2	DLD Change Limit	107671	112	5.140	20947.7
3	Display Results	112	112	0.080	1400.0
	(SQL Overall)	178691	112	5.343	33443.9