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

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

89 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
opaqued	19	4	219	(None)
opaque	17	3	421	1	opaque_
opaquer	18	4	240	1	opaquer
opaques	18	3	364	1	opaques
opaquely	22	4	150	2	opaquely
opaquest	19	4	322	2	opaquest
piqued	18	3	621	2	_piqued
calqued	19	30	652	3	calqued
casqued	19	23	563	3	casqued
claque	17	33	856	3	claque_
claquer	18	28	735	3	claquer
claques	18	27	901	3	claques
cliqued	19	26	668	3	cliqued
leagued	9	3	546	3	leagued
miaoued	10	3	458	3	miaoued
oared	6	50	3065	3	o_a_red
obliqued	20	4	335	3	obliqued
okayed	14	3	425	3	oka_yed
opaquing	20	4	231	3	opaquing
oped	7	62	3015	3	op___ed
opened	9	43	1186	3	op_ened
opiated	10	3	948	3	opiated
opined	9	51	1385	3	op_ined
opposed	12	3	612	3	opposed
opted	8	49	1427	3	op__ted
orated	7	42	2150	3	ora_ted
paced	10	69	3168	3	_pa_ced
packed	15	48	2260	3	_packed
padded	11	41	1350	3	_padded
paged	9	59	2678	3	_pa_ged
paiked	13	51	1343	3	_paiked
pained	9	56	2285	3	_pained
paired	9	50	1752	3	_paired
paled	8	55	3872	3	_pa_led
palled	9	46	2516	3	_palled
palmed	11	43	1464	3	_palmed
palped	11	45	1364	3	_palped
paned	8	54	3718	3	_pa_ned
panged	10	47	2233	3	_panged
panned	9	41	2343	3	_panned
panted	9	50	2482	3	_panted
pared	8	69	4676	3	_pa_red
parged	10	49	2204	3	_parged
parked	13	44	2514	3	_parked
parled	9	46	2629	3	_parled
parquet	18	3	1158	3	_parquet
parred	9	50	2407	3	_parred
parsed	9	63	2389	3	_parsed
parted	9	42	2868	3	_parted
pashed	12	59	2314	3	_pashed
passed	9	43	2094	3	_passed
pasted	9	44	2690	3	_pasted
pated	8	52	3784	3	_pa_ted
patted	9	47	2468	3	_patted
paused	9	51	1496	3	_paused
paved	11	55	2526	3	_pa_ved
paveed	12	43	889	3	_paveed
pawed	11	57	2561	3	_pa_wed
pawned	12	45	1328	3	_pawned
payed	11	59	2593	3	_pa_yed
pique	16	4	1017	3	_pique_
piques	17	3	909	3	_piques
piquet	17	4	1235	3	_piquet
plagued	11	30	747	3	plagued
plaque	17	31	764	3	plaque_
plaques	18	31	789	3	plaques
poached	15	42	1240	3	poached
snafued	11	3	493	3	snafued
spaced	11	45	1725	3	spa_ced
spaded	10	38	1675	3	spa_ded
spaed	8	55	2227	3	spa__ed
spalled	10	31	1313	3	spalled
spammed	14	34	852	3	spammed
spanked	14	31	1173	3	spanked
spanned	10	41	1122	3	spanned
spared	9	54	2749	3	spa_red
sparged	11	35	1276	3	sparged
sparked	14	35	1314	3	sparked
sparred	10	45	1286	3	sparred
spasmed	12	29	699	3	spasmed
spathed	13	40	1318	3	spathed
spatted	10	40	1414	3	spatted
spawned	13	31	680	3	spawned
spayed	12	42	1361	3	spa_yed
spued	8	49	1847	3	sp__ued
statued	8	45	989	3	statued
tabued	9	43	1040	3	_tabued
torqued	17	22	489	3	torqued
valued	10	40	1115	3	_valued

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	134027	0.390	458182.1
2	DLD Change Limit	134027	89	5.843	22938.0
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	6.263	28531.2