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

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

74 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
publishes	16	4	593	(None)
published	17	4	434	1	published
publisher	16	4	421	1	publisher
publishers	17	4	352	1	publishers
copublishes	20	5	237	2	copublishes
polishes	13	7	1178	2	p_olishes
publish	14	4	791	2	publish__
punishes	13	3	811	2	pu_nishes
pupfishes	19	4	431	2	pupfishes
republishes	18	5	313	2	republishes
rubbishes	16	4	430	2	rubbishes
abolishes	14	4	605	3	abolishes
blisses	9	49	1151	3	__blisses
blushes	12	43	1482	3	__blushes
bubalises	13	4	632	3	bubalis_es
burnishes	14	3	664	3	burnishes
copublished	21	5	198	3	copublished
copublisher	20	5	195	3	copublisher
copublishers	21	5	178	3	copublishers
cuishes	12	28	1082	3	cu__ishes
cullises	10	31	1131	3	cullis_es
englishes	13	4	510	3	englishes
furbishes	17	4	524	3	furbishes
furnishes	15	3	623	3	furnishes
hubrises	13	3	710	3	hubris_es
mudfishes	18	4	419	3	mudfishes
nebbishes	16	4	297	3	nebbishes
numbfishes	20	4	278	3	numbfishes
outblushes	15	4	346	3	outblushes
outfishes	15	11	802	3	outfishes
outwishes	15	12	656	3	outwishes
panfishes	17	3	759	3	panfishes
parishes	13	3	1475	3	p_arishes
pelisses	10	4	848	3	p_elisses
perishes	13	3	1375	3	p_erishes
pigfishes	18	4	500	3	pigfishes
pinfishes	17	4	624	3	pinfishes
pishes	11	47	2210	3	p___ishes
planishes	14	13	852	3	planishes
plashes	12	44	1739	3	p__lashes
plenishes	14	8	708	3	plenishes
plisses	9	44	1177	3	p__lisses
plushes	12	43	1367	3	p__lushes
polished	14	6	843	3	p_olished
polisher	13	8	807	3	p_olisher
polishers	14	7	760	3	p_olishers
publicans	15	4	411	3	publicans
publicise	15	4	422	3	publicise
publicises	16	4	424	3	publicises
publicizes	25	4	407	3	publicizes
publicness	16	4	245	3	publicness
publics	13	20	714	3	publi__cs
publishing	18	4	400	3	publishing
publishings	19	5	184	3	publishings
puisnes	9	3	742	3	pu__isnes
pulses	8	38	1866	3	pu_l_s_es
punished	14	3	604	3	pu_nished
punisher	13	3	577	3	pu_nisher
punishers	14	3	497	3	pu_nishers
purlines	10	35	1405	3	purli_nes
pushes	11	46	2166	3	pu___shes
relishes	11	3	1195	3	_relishes
republished	19	5	294	3	republished
republisher	18	5	270	3	republisher
republishers	19	5	224	3	republishers
stablishes	15	4	537	3	stablishes
sublimes	12	3	1003	3	subli_mes
sublines	10	3	1578	3	subli_nes
subniches	16	6	515	3	subniches
sunfishes	15	4	703	3	sunfishes
tundishes	13	4	454	3	tundishes
unlashes	11	23	804	3	_unlashes
unpublished	19	5	208	3	unpublished
unwishes	14	14	748	3	_unwishes

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.423	422437.4
2	DLD Change Limit	148641	74	6.796	21871.8
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	7.249	24650.4