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

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

69 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
provisioned	17	5	397	(None)
previsioned	17	4	427	1	previsioned
provisioner	16	5	379	1	provisioner
provision	14	4	763	2	provision__
provisional	16	5	546	2	provisional
provisioners	17	5	281	2	provisioners
provisions	15	4	721	2	provision_s
reprovisioned	19	6	161	2	reprovisioned
envisioned	14	5	293	3	_envisioned
pavilioned	16	5	249	3	p_avilioned
poisoned	11	3	695	3	p_o_is_oned
positioned	13	9	600	3	p_ositioned
prevision	14	4	801	3	prevision__
previsional	16	5	533	3	previsional
previsions	15	4	774	3	prevision_s
previsited	16	4	518	3	previsi_ted
prisoned	11	3	881	3	pr__is_oned
processioned	17	5	397	3	processioned
provisionals	17	5	376	3	provisionals
provisionary	20	7	324	3	provisionary
provisioning	18	8	359	3	provisioning
provisoes	14	4	665	3	provis_o_es
visioned	12	4	701	3	___visioned
decisioned	14	4	414	4	_decisioned
opinioned	12	4	327	4	__opinioned
partitioned	14	5	350	4	partitioned
pensioned	12	4	665	4	p__ensioned
petitioned	13	4	417	4	p_etitioned
pinioned	11	3	751	4	p___inioned
poisoner	10	4	698	4	p_o_is_oner
portioned	12	4	834	4	p_o_rtioned
preassigned	15	5	260	4	preassigned
precision	13	4	1005	4	precision__
precisions	14	4	937	4	precision_s
predisposed	17	5	267	4	predisposed
pretensioned	15	5	359	4	pretensioned
prevised	14	36	1108	4	previs___ed
prevising	15	5	1087	4	previsi_n_g
previsionary	20	8	330	4	previsionary
previsioning	18	8	408	4	previsioning
prisoner	10	4	857	4	pr__is_oner
probationer	15	6	377	4	probationer
profusion	14	4	570	4	profusion__
profusions	15	4	525	4	profusion_s
prohibited	18	5	347	4	prohibi_ted
prolusion	11	4	636	4	prolusion__
prolusions	12	4	588	4	prolusion_s
promised	13	30	1088	4	promis___ed
promising	14	4	1097	4	promisi_n_g
propined	13	31	1151	4	pro__pi_ned
propitiated	16	5	480	4	propitiated
proponed	13	24	1204	4	pro___poned
proportioned	17	5	440	4	proportioned
propositioned	18	5	391	4	propositioned
provided	15	3	684	4	prov__i_ded
providing	16	3	796	4	providi_n_g
provisionally	21	6	316	4	provisionally
proviso	12	3	731	4	provis_o___
provisory	17	4	435	4	provis_o_ry
provisos	13	3	692	4	provis_o__s
provoked	18	7	505	4	prov___oked
provolone	14	4	488	4	prov_olone_
provolones	15	4	464	4	prov_olones
reprovision	16	5	371	4	reprovision__
reprovisions	17	5	377	4	reprovision_s
revision	11	3	872	4	_revision__
revisions	12	3	860	4	_revision_s
revisited	13	4	657	4	_revisi_ted
rosined	8	49	1191	4	_ro__si_ned

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	148819	0.436	409841.7
2	DLD Change Limit	148819	69	9.330	15950.6
3	Display Results	69	69	0.046	1500.0
	(SQL Overall)	178691	69	9.812	18211.5