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

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

65 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
defrosted	14	4	426	(None)
defroster	13	4	390	1	defroster
deforested	15	4	385	2	deforested
defrocked	20	4	306	2	defrocked
defrost	11	3	955	2	defrost__
defrosters	14	4	336	2	defrosters
defrosts	12	4	483	2	defrost_s
frosted	11	32	1188	2	__frosted
refronted	13	3	606	2	refronted
affronted	16	4	250	3	affronted
becrusted	14	4	395	3	becrusted
befretted	15	4	437	3	befretted
decocted	14	3	769	3	de_cocted
decorated	13	3	1221	3	decorated
decrowned	16	6	366	3	decrowned
decrypted	18	4	277	3	decrypted
defatted	13	3	567	3	def_atted
defaulted	14	4	331	3	defaulted
defeated	13	28	1216	3	def_eated
defecated	16	3	749	3	defecated
defected	15	28	997	3	def_ected
defensed	13	3	622	3	defens_ed
deflated	13	34	1230	3	def_lated
deflected	16	3	598	3	deflected
defoamed	15	35	624	3	def_oamed
defogged	15	3	378	3	def_ogged
deforced	15	24	737	3	def_orced
deformed	15	24	826	3	def_ormed
defragged	16	4	304	3	defragged
defrauded	15	4	282	3	defrauded
defrayed	16	3	540	3	defr_ayed
defrosting	15	4	449	3	defrosting
defused	12	52	1109	3	def_us_ed
degusted	11	3	573	3	de_gusted
dehorted	13	5	730	3	de_horted
delisted	10	3	1056	3	de_listed
demasted	12	3	876	3	de_masted
demoted	11	43	1354	3	de_mo_ted
denoted	9	35	1276	3	de_no_ted
deorbited	13	4	398	3	deorbited
deported	12	4	970	3	de_ported
deposed	11	34	1203	3	de_pos_ed
deposited	13	4	678	3	de_posited
depressed	13	5	763	3	depressed
derated	9	36	2350	3	de_r_ated
deratted	10	4	840	3	de_ratted
derogated	12	3	868	3	de_rogated
desisted	10	3	978	3	de_sisted
detested	10	27	962	3	de_tested
detracted	13	5	779	3	detracted
devested	13	23	913	3	de_vested
devoted	12	41	1109	3	de_vo_ted
disrooted	11	4	762	3	disrooted
enrooted	9	7	743	3	_enrooted
fronted	11	40	1127	3	__fronted
frosteds	12	30	566	3	__frosteds
frowsted	15	3	432	3	__frowsted
necrosed	11	3	722	3	necros_ed
oersted	8	3	956	3	oe_r_sted
recrossed	12	4	652	3	recrossed
refloated	13	4	701	3	refloated
reforested	14	4	539	3	reforested
refracted	15	5	739	3	refracted
refreshed	16	8	562	3	refreshed
rerouted	9	3	1115	3	re_routed

Search took 8 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	148641	0.420	425454.8
2	DLD Change Limit	148641	65	7.140	20818.1
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	7.593	23533.6