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

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

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
firebrat	13	4	814	(None)
fireboat	13	4	909	1	fireboat
firebrats	14	4	589	1	firebrats
fireboats	14	4	642	2	fireboats
firebrand	15	4	463	2	firebrand
firebreak	18	6	326	2	firebreak
firetrap	13	4	486	2	firetrap
airboat	9	5	1213	3	air_boat
bareboat	12	4	995	3	bareboat
cerebra	11	5	593	3	cerebra_
cerebral	12	6	618	3	cerebral
cerebrate	13	4	865	3	cerebrate
filbert	12	4	1164	3	filber_t
firearm	12	3	720	3	firear_m
firearms	13	3	540	3	firearms
fireback	19	4	695	3	fireback
fireball	13	12	726	3	fireball
firebase	13	4	649	3	firebase
firebird	14	4	463	3	firebird
firebirds	15	4	402	3	firebirds
fireboard	15	4	661	3	fireboard
firebomb	17	4	341	3	firebomb
firebox	19	4	445	3	fireb_ox
firebrands	16	4	374	3	firebrands
firebreaks	19	7	288	3	firebreaks
firebrick	20	4	258	3	firebrick
firebug	13	8	379	3	fireb_ug
firebugs	14	11	382	3	firebugs
fireclay	16	4	418	3	fireclay
firedrake	17	4	346	3	firedrake
firelit	10	3	1086	3	fire_lit
fireman	12	4	933	3	fire_man
firepan	12	3	698	3	fire_pan
firepot	12	4	873	3	fire_pot
firer	8	112	2925	3	fire_r__
firers	9	49	2268	3	fire_r_s
firetraps	14	4	430	3	firetraps
forebay	15	3	813	3	foreb_ay
forebear	13	4	638	3	forebear
forebrain	14	4	516	3	forebrain
forepart	13	4	970	3	forepart
foreran	10	3	1179	3	fore_ran
iceboat	11	4	716	3	_iceboat
lifeboat	13	4	493	3	lifeboat
wiredraw	15	5	351	3	wiredraw

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	146162	0.860	207780.2
2	DLD Change Limit	146162	45	7.000	20880.3
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	7.876	22688.0