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

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

88 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
fluvial	13	4	536	(None)
eluvial	10	4	585	1	eluvial
pluvial	12	4	543	1	pluvial
alluvial	11	4	431	2	alluvial
diluvial	12	22	463	2	diluvial
effluvial	18	5	160	2	effluvial
eluvia	9	3	613	2	eluvia_
exuvial	17	4	425	2	exuvial
faucial	12	5	732	2	faucial
fluidal	11	4	465	2	fluidal
illuvial	11	4	411	2	illuvial
pluvials	13	4	371	2	pluvials
pluvian	12	4	533	2	pluvian
alluvia	10	4	519	3	alluvia_
alluvials	12	4	312	3	alluvials
alodial	8	9	995	3	alodial
audial	7	3	1299	3	_audial
burial	8	41	1762	3	_burial
clivia	11	7	723	3	clivia_
clivias	12	6	669	3	clivias
colluvial	14	4	385	3	colluvial
crucial	11	5	789	3	crucial
curial	8	40	1915	3	_curial
diluvia	11	22	524	3	diluvia_
diluvian	12	19	466	3	diluvian
effluvia	17	5	190	3	effluvia_
eluviate	11	4	695	3	eluviate
eluvium	12	4	497	3	eluvium
exuvia	16	4	422	3	exuvia_
exuviae	17	4	434	3	exuviae
facial	11	36	1563	3	f_acial
fascial	12	5	830	3	fascial
faucal	11	33	996	3	fau_cal
faunal	9	47	1159	3	fau_nal
fauvism	15	4	522	3	fauvism
fauvist	13	3	666	3	fauvist
fecial	11	47	1462	3	f_ecial
ferial	9	46	2125	3	f_erial
fetial	9	57	1619	3	f_etial
feudal	10	3	768	3	feu_dal
fiducial	14	4	326	3	fiducial
filarial	11	4	786	3	filarial
filial	9	30	1325	3	f_ilial
finial	9	28	1418	3	f_inial
flail	8	53	1618	3	fl_ai_l
flavin	12	3	930	3	flavi_n
flavine	13	3	845	3	flavine
flavins	13	3	854	3	flavins
floral	9	43	1381	3	fl_oral
fluid	9	40	1396	3	flu_i_d
fluidly	14	3	481	3	flu_idly
fluids	10	34	942	3	flu_ids
fluish	12	3	933	3	flu_ish
flukier	14	39	785	3	flukier
flukily	17	3	521	3	flukily
fluking	15	44	1051	3	fluking
fluming	13	35	1279	3	fluming
flutier	10	30	1155	3	flutier
fluting	11	38	1509	3	fluting
flutist	10	29	1078	3	flutist
fluviatile	16	5	150	3	fluviatile
fluxing	18	39	892	3	fluxing
fluxion	17	3	504	3	fluxion
fluxional	19	5	240	3	fluxional
foveal	12	3	770	3	f_oveal
frugal	10	3	639	3	fru_gal
fugal	9	56	1303	3	f_u_gal
fulfil	12	4	642	3	fulfi_l
fulfill	13	4	502	3	fulfill
fungal	10	38	873	3	f_ungal
fusil	8	47	1532	3	f_usi_l
fuzil	17	38	1070	3	f_uzi_l
gavial	10	3	1008	3	_gavial
glacial	10	3	814	3	glacial
glial	6	67	1543	3	gl__ial
gluteal	8	5	424	3	gluteal
ilial	5	53	1784	3	il__ial
illuvia	10	4	427	3	illuvia_
jovial	16	3	654	3	_jovial
labial	8	47	1434	3	_labial
luminal	9	37	1100	3	_luminal
luteal	6	44	1148	3	_luteal
plural	8	3	982	3	plu_ral
trivial	10	3	871	3	trivial
urial	5	48	2302	3	__urial
uveal	8	44	1107	3	__uveal
vial	7	67	3109	3	___vial
vulval	12	41	766	3	vulv_al

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.140	1276364.3
2	DLD Change Limit	134027	88	5.846	22926.3
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	6.016	29702.6