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

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

82 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
unharvested	18	5	211	(None)
harvested	16	4	409	2	__harvested
unharnessed	15	5	340	2	unharnessed
harvester	15	4	433	3	__harvester
unattested	11	4	337	3	un_attested
unaverted	13	3	656	3	un_a_verted
uncarpeted	15	4	439	3	uncarpe_ted
unforested	14	4	480	3	unfor_ested
unharnesses	14	4	543	3	unharnesses
unrested	9	19	1451	3	un__r_ested
unvested	12	22	1022	3	un___vested
arrested	9	3	915	4	___arrested
harnessed	13	18	619	4	__harnessed
harvest	13	21	1275	4	__harvest__
harvesters	16	4	414	4	__harvesters
harvestmen	18	5	234	4	__harvestmen
harvests	14	24	617	4	__harvest_s
interested	11	4	1033	4	inter_ested
invested	12	22	969	4	in___vested
nonvested	13	4	600	4	_n_onvested
overharvested	23	6	180	4	overharvested
rearrested	11	4	512	4	_rearrested
unabetted	12	4	499	4	un_a_betted
unaccented	15	4	428	4	un_accented
unaccepted	17	4	338	4	un_accepted
unadjusted	19	4	249	4	un_adjusted
unadvised	14	4	328	4	un_advis_ed
unaffected	19	4	294	4	un_affected
unalerted	10	4	796	4	un_a_lerted
unaroused	10	4	652	4	un_arous_ed
unassisted	11	4	383	4	un_assisted
unavenged	14	4	366	4	un_a_venged
unballasted	14	5	167	4	unballasted
unbarbered	15	4	288	4	unbarbe_red
unbasted	11	25	1007	4	unba___sted
uncarted	11	3	1205	4	uncar___ted
uncarved	14	3	816	4	uncarv___ed
uncharted	15	3	808	4	unchar___ted
unchartered	17	4	283	4	uncharte_red
uncontested	14	4	456	4	uncontested
unconverted	17	4	477	4	unconverted
uncorrected	16	5	395	4	uncorrected
uncorseted	13	4	515	4	uncorse_ted
uncreated	12	3	1230	4	un_cr_eated
underheated	16	4	701	4	underheated
undervest	13	9	867	4	undervest__
undervests	14	6	474	4	undervest_s
undigested	13	12	384	4	un_digested
undirected	14	4	502	4	undir_ected
undressed	11	3	834	4	un_dr_essed
unfermented	17	4	386	4	unfermented
ungarnished	16	5	235	4	ungarnished
unhalved	15	5	651	4	unhalv___ed
unhampered	18	5	313	4	unhampe_red
unharmed	14	3	809	4	unhar___med
unharness	12	4	525	4	unharnes__s
unharried	13	4	476	4	unhar__ried
unhatted	12	3	818	4	unha___tted
unheated	12	15	1455	4	unh___eated
unhorsed	12	3	883	4	unhor__s_ed
unlamented	13	4	435	4	unla_mented
unmolested	13	4	378	4	un_molested
unparted	11	3	1082	4	unpar___ted
unpressed	12	3	795	4	un_pr_essed
unraveled	13	4	554	4	unra_ve_led
unravelled	14	4	386	4	unra_velled
unravished	17	4	277	4	unra_vished
unrented	9	24	1392	4	un__r_ented
unroasted	10	3	661	4	un__roasted
unrusted	9	23	1035	4	un__r_usted
unstressed	11	4	508	4	unstr_essed
untalented	11	4	484	4	unta_lented
untarnished	15	5	308	4	untarnished
untasted	9	20	1157	4	unta___sted
untested	9	26	1241	4	un___tested
untraveled	14	4	440	4	untrave_led
untraversed	15	5	308	4	untraversed
untreated	10	3	1290	4	un_tr_eated
unvarnished	18	5	228	4	unvarnished
unwariest	12	4	603	4	unwariest__
unwarranted	15	5	222	4	unwarranted
unwasted	12	25	978	4	unwa___sted

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	82	8.970	16590.7
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	9.452	18905.1