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

Here are the results of your fuzzy-string dictionary search for “housepainters” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

45 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
housepainters	18	6	112	(None)
housepainter	17	6	144	1	housepainter_
housemasters	17	15	362	3	housema_sters
houseboaters	17	5	247	4	house_boaters
housefathers	21	5	182	4	housefa_thers
housemaster	16	16	358	4	housema_ster_
housemates	15	4	613	4	housema__te_s
houseparents	17	6	213	4	houseparent__s
houseplants	16	5	311	4	houseplant__s
consenters	12	4	1084	5	conse___nters
covenanters	16	8	296	5	co_vena_nters
horsehairs	16	8	368	5	horsehai___rs
horsemints	15	4	398	5	horse_mint__s
horseplayers	20	5	174	5	horsep_layers
horsepowers	19	5	293	5	horsep__owers
horsewhippers	26	15	134	5	horsewhippers
hosepipes	16	4	462	5	ho_sep_i_pe_s
houseboater	16	5	291	5	house_boater_
housebreakers	22	6	213	5	housebreakers
housefather	20	5	199	5	housefa_ther_
houseflies	16	4	475	5	housefli__e_s
housefronts	17	5	231	5	housefront__s
householders	19	5	285	5	house_holders
housekeepers	21	9	237	5	house_keepers
housemaids	16	5	351	5	housemai___ds
housemate	14	4	594	5	housema__te__
housemothers	20	6	208	5	house_mothers
houseparent	16	5	309	5	housepa__rent
houseplant	15	5	393	5	houseplant___
housesits	12	4	484	5	house_si_t__s
housewares	16	4	541	5	housewa__re_s
housewifery	23	12	166	5	house_wi_fery
housewives	19	4	352	5	house_wi_ve_s
husbanders	16	5	291	5	h_us_ba_nders
mountaineers	14	12	250	5	mou_ntaineers
outpainted	13	4	432	5	_ou_tpainte_d
outpaints	11	4	528	5	_ou_tpaint__s
overwinters	17	4	340	5	_o_verwinters
painters	10	30	1302	5	_____painters
reprinters	12	9	579	5	___reprinters
semainiers	12	4	338	5	___semainiers
splinters	11	27	792	5	___s_plinters
sprinters	11	32	936	5	___s_printers
sustainers	10	4	413	5	_sus_tain_ers
teleprinters	14	5	171	5	_teleprinters

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	124790	0.390	458182.1
2	DLD Change Limit	124790	45	8.956	13933.7
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	9.376	19058.3