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

Here are the results of your fuzzy-string dictionary search for “allowables” 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
allowables	15	5	280	(None)
allowable	14	4	495	1	allowable_
allocable	13	4	563	2	allocable_
allowably	17	4	377	2	allowabl_y
allowances	15	4	382	2	allowances
alliable	10	3	843	3	all_iable_
allocates	11	4	1047	3	alloca_tes
allogamies	13	4	545	3	allogamies
allowance	14	4	436	3	allowance_
allowanced	16	5	230	3	allowanced
avowable	16	3	545	3	a_vowable_
plowable	15	3	591	3	_plowable_
swallowable	19	5	126	3	swallowable_
abrogable	14	4	457	4	abrogable_
adorable	11	3	877	4	a_dorable_
alarmable	13	4	501	4	alarmable_
aldolases	10	4	522	4	aldola_ses
alienable	11	4	693	4	alienable_
alleles	7	38	1203	4	all___eles
allemandes	13	14	322	4	allemandes
allheals	11	4	391	4	allhea_l_s
alliances	11	10	709	4	all_iances
allobars	10	4	658	4	allo__bars
allocatable	15	5	196	4	allocatable_
allocate	10	4	1102	4	alloca_te_
allocated	12	4	809	4	alloca_ted
allocators	12	4	608	4	allocators
allogamous	13	5	320	4	allogamous
allonges	9	3	731	4	allo__nges
allopathies	16	5	374	4	allopathies
allopaths	14	4	496	4	allopa_ths
allopatries	13	5	433	4	allopatries
allophanes	15	4	583	4	allophanes
allophones	15	4	622	4	allophones
allosaurs	9	13	416	4	allosa_urs
allosaurus	10	12	265	4	allosaurus
allotropes	12	5	559	4	allotropes
allottees	9	6	432	4	allo_ttees
allotypes	14	4	510	4	allo_types
allotypies	15	5	397	4	allotypies
allowed	11	16	1008	4	allow___ed
allowedly	16	4	232	4	allowedl_y
allows	9	45	1768	4	allow____s
alloxans	15	4	524	4	alloxa__ns
alterable	11	4	916	4	alterable_
apposable	15	4	560	4	apposable_
arables	9	18	1497	4	a___rables
atonable	10	3	879	4	a_tonable_
avowably	19	4	400	4	a_vowabl_y
avowals	13	3	501	4	a_vowa_l_s
blowballs	16	4	358	4	_blowballs
blowholes	17	4	447	4	_blowholes
browsables	17	4	181	4	_browsables
callable	12	3	1075	4	call__able_
closable	12	16	800	4	_closable_
colorable	13	4	824	4	colorable_
dowable	13	18	945	4	__dowable_
employables	20	5	163	4	employables
flammables	19	4	223	4	flammables
floodable	15	4	401	4	floodable_
flowages	15	3	573	4	_flowa_ges
gallonages	12	6	455	4	gallona_ges
gallopades	14	4	376	4	gallopa_des
gallowses	13	7	494	4	gallow__ses
growable	14	3	562	4	_growable_
hollowares	16	4	376	4	hollowa_res
immovables	19	5	262	4	immovables
knowable	17	4	504	4	_knowable_
locales	9	37	1509	4	__loca_les
losable	9	19	1095	4	__losable_
lovable	12	17	955	4	__lovable_
lowballs	13	6	439	4	__lowballs
malleable	13	7	607	4	mall_eable_
movables	15	17	557	4	__movables
notables	10	17	824	4	__notables
potables	12	17	970	4	__potables
probables	15	4	543	4	_probables
reliables	11	4	590	4	rel_iables
renewables	15	4	340	4	renewables
rowable	12	15	1030	4	__rowable_
showable	16	3	658	4	_showable_
sowable	12	16	1075	4	__sowable_
storables	11	4	628	4	_storables
stowable	13	3	761	4	_stowable_
syllables	14	14	475	4	syl_lables
towable	12	19	1011	4	__towable_
unlovable	14	4	636	4	unlovable_
valuables	14	4	297	4	val_uables
vocables	15	14	573	4	__vocables
wallabies	14	4	573	4	wall__abies

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.420	425454.8
2	DLD Change Limit	161450	90	9.343	17280.3
3	Display Results	90	90	0.046	1956.5
	(SQL Overall)	178691	90	9.809	18217.0