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

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

79 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
abandons	11	4	535	(None)
abandon	10	4	546	1	abandon_
abandoned	13	4	272	2	abandoned
abandoner	12	4	269	2	abandoner
abandoners	13	4	247	2	abandoners
bandogs	11	3	836	2	_bandogs
abalone	9	3	890	3	aba_lone
abalones	10	3	875	3	aba_lones
abandoning	14	7	258	3	abandoning
abators	9	44	1308	3	aba_tors
ablations	11	3	1151	3	ablations
abrasions	11	4	581	3	abrasions
abundant	11	4	545	3	abundant
alands	7	54	1837	3	aland__s
alanins	7	3	1580	3	alan_ins
alations	8	25	1889	3	alations
alencons	10	4	548	3	alencons
amadous	10	3	850	3	ama_dous
amandine	11	4	855	3	amandine
amazons	18	3	665	3	ama_zons
amnions	9	37	1091	3	a_mnions
anions	6	41	2303	3	__anions
anyons	9	45	1350	3	__anyons
baboons	11	32	1108	3	_baboons
bacons	10	49	1758	3	_ba_cons
ballons	9	39	1696	3	_ballons
bancos	10	47	1389	3	_banco_s
bandana	10	17	946	3	_bandana
bandanas	11	17	857	3	_bandanas
bandas	9	51	2054	3	_band_as
banders	10	43	2456	3	_banders
bandies	10	41	2486	3	_bandies
banding	11	49	2141	3	_banding
bandits	10	38	1479	3	_bandits
bandog	10	3	872	3	_bando_g
bandora	10	3	881	3	_bandora
bandoras	11	3	874	3	_bandoras
bandore	10	6	1163	3	_bandore
bandores	11	3	1160	3	_bandores
bands	8	52	3342	3	_band__s
banians	9	3	1203	3	_banians
banjoes	16	31	731	3	_banjoes
banjos	15	37	889	3	_banjo_s
banns	7	53	2123	3	_ban__ns
banyans	12	3	791	3	_banyans
barons	8	50	2538	3	_ba_rons
baryons	12	10	1047	3	_baryons
basions	9	42	1395	3	_basions
batons	8	55	1942	3	_ba_tons
baudrons	11	3	576	3	_baudrons
bonbons	11	3	933	3	_bonbons
bunions	9	22	1047	3	_bunions
candors	10	42	1676	3	_candors
cannons	9	44	1288	3	_cannons
canons	8	55	2206	3	_can_ons
cantons	9	52	2120	3	_cantons
canyons	12	45	1159	3	_canyons
carbanions	14	5	519	3	carbanions
cardons	10	45	1994	3	_cardons
chansons	13	3	747	3	chansons
fandoms	13	22	947	3	_fandoms
fanions	10	37	1307	3	_fanions
fanons	9	61	1521	3	_fan_ons
grandsons	11	4	512	3	grandsons
hagdons	12	5	852	3	_hagdons
lardons	8	39	1449	3	_lardons
nandins	8	3	1200	3	_nandins
pagandoms	15	4	312	3	pagandoms
pardons	10	38	1762	3	_pardons
quandong	19	4	294	3	quandong
quandongs	20	4	192	3	quandongs
radons	7	41	1853	3	_ra_dons
randans	8	3	1321	3	_randans
randoms	10	21	1243	3	_randoms
sabatons	10	3	784	3	saba_tons
sabayons	13	4	396	3	saba_yons
tendons	8	3	1147	3	_tendons
wanions	10	40	1137	3	_wanions
wantons	10	37	1301	3	_wantons

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.420	425454.8
2	DLD Change Limit	146162	79	7.470	19566.5
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	7.920	22562.0