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

262 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
foal7663092(None) 
coal66939251coal
feal713940421feal
foals85721691foals
foam97127171foam
focal104917671focal
foil76433911foil
fool75330591fool
foul77027581foul
fowl105723631fowl
goal55829301goal
aal39058672_aal
afoul8510192afoul
al210674042__al
anal48037522anal
axal116520492axal
baal67033112baal
bal56662722_bal
boa56954032boa_
boar66134292boar
boas66150832boas
boat66360312boat
boil66335182boil
bola66035562bola
boll65634752boll
boral75831702boral
bowl96827702bowl
coala77521122coala
coals76129602coals
coaly105521592coaly
coat67558352coat
coax136922982coax
coil66439652coil
col59360352co_l
cola66541392cola
comal95125132comal
cool66940492cool
copal95621782copal
coral76033452coral
cowl97530812cowl
coxal146116672coxal
dal47554952_dal
deal56347412deal
dhal86719282dhal
dial55935062dial
doat56947672doat
dol47150652do_l
doll56632492doll
domal85619202domal
dotal64919622dotal
dual55928172dual
egal55119432egal
fa510148452f_a_
fab87453132f_ab
fad77452412f_ad
fag76852362f_ag
fail74840242fail
fall75535312fall
falx147120782f_alx
fan67158862f_an
far67762602f_ar
farl76338552farl
fas68262932f_as
fat68178082f_at
fatal84819372fatal
fax138143312f_ax
fay97454862f_ay
fear75337792fear
feat76458222feat
fecal105119212fecal
feel75233842feel
fell76833072fell
feral85424652feral
fetal85623372fetal
fiar76427332fiar
fiat76646642fiat
fil65447142f_il
fila74729132fila
fill75540192fill
final83922032final
flab96628352flab
flag87427082flag
flail85316182flail
flak116026172flak
flam96333292flam
flan76134182flan
flap96128702flap
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
float85928572float
floral94313812floral
foaled104515962foaled
foams105017952foams
foamy135313202foamy
fob86748332fo_b
fobs96034272fobs
foci94521012foci
foe66350812fo_e
foes76543442foes
foetal9311882foetal
fog76945562fo_g
fogs87035002fogs
fogy115923182fogy
foh98135892fo_h
fohn106116552fohn
foils85025812foils
foin77231562foin
fold86528942fold
folk116021542folk
folly115022602folly
fon66352272fo_n
fond86330952fond
fons76943892fons
font77143752font
fontal9313142fontal
food86830572food
fools86824202fools
foot76248012foot
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
foram105124932foram
foray115023972foray
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
formal113215202formal
fort76456442fort
foss76431642foss
fou66743782fo_u
fouls87221432fouls
four76226862four
foveal1237702foveal
fowls115518892fowls
fox136737862fo_x
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
frae75330472frae
frag85126272frag
frail85220212frail
frap95925812frap
frat75648542frat
fray105428902fray
fuel76824732fuel
fugal95613032fugal
full75229152full
furl77030882furl
gal46055512_gal
gaol56925412gaol
goa47343802goa_
goad66830982goad
goals65521292goals
goas55239942goas
goat56250832goat
goral65125752goral
heal75645692heal
hoar76729162hoar
hoax147718292hoax
horal86328682horal
howl107625692howl
joual12311652joual
jowl146120302jowl
koa76737772koa_
koala95112212koala
koan85425032koan
koas85635092koas
koel84519942koel
kohl113911712kohl
kola85124962kola
leal46043272leal
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
local74820272local
loll46128382loll
loral55927822loral
loyal84513482loyal
meal65643172meal
moa57249182moa_
moan65832022moan
moas65545342moas
moat66352032moat
modal85919242modal
moil65534092moil
mol56654592mo_l
mola66035632mola
molal75120342molal
moll66735702moll
mool67533862mool
moral75533432moral
nodal64717792nodal
noel45226552noel
noil46133242noil
nopal75517102nopal
notal55221352notal
oaf65952882_oaf
oak76238652_oak
oar37057952_oar
oat39888262_oat
ofay106416102ofay
offal1136242offal
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
shoal83920272shoal
sial45938832sial
skoal93811462skoal
soak87227662soak
soap65831132soap
soar46838672soar
soil46138832soil
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 3 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.326548131.9
2DLD Change Limit298722621.62618371.5
3Display Results2622620.1561679.5
 (SQL Overall)1786912622.10884768.0
 
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.