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

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

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.

85 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
appalling	14	4	492	(None)
appallingly	19	5	150	2	appallingly
appareling	15	4	342	2	appareling
apparelling	16	5	243	2	apparelling
appealing	14	4	649	2	appealing
applying	16	3	465	2	app_lying
palling	10	40	2448	2	__palling
rappelling	15	4	436	2	rappelling
spalling	11	32	1346	2	_spalling
annulling	10	4	500	3	annulling
anvilling	13	3	683	3	anvilling
appall	10	37	974	3	appall___
appalled	13	4	481	3	appall_ed
appalls	11	33	774	3	appall__s
appearing	14	3	689	3	appearing
appeasing	14	4	634	3	appeasing
appellant	13	4	635	3	appellant
appending	15	3	628	3	appending
applauding	16	4	210	3	applauding
apposing	13	3	740	3	app_osing
appraising	15	4	576	3	appraising
apprising	14	4	796	3	apprising
apprizing	23	4	719	3	apprizing
approving	17	4	505	3	approving
asphalting	16	4	338	3	asphalting
assailing	10	3	602	3	assailing
availing	12	6	728	3	a_vailing
balling	10	44	2476	3	__balling
befalling	15	22	650	3	befalling
begalling	13	21	649	3	begalling
caballing	14	3	688	3	caballing
calling	10	38	2677	3	__calling
canalling	12	3	955	3	canalling
catcalling	15	4	512	3	catcalling
cupelling	14	3	628	3	cupelling
dappling	14	3	684	3	dapp__ling
dialling	10	3	1078	3	_dialling
empaling	13	3	836	3	empa_ling
equalling	19	4	524	3	equalling
expelling	19	3	613	3	expelling
falling	11	36	2158	3	__falling
galling	9	39	2196	3	__galling
impaling	13	3	825	3	impa_ling
impelling	14	3	691	3	impelling
infalling	13	5	624	3	infalling
inwalling	13	8	563	3	inwalling
lalling	8	35	1962	3	__lalling
malling	10	36	2366	3	__malling
medalling	13	4	692	3	medalling
metalling	12	4	959	3	metalling
napalming	14	4	317	3	napalming
paling	9	35	3013	3	__pa_ling
palming	12	39	1401	3	__palming
palping	12	41	1287	3	__palping
panelling	12	3	907	3	panelling
parling	10	38	2376	3	__parling
pealing	10	41	2320	3	_pea_ling
pearling	11	9	1201	3	_pearling
pedalling	13	4	666	3	pedalling
pilling	10	37	2256	3	__pilling
polling	10	29	2038	3	__polling
prilling	11	34	1341	3	_prilling
psalming	13	7	547	3	_psalming
pulling	10	38	2107	3	__pulling
rappeling	14	3	596	3	rapp_eling
recalling	12	22	1190	3	recalling
refalling	13	20	1042	3	refalling
repelling	12	23	1275	3	repelling
repolling	12	21	1020	3	repolling
rivalling	13	3	596	3	rivalling
sandalling	12	4	587	3	sandalling
sparling	11	27	1453	3	_sparling
spelling	11	33	1523	3	_spelling
spilling	11	31	1394	3	_spilling
spiralling	13	4	396	3	spiralling
sprawling	15	17	512	3	sprawling
squalling	19	3	517	3	squalling
stalling	9	51	1670	3	_stalling
thralling	13	25	683	3	thralling
totalling	10	3	652	3	totalling
uppiling	13	3	585	3	upp_iling
uptalking	16	4	335	3	uptalking
upwelling	15	3	523	3	upwelling
vialling	12	3	722	3	_vialling
walling	11	35	2097	3	__walling

Search took 7 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	148641	0.156	1145455.1
2	DLD Change Limit	148641	85	6.143	24196.8
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	6.329	28233.7