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

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

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
imbalanced	17	5	248	(None)
imbalance	15	4	392	1	imbalance_
imbalances	16	4	367	1	imbalances
balanced	13	5	651	2	__balanced
misbalanced	18	5	242	2	misbalanced
rebalanced	15	4	358	2	rebalanced
unbalanced	15	4	294	2	unbalanced
ambulance	15	4	506	3	ambulance_
ambulances	16	4	422	3	ambulances
balance	11	5	1026	3	__balance_
balancer	12	4	660	3	__balancer
balances	12	7	997	3	__balances
imbalmed	15	4	329	3	imbal__med
imblazed	22	4	376	3	imb_la_zed
implanted	14	7	549	3	im_planted
misbalance	16	5	335	3	misbalance_
misbalances	17	5	317	3	misbalances
outbalanced	16	5	207	3	outbalanced
rebalance	13	4	576	3	rebalance_
rebalances	14	4	525	3	rebalances
unbalance	13	4	401	3	unbalance_
unbalances	14	4	351	3	unbalances
valanced	14	7	546	3	__valanced
ambiance	14	4	606	4	amb_iance_
ambiances	15	4	571	4	amb_iances
ambulated	14	5	713	4	ambula_ted
avalanched	19	12	171	4	_avalanched
balancers	13	4	506	4	__balancers
belaced	12	41	1215	4	__bela_ced
blanched	16	30	860	4	__b_lanched
blanked	14	40	1122	4	__b_lanked
embalmed	15	4	426	4	embal__med
embanked	17	25	388	4	emb__anked
emblazed	22	4	474	4	emb_la_zed
embraced	15	10	667	4	emb_ra_ced
emplaced	15	3	605	4	em_pla_ced
emplaned	13	3	716	4	em_plan_ed
freelanced	16	4	327	4	freelanced
gimbaled	14	10	417	4	gimbal___ed
gimballed	15	4	267	4	gimbal__led
glanced	11	43	923	4	___glanced
imagined	12	5	478	4	im_agin_ed
imbalmer	14	4	319	4	imbal__mer
imbarked	17	25	406	4	imb__arked
imblaze	20	4	432	4	imb_la_ze_
imblazes	21	4	472	4	imb_la_zes
imboldened	16	5	160	4	imboldened
imbrowned	17	4	263	4	imbrown_ed
immanence	15	15	446	4	immanence_
immanences	16	15	454	4	immanences
immolated	14	4	487	4	immola_ted
impainted	14	5	477	4	impa_inted
impaled	12	28	851	4	impal___ed
impawned	16	4	344	4	impa_wn_ed
impedance	16	4	495	4	impedance_
impedances	17	4	450	4	impedances
implanter	13	8	536	4	im_planter
inlaced	10	23	987	4	i__nla_ced
instanced	12	4	569	4	i_nstanced
islanded	10	3	551	4	i__slanded
jubilance	20	4	347	4	jubilance_
jubilances	21	4	316	4	jubilances
lanced	9	37	1772	4	____lanced
misplaced	16	4	625	4	mispla_ced
misplanned	15	8	387	4	misplanned
misplanted	15	6	544	4	misplanted
outbalance	14	5	294	4	outbalance_
outbalances	15	5	272	4	outbalances
overbalanced	20	5	269	4	overbalanced
palaced	12	41	1077	4	__pala_ced
semblance	15	4	440	4	semb_lance_
semblances	16	4	421	4	semb_lances
sibilance	13	8	471	4	sibilance_
sibilances	14	9	441	4	sibilances
valance	12	6	925	4	__valance_
valances	13	9	876	4	__valances

Search took 10 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	161450	0.423	422437.4
2	DLD Change Limit	161450	76	9.280	17397.6
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	9.736	18353.6