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

Here are the results of your fuzzy-string dictionary search for “bulging” 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
bulging	11	35	1421	(None)
bilging	11	42	1268	1	bilging
budging	12	43	1302	1	budging
bugging	12	35	1518	1	bugging
bugling	11	36	1534	1	bugling
bulking	14	38	1512	1	bulking
bulling	10	43	2479	1	bulling
bunging	11	36	1650	1	bunging
badging	12	37	1279	2	badging
bagging	12	33	1698	2	bagging
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
baulking	15	3	600	2	baulking
begging	12	30	1265	2	begging
belling	10	38	2507	2	belling
belting	10	41	1913	2	belting
belying	13	36	1244	2	belying
bigging	12	28	1588	2	bigging
bilking	14	44	1355	2	bilking
billing	10	38	2385	2	billing
binging	11	36	1938	2	binging
bludging	13	29	746	2	bludging
blueing	10	37	1020	2	blueing
bluing	9	49	1448	2	b_luing
bluming	12	35	1128	2	bluming
blunging	12	32	841	2	blunging
bogging	12	36	1575	2	bogging
bolling	10	38	2088	2	bolling
bolting	10	44	1676	2	bolting
bonging	11	33	1637	2	bonging
bucking	16	36	1757	2	bucking
budding	12	37	1240	2	budding
buffing	16	34	1139	2	buffing
building	12	3	750	2	building
bulgier	10	39	1121	2	bulgier
bulgingly	16	4	443	2	bulgingly
bullring	11	38	842	2	bullring
bullying	14	32	929	2	bullying
bumming	14	34	1078	2	bumming
bumping	14	38	1249	2	bumping
bungling	12	26	954	2	bungling
bunking	14	40	1619	2	bunking
bunting	10	37	1883	2	bunting
buoying	13	37	995	2	buoying
burgling	12	23	930	2	burgling
burking	14	37	1632	2	burking
burling	10	44	2113	2	burling
burning	10	42	1550	2	burning
burping	12	40	1294	2	burping
burring	10	40	1699	2	burring
burying	13	34	1391	2	burying
bushing	13	40	1858	2	bushing
busing	9	64	2059	2	bu_sing
busking	14	41	1657	2	busking
bussing	10	36	1462	2	bussing
busting	10	42	2179	2	busting
busying	13	42	1199	2	busying
butling	10	35	1681	2	butling
butting	10	35	1928	2	butting
buying	12	42	1383	2	bu_ying
buzzing	18	18	654	2	buzzing
culling	10	39	2130	2	culling
culming	12	38	1118	2	culming
dulling	9	34	1827	2	dulling
dunging	10	30	1262	2	dunging
fudging	13	33	1001	2	fudging
fugging	13	39	1291	2	fugging
fugling	12	42	1251	2	fugling
fulling	11	40	1970	2	fulling
gulfing	12	33	947	2	gulfing
gulling	9	40	1956	2	gulling
gulping	11	30	975	2	gulping
gurging	10	29	1011	2	gurging
hugging	13	27	1063	2	hugging
hulking	15	39	1098	2	hulking
hulling	11	36	1901	2	hulling
judging	17	33	793	2	judging
jugging	17	29	1072	2	jugging
kluging	13	35	659	2	kluging
lugging	10	41	1435	2	lugging
luging	8	39	1529	2	lu_ging
lulling	8	36	1680	2	lulling
lunging	9	37	1421	2	lunging
mugging	12	27	1179	2	mugging
muling	9	35	1988	2	mul_ing
mulling	10	38	1999	2	mulling
nudging	10	32	869	2	nudging
nulling	8	38	1806	2	nulling
pugging	12	29	1254	2	pugging
puling	9	36	2140	2	pul_ing
pulling	10	38	2107	2	pulling
pulping	12	36	1232	2	pulping
pulsing	10	37	1286	2	pulsing
purging	11	33	1418	2	purging
rugging	10	25	1276	2	rugging
ruling	7	32	1955	2	rul_ing
sulking	12	45	1431	2	sulking
surging	9	31	1543	2	surging
tugging	10	26	1123	2	tugging
urging	8	34	1312	2	_urging

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.390	458182.1
2	DLD Change Limit	107671	104	3.440	31299.7
3	Display Results	104	104	0.046	2260.9
	(SQL Overall)	178691	104	3.876	46101.9