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

Here are the results of your fuzzy-string dictionary search for “bilges” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

98 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
bilges	9	49	1563	(None)
biles	7	55	4214	1	bil_es
bilge	8	76	1891	1	bilge_
bilged	10	55	1318	1	bilged
binges	9	39	2312	1	binges
bulges	9	59	1932	1	bulges
badges	10	39	1737	2	badges
bailees	9	39	1438	2	bailees
bailies	9	41	2020	2	bailies
bales	7	62	5008	2	bal_es
barges	9	45	2825	2	barges
beiges	9	10	1441	2	beiges
belgas	9	3	1171	2	belgas
belies	8	46	3105	2	belies
belles	8	53	2599	2	belles
bialies	9	36	1841	2	bialies
biases	8	46	1843	2	biases
bibles	10	46	1764	2	bibles
bices	9	50	2996	2	bi_ces
bides	8	55	3677	2	bi_des
bigger	10	43	1506	2	bigger
biggest	11	3	814	2	biggest
biggies	11	38	1352	2	biggies
bigos	8	50	2001	2	bi_gos
bigs	7	62	3502	2	bi_g_s
bikes	11	75	2947	2	bi_kes
bikies	12	45	1516	2	bikies
bilbies	11	47	1234	2	bilbies
bilboes	11	44	1024	2	bilboes
bilbos	10	50	1120	2	bilbos
bile	6	61	4718	2	bil_e_
bilgier	10	35	853	2	bilgier
bilgiest	11	30	988	2	bilgiest
bilgy	11	47	1371	2	bilg_y
bilked	13	40	1294	2	bilked
bilker	12	49	1344	2	bilker
bilkers	13	47	1186	2	bilkers
bilks	11	51	1789	2	bil_ks
billed	9	42	2490	2	billed
biller	8	49	2348	2	biller
billers	9	47	2083	2	billers
billet	8	60	2972	2	billet
billets	9	45	1615	2	billets
billies	9	39	2350	2	billies
bills	7	56	3286	2	bil_ls
bines	7	69	4679	2	bi_nes
binge	8	51	2551	2	binge_
binged	10	59	2082	2	binged
binger	9	49	2345	2	binger
bingers	10	45	1999	2	bingers
bingoes	10	40	1398	2	bingoes
bingos	9	55	1479	2	bingos
biogas	9	43	1091	2	biogas
biogen	9	3	1025	2	biogen
biogens	10	3	896	2	biogens
biogs	8	50	1611	2	biog_s
biomes	10	38	1525	2	biomes
birles	8	49	2064	2	birles
birses	8	47	1773	2	birses
bises	7	54	3562	2	bi_ses
bites	7	56	4117	2	bi_tes
bizes	16	59	2366	2	bi_zes
bizzes	16	39	1084	2	bizzes
blites	8	47	2121	2	blites
blues	7	51	2704	2	b_lues
bogles	9	50	2083	2	bogles
boles	7	54	4860	2	bol_es
bridges	11	39	1133	2	bridges
budges	10	48	2013	2	budges
bugles	9	48	2244	2	bugles
bulge	8	64	1987	2	bulge_
bulged	10	51	1712	2	bulged
bulger	9	49	1735	2	bulger
bulgers	10	52	1514	2	bulgers
dinges	8	38	2542	2	dinges
dirges	8	49	1510	2	dirges
fidges	11	41	1439	2	fidges
files	8	54	4127	2	fil_es
filles	9	42	2452	2	filles
hinges	10	51	2103	2	hinges
lieges	7	41	1344	2	lieges
lilies	6	30	2141	2	lilies
midges	10	35	1648	2	midges
milages	10	31	1440	2	milages
miles	7	46	4507	2	mil_es
milles	8	45	2656	2	milles
obliges	10	3	714	2	obliges
piles	7	47	4261	2	pil_es
ridges	8	58	1701	2	ridges
riles	5	53	4364	2	ril_es
rilles	6	47	2550	2	rilles
sieges	7	38	1683	2	sieges
silages	8	25	1444	2	silages
singes	7	43	2685	2	singes
tildes	7	45	1396	2	tildes
tiles	5	55	4210	2	til_es
tinges	7	47	2233	2	tinges
wiles	8	54	3787	2	wil_es

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	82551	0.610	292936.1
2	DLD Change Limit	82551	98	5.186	15918.0
3	Display Results	98	98	0.033	2969.7
	(SQL Overall)	178691	98	5.829	30655.5