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

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

34 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
photostating	18	13	584	(None)
photostatting	19	9	337	1	photostatting
photosetting	18	5	425	2	photosetting
photostatic	18	5	711	2	photostati_c
photoscanning	21	6	194	3	photoscanning
photostat	14	4	799	3	photostat___
photostated	17	6	586	3	photostat_ed
photostats	15	4	706	3	photostat__s
photostatted	18	6	334	3	photostatted
protonating	14	4	859	3	proto_nating
corotating	13	4	932	4	_coro_tating
outstating	11	3	936	4	__outstating
phenolating	17	4	525	4	pheno_lating
phonating	15	3	781	4	ph__o_nating
photocopying	25	6	374	4	photocopying
photographing	25	6	598	4	photographing
photoing	14	3	907	4	photo____ing
photolyzing	29	5	387	4	photo_lyzing
photomapping	21	6	247	4	photomapping
photoscan	16	5	505	4	photosca__n_
photoscans	17	5	546	4	photosca__ns
phototactic	20	5	529	4	photo_tacti_c
phototaxies	23	5	622	4	photo_taxies
phototaxis	22	5	650	4	photo_taxi_s
postdating	14	4	716	4	p___ostdating
postmating	15	4	860	4	p___ostmating
potentiating	15	5	428	4	p_otentiating
prorogating	15	5	606	4	proro_gating
prostrating	14	4	939	4	p__rostrating
protestation	14	5	636	4	protestation
protestations	15	5	581	4	protestations
protesting	13	19	1025	4	protes__ting
prototyping	19	5	385	4	proto_typing
thermostating	19	7	256	4	thermostating

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	124790	0.390	458182.1
2	DLD Change Limit	124790	34	7.376	16918.4
3	Display Results	34	34	0.013	2615.4
	(SQL Overall)	178691	34	7.779	22970.9