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

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

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
vanload	11	4	470	(None)
vanloads	12	6	416	1	vanloads
carload	10	3	978	2	carload
onload	7	26	863	2	_onload
payload	13	3	640	2	payload
unload	7	30	1080	2	_unload
abroad	9	3	1094	3	_abroad
afloat	9	3	1515	3	_afloat
allod	6	44	1838	3	_allo_d
aloud	6	50	1807	3	_a_loud
anlas	5	56	2693	3	_anl_as
anoa	4	56	3447	3	_an_oa_
anoas	5	72	2649	3	_an_oas
armload	10	4	429	3	armload
backload	17	4	683	3	backload
ballad	9	43	1532	3	ba_llad
boatload	11	4	340	3	boatload
busload	10	4	468	3	busload
canoed	9	46	1895	3	can_oed
canola	8	3	1362	3	canola_
canolas	9	3	1399	3	canolas
carloads	11	3	839	3	carloads
cartload	11	4	503	3	cartload
caseload	11	4	562	3	caseload
download	13	4	383	3	download
fanfold	14	8	537	3	fanfold
fantod	10	20	1003	3	fanto_d
ganoid	8	3	1444	3	gan_oid
halloa	9	49	1812	3	halloa_
halloaed	12	15	1015	3	halloaed
halloas	10	43	1846	3	halloas
halloed	11	33	1491	3	halloed
haloed	10	47	1760	3	ha_loed
haloid	10	43	1776	3	ha_loid
haploid	13	3	983	3	haploid
inroad	7	3	793	3	_inroad
landlord	10	4	516	3	landlord
load	5	67	3060	3	___load
mangold	11	3	721	3	mangold
manhood	13	3	899	3	manhood
offload	14	4	320	3	offload
onloads	8	24	667	3	_onloads
overload	12	11	928	3	overload
payloads	14	4	529	3	payloads
planeload	12	4	372	3	planeload
preload	10	4	981	3	preload
railroad	9	4	380	3	railroad
reload	7	4	1389	3	_reload
salad	6	53	2183	3	sa_l_ad
tabloid	10	4	826	3	tabloid
tangoed	9	31	883	3	tangoed
trainload	10	4	320	3	trainload
unlead	7	33	1237	3	_unlead
unloads	8	27	852	3	_unloads
upload	9	25	778	3	_upload
vailed	10	46	1929	3	vail_ed
valgoid	12	5	521	3	valgoid
valid	9	46	1839	3	va_l_id
valor	8	36	1489	3	va_lo_r
valors	9	34	1377	3	va_lors
valour	9	30	1037	3	va_lour
valued	10	40	1115	3	va_lued
valval	12	39	886	3	va_lval
valvar	12	38	865	3	va_lvar
valved	13	67	1104	3	va_lved
vanda	9	45	1592	3	van_da_
vandal	10	37	1383	3	van_dal
vandas	10	39	1599	3	van_das
vaned	9	46	2242	3	van__ed
vanguard	13	4	389	3	vanguard
vanilla	10	23	874	3	vanilla_
vanillas	11	22	812	3	vanillas
vanman	11	3	979	3	van_man
vanned	10	46	1448	3	van_ned
vanpool	12	4	376	3	vanpool
vanward	14	5	694	3	vanward
vaulted	11	30	719	3	vaulted
wagonload	14	5	87	3	wagonload
warlord	11	3	629	3	warlord

Search took 9 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	134027	0.153	1167915.0
2	DLD Change Limit	134027	79	8.110	16526.1
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	8.279	21583.6