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

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

127 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
blaring	10	43	1711	(None)
baring	9	51	3585	1	b_aring
bearing	10	36	2477	1	bearing
blading	11	36	1536	1	blading
blaming	12	35	1569	1	blaming
blawing	13	40	1275	1	blawing
blazing	19	36	1239	1	blazing
blearing	11	31	1194	1	blearing
flaring	11	41	1680	1	flaring
glaring	9	37	1488	1	glaring
ablating	11	3	1199	2	ablating
alarming	11	3	858	2	alarming
baaing	9	49	1616	2	b_aaing
baking	13	56	2662	2	b_aking
balding	11	40	1506	2	balding
baling	9	48	2969	2	b_aling
balking	14	37	1735	2	balking
balling	10	44	2476	2	balling
baning	9	51	2783	2	b_aning
barbing	12	37	1699	2	b_arbing
barding	11	38	2289	2	b_arding
barfing	13	46	1509	2	b_arfing
barging	11	40	1848	2	b_arging
barking	14	47	2418	2	b_arking
barning	10	43	2035	2	b_arning
barong	9	60	1582	2	b_arong
barring	10	40	2159	2	barring
basing	9	54	2766	2	b_asing
bating	9	51	3225	2	b_ating
baying	12	52	2258	2	b_aying
beading	11	32	2186	2	beading
beaming	12	36	1880	2	beaming
beaning	10	38	2068	2	beaning
bearding	12	40	1194	2	bearding
bearings	11	39	1225	2	bearings
beating	10	43	2687	2	beating
belaying	14	31	1060	2	belaying
bewaring	14	27	949	2	bewaring
biasing	10	35	1245	2	biasing
birring	10	37	1306	2	birring
blabbing	12	26	672	2	blabbing
blacking	17	42	1360	2	blacking
bladings	12	33	775	2	bladings
blagging	13	31	916	2	blagging
blain	7	54	2179	2	bla_in_
blains	8	45	1637	2	bla_ins
blanking	15	44	1193	2	blanking
blasting	11	40	1343	2	blasting
blatting	11	41	1165	2	blatting
bleating	11	35	1450	2	bleating
bloating	11	35	1281	2	bloating
blowing	13	38	1305	2	blowing
blueing	10	37	1020	2	blueing
bluing	9	49	1448	2	bl_uing
bluming	12	35	1128	2	bluming
blurbing	13	32	650	2	blurbing
blurring	11	27	723	2	blurring
blurting	11	25	877	2	blurting
boarding	12	31	1023	2	boarding
boating	10	37	2130	2	boating
boring	9	47	2487	2	b_oring
bracing	12	38	1761	2	bracing
braking	14	39	1771	2	braking
braving	13	37	1461	2	braving
braying	13	44	1631	2	braying
brazing	19	37	1511	2	brazing
bring	8	55	2850	2	b__ring
bullring	11	38	842	2	bullring
burring	10	40	1699	2	burring
caring	9	51	3799	2	_caring
charing	13	37	2132	2	charing
clawing	13	38	1267	2	clawing
claying	13	36	1430	2	claying
clearing	11	30	1488	2	clearing
daring	8	49	2868	2	_daring
earing	7	52	3548	2	_earing
elating	8	34	2308	2	elating
faring	10	52	3128	2	_faring
fearing	11	35	2003	2	fearing
flaking	15	41	1449	2	flaking
flaming	13	42	1644	2	flaming
flawing	14	38	1256	2	flawing
flaying	14	39	1446	2	flaying
gearing	9	28	1884	2	gearing
glairing	10	4	728	2	glairing
glazing	18	36	1100	2	glazing
haring	10	42	3300	2	_haring
hearing	11	33	2416	2	hearing
lacing	9	46	2623	2	_lacing
lading	8	42	2712	2	_lading
lairing	8	37	1534	2	_lairing
laking	11	50	2704	2	_laking
laming	9	45	2836	2	_laming
larding	9	29	1787	2	_larding
larine	6	39	2704	2	_larine
larking	12	37	1825	2	_larking
lasing	7	47	2798	2	_lasing
laving	10	46	2357	2	_laving
lawing	10	46	2528	2	_lawing
laying	10	45	2570	2	_laying
lazing	16	48	2147	2	_lazing
luring	7	38	2075	2	_luring
nearing	8	30	2033	2	nearing
oaring	7	42	2530	2	_oaring
paring	9	42	3649	2	_paring
placing	12	38	1528	2	placing
planing	10	34	1825	2	planing
plating	10	38	2307	2	plating
playing	13	38	1609	2	playing
raring	7	43	3287	2	_raring
rearing	8	31	2878	2	rearing
roaring	8	29	1600	2	roaring
scaring	10	34	2197	2	scaring
searing	8	33	3092	2	searing
sharing	11	37	2324	2	sharing
slaking	12	37	1747	2	slaking
slating	8	37	2465	2	slating
slaving	11	35	1483	2	slaving
slaying	11	33	1684	2	slaying
snaring	8	39	2095	2	snaring
soaring	8	35	2189	2	soaring
sparing	10	48	2387	2	sparing
staring	8	45	2705	2	staring
taring	7	39	3228	2	_taring
tearing	8	40	2149	2	tearing
waring	10	50	2944	2	_waring
wearing	11	33	1886	2	wearing

Search took 4 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.360	496363.9
2	DLD Change Limit	107671	127	2.843	37872.3
3	Display Results	127	127	0.046	2760.9
	(SQL Overall)	178691	127	3.249	54998.8