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

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

111 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
bilging	11	42	1268	(None)
bigging	12	28	1588	1	bigging
bilking	14	44	1355	1	bilking
billing	10	38	2385	1	billing
binging	11	36	1938	1	binging
bulging	11	35	1421	1	bulging
ailing	7	43	3101	2	ail_ing
badging	12	37	1279	2	badging
bagging	12	33	1698	2	bagging
bailing	10	37	2352	2	bail_ing
balding	11	40	1506	2	balding
baling	9	48	2969	2	bal_ing
balking	14	37	1735	2	balking
balling	10	44	2476	2	balling
banging	11	40	1986	2	banging
barging	11	40	1848	2	barging
begging	12	30	1265	2	begging
belling	10	38	2507	2	belling
belting	10	41	1913	2	belting
belying	13	36	1244	2	belying
biasing	10	35	1245	2	biasing
bibbing	11	29	961	2	bibbing
bidding	12	36	1351	2	bidding
biding	10	47	2079	2	bi_ding
bielding	12	23	747	2	bielding
biffing	16	35	1001	2	biffing
biggin	10	37	1060	2	biggin_
biggings	13	32	747	2	biggings
biggins	11	34	1069	2	biggins
biking	13	50	1817	2	bi_king
bilgier	10	35	853	2	bilgier
billings	11	34	1263	2	billings
biltong	10	3	468	2	biltong
binding	11	38	1938	2	binding
bingeing	12	23	764	2	bingeing
binning	10	36	1545	2	binning
birding	11	40	1492	2	birding
birling	10	43	1705	2	birling
birring	10	37	1306	2	birring
biting	9	53	2182	2	bi_ting
bitting	10	37	1729	2	bitting
bluing	9	49	1448	2	b_luing
bogging	12	36	1575	2	bogging
boiling	10	38	1967	2	boil_ing
bolling	10	38	2088	2	bolling
bolting	10	44	1676	2	bolting
bonging	11	33	1637	2	bonging
bridging	13	28	844	2	bridging
bringing	12	30	1127	2	bringing
budging	12	43	1302	2	budging
bugging	12	35	1518	2	bugging
bugling	11	36	1534	2	bugling
building	12	3	750	2	building
bulking	14	38	1512	2	bulking
bulling	10	43	2479	2	bulling
bunging	11	36	1650	2	bunging
digging	11	35	1370	2	digging
dinging	10	36	1861	2	dinging
fidging	13	39	1050	2	fidging
figging	13	33	1356	2	figging
filing	10	38	2376	2	fil_ing
filling	11	35	2080	2	filling
filming	13	32	1035	2	filming
gigging	9	33	1177	2	gigging
gilding	10	38	1300	2	gilding
gilling	9	35	2038	2	gilling
hilding	12	37	1353	2	hilding
hilling	11	38	2177	2	hilling
hilting	11	33	1689	2	hilting
hinging	12	39	1712	2	hinging
igging	9	32	1207	2	_igging
jigging	17	30	1155	2	jigging
jilting	15	32	1174	2	jilting
killing	12	31	1872	2	killing
kilning	12	28	902	2	kilning
kilting	12	32	1385	2	kilting
kinging	13	31	1503	2	kinging
lilting	8	35	1538	2	lilting
milding	11	36	1545	2	milding
milking	14	37	1276	2	milking
milling	10	32	2368	2	milling
milting	10	36	1912	2	milting
nilling	8	36	1956	2	nilling
obliging	12	3	610	2	obliging
oiling	7	49	2531	2	oil_ing
pigging	12	36	1467	2	pigging
piling	9	50	2559	2	pil_ing
pilling	10	37	2256	2	pilling
pinging	11	34	1955	2	pinging
ridging	10	41	1298	2	ridging
rigging	10	30	1633	2	rigging
riling	7	42	2797	2	ril_ing
rilling	8	40	2362	2	rilling
ringing	9	35	2128	2	ringing
sieging	9	26	1320	2	sieging
silking	12	37	1559	2	silking
siloing	8	32	1550	2	siloing
silting	8	33	2048	2	silting
singing	9	32	2142	2	singing
tiling	7	34	2655	2	til_ing
tilling	8	35	2278	2	tilling
tilting	8	34	1710	2	tilting
tinging	9	36	1946	2	tinging
wigging	13	34	1383	2	wigging
wilding	12	38	1429	2	wilding
wiling	10	30	2429	2	wil_ing
willing	11	38	2161	2	willing
wilting	11	35	1591	2	wilting
winging	12	37	1871	2	winging
zigging	19	32	1053	2	zigging
zinging	18	35	1394	2	zinging

Search took 8 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.763	234195.3
2	DLD Change Limit	107671	111	6.813	15803.8
3	Display Results	111	111	0.076	1460.5
	(SQL Overall)	178691	111	7.652	23352.2