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

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

90 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
unavailable	16	5	468	(None)
available	14	4	490	2	__available
unassailable	14	5	326	2	unassailable
unavoidable	17	5	376	2	unavoidable
availably	17	4	325	3	__availably
bioavailable	19	6	65	3	bioavailable
navigable	15	4	474	3	_nav_igable
unadaptable	16	5	391	3	unadaptable
unamiable	13	4	847	3	una_mi_able
unassailably	17	6	242	3	unassailably
unattainable	14	5	339	3	unattainable
unavoidably	20	5	264	3	unavoidably
unsalable	11	4	899	3	un_sa_lable
unscalable	14	4	635	3	unsca_lable
unviable	13	3	870	3	un_v_i_able
assailable	12	4	343	4	_assailable
avoidable	15	12	474	4	__avoidable
bailable	12	3	858	4	___bailable
enviable	13	3	785	4	en_v_i_able
inadvisable	17	5	347	4	inadvisable
inevitable	15	5	764	4	inev_itable
invaluable	15	4	507	4	in_valuable
invariable	15	4	684	4	in_variable
inviable	13	3	852	4	in_v_i_able
inviolable	15	4	527	4	in_violable
jailable	17	3	714	4	___jailable
mailable	12	3	962	4	___mailable
navigably	18	4	343	4	_nav_igably
sailable	10	3	1056	4	___sailable
unactable	13	3	1005	4	un__actable
unadoptable	16	5	353	4	unadoptable
unalienable	13	4	534	4	unalienable
unalterable	13	4	577	4	unalterable
unamenable	14	4	694	4	una_menable
unanalyzable	26	5	207	4	unanalyzable
unappealable	18	5	299	4	unappealable
unarguable	13	4	483	4	una_rguable
unassimilable	17	9	167	4	unassimilable
unavailability	22	6	362	4	unavailability
unavailing	14	4	337	4	unavail_ing
unavailingly	19	5	175	4	unavailingly
unbearable	14	4	738	4	unbea_rable
unbeatable	14	4	783	4	unbea_table
unbuildable	16	5	250	4	un_buildable
uncapable	15	4	779	4	un_ca_pable
uncharitable	19	8	402	4	uncharitable
undatable	12	3	898	4	un_da_table
undecidable	17	4	572	4	undecidable
undefinable	17	4	638	4	undefinable
undeniable	13	4	856	4	undeni_able
undesirable	14	4	748	4	undesirable
uneatable	11	3	1169	4	un_ea_table
unenviable	15	4	585	4	unenvi_able
unexcitable	22	4	506	4	unexcitable
unfavorable	19	5	371	4	unfav_orable
unflappable	20	5	305	4	unflappable
ungraspable	16	5	353	4	ungraspable
unhirable	14	4	764	4	un__hirable
unifiable	14	4	734	4	un_ifi_able
unimaginable	17	5	307	4	unimaginable
unlearnable	13	4	497	4	unlearnable
unlikable	15	4	677	4	un__likable
unlivable	14	4	760	4	un__livable
unmanageable	17	5	290	4	unmanageable
unmixable	20	4	586	4	un__mixable
unnamable	13	5	662	4	un_na_mable
unnameable	14	4	550	4	un_nameable
unobtainable	16	5	334	4	unobtainable
unpalatable	15	4	479	4	unpala_table
unpassable	14	4	613	4	un_passable
unplayable	17	4	531	4	unpla_yable
unpliable	13	4	781	4	un_pli_able
unreachable	18	4	609	4	unreachable
unreadable	13	4	771	4	unrea_dable
unrealizable	23	5	430	4	unrealizable
unreliable	12	4	848	4	unreli_able
unridable	12	4	829	4	un__ridable
unsalably	14	4	632	4	un_sa_lably
unsalvageable	19	6	141	4	unsalvageable
unsayable	14	4	722	4	un_sa_yable
unsellable	12	4	709	4	un_sellable
unshakable	19	4	499	4	unsha_kable
unslakable	16	4	523	4	unsla_kable
unsociable	14	4	728	4	unsoci_able
unsuitable	12	4	757	4	un_suitable
untamable	13	4	784	4	un_ta_mable
unteachable	18	4	574	4	unteachable
untillable	12	4	598	4	un_tillable
untraceable	15	4	685	4	untraceable
unwearable	15	4	721	4	unwea_rable

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	148819	0.420	425454.8
2	DLD Change Limit	148819	90	9.156	16253.7
3	Display Results	90	90	0.063	1428.6
	(SQL Overall)	178691	90	9.639	18538.3