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

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

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
discardable	17	5	346	(None)
discernable	16	5	445	2	discernable
discarnate	13	4	604	3	discarna_te
discernible	16	5	336	3	discernible
dischargeable	22	6	167	3	dischargeable
discordance	17	5	396	3	discordance
discussable	16	5	355	3	discussable
ascendable	15	4	398	4	_ascendable
awardable	15	4	395	4	__awardable
boardable	14	4	489	4	__boardable
cartable	12	13	1409	4	___cartable
decayable	17	4	562	4	d_eca_yable
decidable	15	4	722	4	d_ec_idable
declarable	15	4	497	4	declar_able
degradable	15	4	388	4	degra_dable
demandable	16	4	434	4	d_emandable
descendible	17	5	272	4	descendible
describable	18	5	301	4	describable
desirable	12	4	939	4	des_ir_able
dilatable	12	4	685	4	di_la_table
disable	10	5	1643	4	dis____able
disagreeable	16	6	216	4	disagreeable
disarrange	12	5	386	4	dis_arrange
disavowable	20	5	251	4	disavowable
discard	11	3	1021	4	discard____
discarded	14	3	708	4	discard__ed
discarder	13	4	675	4	discard__er
discarders	14	4	504	4	discard_ers
discarding	15	4	734	4	discard_ing
discards	12	3	891	4	discard___s
discernibly	19	5	273	4	discernibly
discoidal	13	5	541	4	discoida_l_
discordances	18	5	368	4	discordances
discordancy	20	5	267	4	discordancy
discordant	14	4	542	4	discorda_nt
discordantly	19	6	236	4	discordantly
discountable	17	5	385	4	discountable
discoverable	20	11	330	4	discoverable
discreditable	19	6	232	4	discreditable
discussible	16	5	338	4	discussible
disenable	12	4	967	4	dis__enable
dislikable	17	4	432	4	dis_likable
dislikeable	18	5	231	4	dislikeable
disparage	13	4	620	4	dispar_a_ge
disparate	12	4	905	4	dispar_a_te
dispensable	16	5	498	4	dispensable
dispersible	16	5	440	4	dispersible
displaceable	19	6	239	4	displaceable
displayable	19	5	313	4	displayable
disposable	15	4	587	4	dis_posable
disprovable	19	5	346	4	disprovable
disputable	15	4	506	4	dis_putable
dissociable	16	5	397	4	dissociable
dissolvable	17	5	314	4	dissolvable
dissyllable	17	5	316	4	dissyllable
distractable	17	5	360	4	distractable
distrainable	15	5	363	4	distrainable
disyllable	16	4	429	4	dis_yllable
dividable	16	4	500	4	di__vidable
escapable	15	4	498	4	_esca_pable
illaudable	13	13	271	4	_illaudable
inarable	10	3	1313	4	_i_nar_able
incapable	15	4	756	4	_inca_pable
includable	15	4	501	4	_includable
incurable	13	10	1077	4	_incur_able
invariable	15	4	684	4	_invariable
miserable	13	4	965	4	mis_er_able
mistakable	18	4	310	4	mista_kable
recordable	15	4	555	4	_recordable
restartable	13	4	354	4	restartable
rewardable	16	4	388	4	_rewardable
sandable	11	16	1282	4	__s_andable
scalable	12	17	1023	4	__sca_lable
scannable	13	4	564	4	__scannable
sharable	13	19	1069	4	__shar_able
shareable	14	3	673	4	__shareable
sparable	12	16	1198	4	__spar_able
spareable	13	3	726	4	__spareable
unscalable	14	4	635	4	unsca_lable

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	79	9.346	15923.3
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	9.812	18211.5