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

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

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.

76 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
fatherly	17	4	507	(None)
father	12	51	1671	2	father__
fathered	15	15	1043	2	fathered
fathers	13	39	1650	2	father_s
feathery	17	36	807	2	feather_y
lathery	13	39	1112	2	lather_y
latterly	11	3	606	2	latterly
motherly	16	34	609	2	motherly
weatherly	18	4	440	2	weatherly
angerly	11	3	777	3	_angerly
badgerly	15	4	328	3	badgerly
bankerly	17	4	433	3	bankerly
bather	11	53	2251	3	bather__
bathers	12	47	2036	3	bather_s
battery	12	49	1181	3	batter_y
bitterly	13	3	560	3	bitterly
brotherly	17	4	379	3	brotherly
butcherly	19	25	265	3	butcherly
cattery	12	38	1160	3	catter_y
dapperly	16	4	300	3	dapperly
datedly	12	3	602	3	dat_edly
diathermy	18	4	257	3	diathermy
dithery	14	31	894	3	dither_y
eagerly	11	3	605	3	ea_gerly
easterly	11	24	664	3	easterly
eatery	9	53	1635	3	eat_er_y
fadedly	15	3	545	3	fa_dedly
faery	11	60	1548	3	fa__er_y
fairly	12	56	1001	3	fa__irly
fakery	16	50	926	3	fa_ker_y
falsely	13	3	601	3	false_ly
farther	13	4	834	3	farther__
fatally	13	3	989	3	fat_ally
fathead	14	3	786	3	fathe_ad
fatheads	15	3	676	3	fatheads
fathering	16	10	1009	3	fathering
fatherland	17	5	300	3	fatherland
fatherless	16	4	421	3	fatherless
fatherlike	20	4	347	3	fatherlike
fatly	11	57	1680	3	fat___ly
fatter	9	45	2321	3	fatter__
fattily	13	37	946	3	fat_tily
feather	13	36	1350	3	feather__
feathered	16	18	889	3	feathered
feathers	14	35	1324	3	feather_s
ferly	11	55	1735	3	f___erly
fishery	16	39	773	3	fisher_y
flattery	14	33	829	3	flatter_y
formerly	16	4	500	3	formerly
gather	10	41	1586	3	gather__
gathered	13	14	938	3	gathered
gatherer	12	14	791	3	gatherer
gathers	11	43	1507	3	gather_s
hatchery	19	32	638	3	hatcher_y
heathery	17	34	908	3	heather_y
lately	9	34	1384	3	lat_e_ly
lather	9	51	2436	3	lather__
lathered	12	15	1233	3	lathered
latherer	11	13	1045	3	latherer
lathers	10	43	2188	3	lather_s
lawyerly	17	4	214	3	lawyerly
leathery	14	43	897	3	leather_y
lithely	13	5	664	3	lithe_ly
mannerly	13	4	498	3	mannerly
masterly	13	31	765	3	masterly
mattedly	14	4	388	3	mattedly
mattery	12	38	1071	3	matter_y
maturely	13	4	490	3	maturely
mothery	15	37	1051	3	mother_y
northerly	15	4	352	3	northerly
rather	9	43	1974	3	rather__
southerly	15	4	418	3	southerly
teacherly	17	4	351	3	teacherly
utterly	10	3	544	3	_utterly
waterily	14	3	878	3	wat_erily
watery	12	39	1449	3	wat_er_y

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	146162	0.406	440125.6
2	DLD Change Limit	146162	76	7.093	20606.5
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.529	23733.7