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

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

62 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
bailies	9	41	2020	(None)
bailees	9	39	1438	1	bailees
bailie	8	38	1836	1	bailie_
ballies	9	37	2574	1	ballies
bialies	9	36	1841	1	bialies
dailies	8	42	1926	1	dailies
allies	6	38	2767	2	_allies
babies	10	61	2364	2	ba_bies
baddies	11	40	1787	2	baddies
baffies	15	36	1294	2	baffies
baggies	11	38	1485	2	baggies
bailed	9	47	2665	2	bail_ed
bailee	8	45	2601	2	bail_ee
bailer	8	54	2525	2	bail_er
bailers	9	42	2135	2	bailers
bailey	11	50	1567	2	bail_ey
baileys	12	38	893	2	baileys
bailiff	15	4	607	2	bailiff
bailiffs	16	4	256	2	bailiffs
bailing	10	37	2352	2	bailing
bailors	9	32	1240	2	bailors
bails	7	59	3352	2	bail__s
baizes	17	43	1505	2	bai_zes
baldies	10	53	1770	2	baldies
bales	7	62	5008	2	ba_l_es
bandies	10	41	2486	2	bandies
banties	9	43	2476	2	banties
barbies	11	45	1959	2	barbies
barflies	13	3	830	2	barflies
basifies	13	3	1049	2	basifies
bawdies	13	46	1339	2	bawdies
bawties	12	42	1431	2	bawties
belies	8	46	3105	2	b_elies
bellies	9	40	2372	2	bellies
bialis	8	36	1716	2	biali_s
bikies	12	45	1516	2	b_ikies
bilbies	11	47	1233	2	b_ilbies
biles	7	55	4214	2	b_il_es
bilges	9	49	1563	2	b_ilges
billies	9	39	2350	2	billies
brailles	10	3	948	2	brailles
brinies	9	33	1791	2	brinies
bullies	9	41	2189	2	bullies
chilies	12	42	1830	2	chilies
dairies	8	42	1773	2	dairies
daisies	8	42	1709	2	daisies
dallies	8	40	2319	2	dallies
doilies	8	40	1736	2	doilies
failles	10	29	1412	2	failles
fairies	10	35	1604	2	fairies
families	13	3	944	2	families
gallies	8	41	2271	2	gallies
laities	7	3	2034	2	laities
lilies	6	30	2141	2	_lilies
mailes	8	43	2911	2	mail_es
rallies	7	38	2334	2	rallies
ramilies	10	3	1183	2	ramilies
sallies	7	32	2781	2	sallies
tailles	7	25	1646	2	tailles
tallies	7	36	2460	2	tallies
walies	9	53	2452	2	wa_lies
wallies	10	33	2074	2	wallies

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.123	1452772.4
2	DLD Change Limit	107671	62	3.500	30763.1
3	Display Results	62	62	0.033	1878.8
	(SQL Overall)	178691	62	3.656	48876.1