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

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

56 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
supportable	17	5	269	(None)
insupportable	19	6	153	2	insupportable
supposable	16	4	314	2	suppo_sable
unsupportable	19	6	172	2	unsupportable
deportable	15	4	565	3	_deportable
exportable	21	4	460	3	_exportable
importable	16	4	655	3	_importable
insupportably	22	6	142	3	insupportably
portable	12	3	1320	3	___portable
reportable	14	4	695	3	_reportable
sortable	10	3	1248	3	s___ortable
spottable	13	4	534	3	s__pottable
superable	13	3	1248	3	su_per_able
supportive	17	5	328	3	support_ive
supposably	19	5	247	3	suppo_sably
apposable	15	4	560	4	_appo_sable
approvable	19	6	393	4	_approvable
comfortable	20	9	364	4	comfortable
deplorable	15	4	507	4	deplor_able
exploitable	22	6	269	4	exploitable
opposable	15	4	406	4	_oppo_sable
portables	13	3	787	4	___portables
portably	15	3	931	4	___portably
potable	11	21	1536	4	___po_table
quotable	19	3	649	4	qu__o_table
separable	13	4	867	4	s_epar_able
sorbable	12	3	930	4	s___orbable
sortably	13	3	880	4	s___ortably
sparable	12	16	1198	4	s__par_able
spareable	13	3	726	4	s__pareable
spoilable	13	4	516	4	s__poilable
storable	10	3	1073	4	s__tor_able
sufferable	18	4	332	4	suffer_able
suitable	10	3	1089	4	su___itable
summonable	16	6	295	4	summo_nable
superably	16	4	888	4	su_per_ably
supermale	13	4	998	4	su_perma_le
superposable	18	5	283	4	superpo_sable
supersale	11	4	1132	4	su_persa_le
support	11	3	1052	4	support____
supportability	23	6	223	4	supportability
supported	14	4	468	4	support__ed
supporter	13	4	451	4	support__er
supporters	14	4	409	4	support_ers
supporting	15	4	556	4	support_ing
supports	12	4	651	4	support___s
supposal	12	4	491	4	suppo_sa_l_
supposals	13	4	388	4	suppo_sa_ls
suppurate	13	4	543	4	suppur_a_te
suppurative	18	5	338	4	suppurative
surfable	13	3	844	4	su___rfable
surmountable	16	9	125	4	surmountable
surpassable	15	5	212	4	surpassable
unprovable	17	4	571	4	_unprovable
unworkable	19	4	447	4	_unworkable
vaporable	16	4	554	4	_vapor_able

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.170	1051123.5
2	DLD Change Limit	148819	56	9.156	16253.7
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	9.359	19093.0