Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

Here are the results of your fuzzy-string dictionary search for “gorse” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
gorse6592681(None) 
corse75036181corse
goose65925901goose
gore55744961gor_e
gores65740371gores
gorge76423891gorge
gorses74723291gorses
gorsy95915781gorsy
horse86132651horse
morse76032701morse
torse55833331torse
worse86525261worse
agorae7511202agorae
ahorse9311512ahorse
arose55832082arose
arse46539272_arse
birse74517402birse
bore66051332bor_e
bores76448252bores
borne77926792borne
bourse84414332bourse
bouse75931852bouse
bowse105420632bowse
brose75227032brose
burse75527252burse
carse74934332carse
coarse84813902coarse
copse95623932copse
core67263112cor_e
cores76361852cores
corpse104013412corpse
cors66656442cors_
corses84433462corses
corset85636222corset
course85117782course
curse75829142curse
dore56353302dor_e
dors56747602dors_
dorsa64617282dorsa
dorsel75315502dorsel
dorser74819182dorser
dose56442432do_se
douse66329722douse
dowse96020812dowse
erose55727282erose
force105324272force
fore78351472for_e
fores85847102fores
forge95126942forge
forme105225992forme
forte86131462forte
fosse86119462fosse
gars55750742gars_
geese64316002geese
girsh95310022girsh
goas55239942goas_
gobs76935572gobs_
gods65438042gods_
goers65520252goers_
goes55644092goes_
gone55639042go_ne
goos57644912goos_
goosed86817032goosed
gooses75723062gooses
goosey105913512goosey
goosy96018882goosy
gor47848262gor__
goral65125752goral
gored75227082gored
gorged95016982gorged
gorger86116982gorger
gorges85321892gorges
gorget87123862gorget
gorhen1038902gorhen
gorier73719372gorier
gorm75529392gor_m
gormed105013832gormed
gorms85619592gorms
gorp75625902gor_p
gorps85316992gorps
gorsier83811072gorsier
gory86129662gor_y
gos47155132go_s_
gosh86123422go_sh
gouge78220062gouge
gourde8107932gourde
goxes135018262goxes
goys86328412goys_
gree56641562g_ree
grope84821612grope
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grouse74315022grouse
grove95219332grove
grue55825712g_rue
guise64717712guise
gurge75419782gurge
gursh94512332gursh
gyrase10508772gyrase
gyre84722762gyr_e
gyres94820322gyres
gyrose105310252gyrose
hoarse94411322hoarse
hoise85224772hoise
horde94623052horde
horsed105321082horsed
horses94729352horses
horsey125115402horsey
horst85833512horst
horste94817412horste
horsy116318392horsy
hose76547242ho_se
house89131422house
kore85834162kor_e
kors85933012kors_
loose56627682loose
lore45850352lor_e
lores55045402lores
lose45144582lo_se
louse56131012louse
lowse87219902lowse
marse76231152marse
moose76327192moose
morae75831192morae
more67154522mor_e
mores76249642mores
morose85116242morose
mors65950062mors_
morsel85815892morsel
mouse77133002mouse
noise55723732noise
noose55624062noose
nose46739362no_se
nurse54420122nurse
ogre56320742ogr_e
ogres65818632ogres
oorie53026362oorie
ore36661832_or_e
ores46056682_ores
orle45630462_orle
ors35750112_ors_
ose38147342_o_se
owse76321622_owse
parse75236992parse
perse75429522perse
poise75127892poise
pore66451262por_e
pores75849032pores
porose84818742porose
pose66441732po_se
posse74722272posse
prose75835122prose
purse76028892purse
roose56127092roose
rose46148902ro_se
rouse56634702rouse
sore47059532sor_e
sores55454282sores
souse56530772souse
terse55026822terse
tore47359322tor_e
tores55352672tores
torose64317692torose
tors46157382tors_
torses64727952torses
torsi57423362torsi
torsk94915772torsk
torso56922142torso
torte55431702torte
touse55430672touse
verse84723582verse
wore77144672wor_e
worsen95513872worsen
worser95117522worser
worses95522952worses
worset96726582worset
worst86330132worst
yore76335942yor_e
yores85031322yores
youse85322232youse

Search took 5 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.686260482.5
2DLD Change Limit538001813.18616886.4
3Display Results1811810.236766.9
 (SQL Overall)1786911814.10843498.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.