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 “goal” 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.

256 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
goal5582930(None) 
coal66939251coal
foal76630921foal
gal46055511g_al
gaol56925411gaol
goa47343801goa_
goad66830981goad
goals65521291goals
goas55239941goas
goat56250831goat
goral65125751goral
aal39058672_aal
agonal7410052agonal
al210674042__al
anal48037522anal
axal116520492axal
baal67033112baal
bal56662722_bal
boa56954032boa_
boar66134292boar
boas66150832boas
boat66360312boat
boil66335182boil
bola66035562bola
boll65634752boll
boral75831702boral
bowl96827702bowl
coala77521122coala
coals76129602coals
coaly105521592coaly
coat67558342coat
coax136922972coax
coil66439652coil
col59360352co_l
cola66541392cola
comal95125132comal
cool66940492cool
copal95621782copal
coral76033452coral
cowl97530812cowl
coxal146116672coxal
dal47554952_dal
deal56347412deal
dhal86719282dhal
dial55935062dial
doat56947672doat
dol47150652do_l
doll56632492doll
domal85619202domal
dotal64919622dotal
dual55928172dual
egal55119432egal
feal713940422feal
foals85721692foals
foam97127172foam
focal104917672focal
foil76433912foil
fool75330592fool
foul77027582foul
fowl105723632fowl
gab67155992g_ab
gad57556652g_ad
gae46457702g_ae
gag57753632g_ag
gala55635162g_ala
gale56347322g_ale
gall56335992gall
gals57946502g_als
gam67060062g_am
gan48060122g_an
gaols66717572gaols
gap67055612g_ap
gar47259902g_ar
gas48870252g_as
gat46880512g_at
gay76856492g_ay
gayal9312712gayal
gear55934972gear
gel45642432g_el
ghat86435282ghat
ghoul959052ghoul
gill56336182gill
girl56226552girl
glad65624012glad
glam76529342glam
glial66715432glial
gloam86015942gloam
gloat65427682gloat
global937662global
gnar56021382gnar
gnarl65115572gnarl
gnat56034432gnat
gnaw86515742gnaw
go38748742go__
goads77022852goads
goaled85014352goaled
goalie7413152goalie
goats65527302goats
gob68950892go_b
goban84414072goban
gobo76126892gobo
gobs76935572gobs
goby106021082goby
god57449792go_d
godly104913292godly
gods65438042gods
goer56827102goer
goes55644092goes
gogo69722832gogo
gold65430162gold
golf85731182golf
golly95121102golly
gonad75216052gonad
gone55639042gone
gong66827192gong
goo47754772go_o
good66531802good
goof85436872goof
gook96429602gook
goon57236172goon
goop75829482goop
gooral7310462gooral
goos57644912goos
gor47848262go_r
gorals76917652gorals
gore55744962gore
gorm75529392gorm
gorp75625902gorp
gory86129662gory
gos47155132go_s
gosh86123422gosh
got49870442go_t
goth86825082goth
gout56646002gout
gowan95415742gowan
gowd96519982gowd
gowk125516472gowk
gown85724072gown
gox117137182go_x
goy77844552go_y
goys86328412goys
graal64316502graal
grab75427612grab
grad66829862grad
grail64622872grail
gram77034582gram
gran56335012gran
grat55651282grat
gray85329892gray
groan65618422groan
groat65531972groat
growl96115822growl
guan55325582guan
guar56923292guar
gul45832792g_ul
gull54828452gull
gyral94412782gyral
heal75645692heal
hoar76729162hoar
hoax147718292hoax
horal86328672horal
howl107625692howl
joual12311652joual
jowl146120302jowl
koa76737772koa_
koala95112212koala
koan85425032koan
koas85635092koas
koel84519942koel
kohl113911712kohl
kola85124962kola
leal46043272leal
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
local74820272local
loll46128382loll
loral55927822loral
loyal84513482loyal
meal65643172meal
moa57249182moa_
moan65832012moan
moas65545342moas
moat66352032moat
modal85919232modal
moil65534092moil
mol56654592mo_l
mola66035632mola
molal75120342molal
moll66735702moll
mool67533862mool
moral75533432moral
nodal64717792nodal
noel45226552noel
noil46133242noil
nopal75517102nopal
notal55221352notal
oaf65952882_oaf
oak76238652_oak
oar37057952_oar
oat39888262_oat
ogam75120032ogam
oil37452052_oil
opal66923522opal
oral47638122oral
oval77119522oval
owl66228972_owl
pal56761672_pal
peal68648102peal
pial65636702pial
pol56449382po_l
poll66332132poll
pool65835952pool
real45750292real
rial45938092rial
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
roil46235292roil
roll46331652roll
rotl45029682rotl
royal85014702royal
sal36462882_sal
seal45654372seal
shoal83920262shoal
sial45938832sial
skoal93811452skoal
soak87227662soak
soap65831132soap
soar46838672soar
soil46138822soil
sol37256622so_l
sola45541862sola
soul46435712soul
teal45546502teal
toad55830182toad
toil46536282toil
tola45236332tola
toll45535262toll
tonal53724302tonal
tool46735682tool
total55321822total
veal76936812veal
vial76731092vial
vocal104715642vocal
weal75838682weal
woad85523942woad
woald94813072woald
wool76427372wool
yowl105820952yowl
zeal135530332zeal
zoa128529992zoa_
zoeal144813782zoeal
zonal145116852zonal

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298722560.96630923.4
3Display Results2562560.0634063.5
 (SQL Overall)1786912561.109161128.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.