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

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

92 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
embanked	17	25	388	(None)
embarked	17	20	521	1	embarked
banked	13	50	2144	2	__banked
embalmed	15	4	426	2	embalmed
embank	14	34	655	2	embank__
embanks	15	29	570	2	embank_s
embarred	13	17	479	2	embarred
embayed	15	3	544	2	emba_yed
embosked	17	4	369	2	embosked
imbarked	17	25	406	2	imbarked
backed	15	57	2572	3	__backed
baked	12	61	3077	3	__ba_ked
balked	13	52	1941	3	__balked
banded	10	52	2317	3	__banded
baned	8	54	3635	3	__ban_ed
banged	10	49	2372	3	__banged
banker	12	42	2273	3	__banker
banned	9	47	2134	3	__banned
barked	13	50	2731	3	__barked
basked	13	52	1860	3	__basked
bemeaned	13	3	578	3	bemean_ed
bemoaned	13	3	555	3	bemoan_ed
bethanked	19	4	328	3	bethanked
blanked	14	40	1122	3	_blanked
bonked	13	55	1731	3	__bonked
bunked	13	51	1837	3	__bunked
clanked	14	38	1225	3	_clanked
cranked	14	38	1284	3	_cranked
debarked	16	17	582	3	debarked
debunked	16	3	319	3	debunked
demanded	13	34	851	3	dem_anded
demarked	16	18	722	3	dem_arked
demeaned	12	3	728	3	demean_ed
emailed	10	35	921	3	em_ailed
emanated	11	3	916	3	em_anated
embalmer	14	4	406	3	embalmer
embanking	18	4	381	3	embanking
embankment	20	11	447	3	embankment
embargoed	15	4	233	3	embargoed
embark	14	45	852	3	embark__
embarks	15	33	735	3	embark_s
embattled	14	4	256	3	embattled
embed	10	50	1430	3	emb___ed
embedded	15	5	331	3	embedded
emblazed	22	4	474	3	emblazed
emblemed	15	4	427	3	emblemed
embodied	14	4	529	3	embodied
embossed	13	4	469	3	embossed
embowed	15	23	690	3	emb_owed
embraced	15	10	667	3	embraced
embrangled	16	5	246	3	embrangled
embrued	12	3	529	3	emb_rued
embruted	13	4	435	3	embruted
emended	11	32	960	3	em_ended
empaled	12	28	895	3	empa_led
empanel	11	4	596	3	empan_el
empaneled	14	4	343	3	empaneled
emplaned	13	3	716	3	emplan_ed
enhanced	14	3	662	3	enhanced
expanded	19	14	516	3	expanded
flanked	15	37	1064	3	_flanked
franked	15	36	1005	3	_franked
hanked	14	42	2060	3	__hanked
imbalmed	15	4	329	3	imbalmed
imparked	17	26	486	3	imparked
maned	8	66	3410	3	_m_an_ed
manned	9	44	1864	3	_m_anned
marked	13	39	2162	3	_m_arked
masked	13	43	1652	3	_m_asked
membraned	16	4	390	3	membran_ed
moaned	9	45	1417	3	_moan_ed
planked	14	35	1228	3	_planked
pranked	14	37	1209	3	_pranked
ranked	11	46	2074	3	__ranked
reembarked	19	4	292	3	reembarked
remanded	12	30	1132	3	rem_anded
remanned	11	31	935	3	rem_anned
remarked	15	20	924	3	rem_arked
shanked	15	32	1212	3	_shanked
skanked	11	33	810	3	_skanked
smacked	16	37	1099	3	sm_acked
spanked	14	31	1173	3	_spanked
swanked	15	35	954	3	_swanked
tanked	11	39	1929	3	__tanked
thanked	15	46	915	3	_thanked
unbacked	17	26	873	3	unbacked
unbaked	14	33	1289	3	unba_ked
unbanded	12	30	1056	3	unbanded
unbanned	11	27	911	3	unbanned
unranked	13	3	856	3	unranked
wanked	14	45	1715	3	__wanked
yanked	14	43	1224	3	__yanked

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.453	394461.4
2	DLD Change Limit	146162	92	6.596	22159.2
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	7.079	25242.4