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

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

62 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
pilothouses	16	9	321	(None)
pilothouse	15	8	309	1	pilothouse_
pothouses	14	4	904	2	p__othouses
flophouses	18	5	396	3	_flophouses
hothouses	15	4	776	3	__hothouses
lighthouses	18	5	297	3	lighthouses
millhouses	15	4	407	3	mil_lhouses
penthouses	15	4	661	3	p_enthouses
pesthouses	15	4	624	3	p_esthouses
playhouses	18	4	387	3	p_layhouses
poorhouses	15	4	529	3	p_oorhouses
pothouse	13	4	870	3	p__othouse_
ailanthuses	14	5	184	4	ailanth_uses
alehouses	12	4	658	4	_al_ehouses
almshouses	15	5	267	4	_almshouses
birdhouses	16	4	332	4	bi_rdhouses
blockhouses	22	5	250	4	_blockhouses
boathouses	15	4	592	4	_boathouses
cathouses	14	3	943	4	__cathouses
chophouses	20	4	514	4	_chophouses
clubhouses	17	4	284	4	_clubhouses
cookhouses	19	4	460	4	_cookhouses
courthouses	16	5	395	4	courthouses
dianthuses	14	4	275	4	dianth_uses
doghouses	14	4	535	4	__doghouses
dollhouses	14	4	405	4	dol_lhouses
filoviruses	17	5	198	4	filoviruses
firehouses	16	13	515	4	fi_rehouses
flophouse	17	4	410	4	_flophouse_
hothouse	14	4	735	4	__hothouse_
hothoused	16	4	476	4	__hothoused
icehouses	14	4	501	4	_i_cehouses
isthmuses	14	4	297	4	_i_sthmuses
jailhouses	20	4	300	4	jail__houses
kilojoules	21	5	137	4	kilo_joules
lighthouse	17	5	327	4	lighthouse_
longhouses	14	4	498	4	__longhouses
lotoses	7	37	1364	4	__lot_o_ses
lotuses	7	40	1125	4	__lot__uses
millhouse	14	4	390	4	mil_lhouse_
nuthouses	12	4	634	4	__nuthouses
oasthouses	13	4	497	4	_oasthouses
outhouses	12	3	1066	4	__outhouses
pathoses	13	4	1277	4	p__atho_ses
peloruses	11	4	587	4	pelo__ruses
penthouse	14	4	626	4	p_enthouse_
pesthouse	14	4	596	4	p_esthouse_
pilotages	12	4	550	4	pilot__ages
pilotfishes	19	6	213	4	pilotfishes
pilotless	11	4	399	4	pilot_les_s
platypuses	17	5	162	4	p_latypuses
playhouse	17	4	393	4	p_layhouse_
poorhouse	14	4	531	4	p_oorhouse_
potholes	13	3	1293	4	p__otho_les
powerhouses	19	5	247	4	powerhouses
proteoses	11	22	1101	4	p_roteo_ses
proteuses	11	23	899	4	p_rot_euses
protheses	14	4	907	4	p_roth_eses
pyloruses	14	4	381	4	pylo__ruses
tollhouses	13	4	455	4	tol_lhouses
toolhouses	13	4	457	4	_toolhouses
wellhouses	16	4	378	4	wel_lhouses

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.406	440125.6
2	DLD Change Limit	148819	62	9.266	16060.8
3	Display Results	62	62	0.030	2066.7
	(SQL Overall)	178691	62	9.702	18418.0