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

331 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
coal6693925(None) 
coala77521121coala
coals76129601coals
coaly105521591coaly
coat67558341coat
coax136922971coax
coil66439651coil
col59360351co_l
cola66541391cola
comal95125131comal
cool66940491cool
copal95621781copal
coral76033451coral
cowl97530811cowl
coxal146116671coxal
foal76630921foal
goal55829301goal
aal39058672_aal
al210674042__al
anal48037522anal
axal116520492axal
baal67033112baal
bal56662722_bal
boa56954032boa_
boar66134292boar
boas66150832boas
boat66360312boat
boil66335182boil
bola66035562bola
boll65634752boll
boral75831702boral
bowl96827702bowl
cab78355402c_ab
cabal95222152cabal
cad67456362c_ad
calf96339562c_alf
calk105527662c_alk
call66838672call
calm85032362c_alm
calo64936442c_alo
calx135722792c_alx
cam78058982c_am
can57760132c_an
canal75428042canal
cap76758982c_ap
car59165562c_ar
carl65144782carl
cat58282342c_at
caul65630002caul
caw86647932c_aw
cay87155982c_ay
cecal94619112cecal
ceil65725062ceil
cel56040552c_el
cell65031722cell
ceorl7410912ceorl
chad105525502chad
chai95929902chai
chalk144814602chalk
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
chola104718032chola
choral115118492choral
ciao64924182ciao
clad76225822clad
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
claw95624342claw
clay95927412clay
cloak115214012cloak
clonal8310912clonal
coach125919452coach
coact96130572coact
coalas87418962coalas
coaled95022702coaled
coaler84121702coaler
coapt96131522coapt
coast75236262coast
coati75624632coati
coats75634992coats
coaxal15387302coaxal
cob710258752co_b
cobalt10317392cobalt
cobb106422002cobb
coble94823172coble
cobs87043142cobs
coca88030642coca
cocas95926572cocas
coccal9310222coccal
cock126332902cock
coco87330602coco
cod69660122co_d
coda77029342coda
codas84724242codas
code77347732code
cods76848102cods
coed77140542coed
coeval1138892coeval
coff126930782coff
coft97939682coft
cog69552902co_g
cogs77340032cogs
coho97524492coho
coif96337912coif
coils75030082coils
coin66645352coin
coir66327242coir
coital84117052coital
coke107038382coke
coky137526822coky
colas75436772colas
cold77338772cold
cole66956112cole
colly104926772colly
cols66553082cols
colt67158242colt
coly96940532coly
coma87134852coma
comae97128422comae
comas95833002comas
comb106632112comb
come87547702come
comp106731252comp
con510268022co_n
cone67256962cone
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
cony96537832cony
coo59566362co_o
coof96643272coof
cook107236932cook
cools75632632cools
cooly105525422cooly
coon67248942coon
coop87238652coop
coos67456492coos
coot67860382coot
cop711162372co_p
copalm125010812copalm
copals105018942copals
copay126516312copay
cope86847382cope
cops86751372cops
copy116229802copy
cor59960942co_r
corals85325142corals
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
corral83616252corral
cors66656442cors
cory96941512cory
cos510270392co_s
cosh96127622cosh
coss66143492coss
cost68057942cost
costal85419512costal
cosy97232702cosy
cot510483222co_t
cotan71521782cotan
cote66648732cote
cots68054842cots
could86517712could
coup86729792coup
cove95837072cove
cow89856712co_w
cowls106922212cowls
cows97046642cows
cowy126427362cowy
cox1210346782co_x
coxa136922962coxa
coxae146115182coxae
coy810557552co_y
coyly135614892coyly
coys97537242coys
coz149345362co_z
cozy185823802cozy
craal74117752craal
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
crawl104916712crawl
croak115216632croak
cull65929642cull
curl66035052curl
cyan96419622cyan
czar156013132czar
dal47554952_dal
deal56347412deal
dhal86719282dhal
dial55935062dial
doat56947672doat
dol47150652do_l
doll56632492doll
domal85619202domal
dotal64919622dotal
dual55928172dual
egal55119432egal
feal713940422feal
foals85721692foals
foam97127172foam
focal104917672focal
foil76433912foil
fool75330592fool
foul77027582foul
fowl105723632fowl
gal46055512_gal
gaol56925412gaol
goa47343802goa_
goad66830982goad
goals65521292goals
goas55239942goas
goat56250832goat
goral65125752goral
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
oca56731732oca_
ocas66729632ocas
octal71214722octal
oil37452052_oil
opal66923522opal
oral47638122oral
oval77119522oval
owl66228972_owl
pal56761672_pal
peal68648102peal
pial65636702pial
pol56449382po_l
poll66332132poll
pool65835952pool
real45750292real
recoal84117972recoal
rial45938092rial
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
roil46235292roil
roll46331652roll
rotl45029682rotl
royal85014702royal
sal36462882_sal
scowl1012012972scowl
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 Limit298723310.87334217.6
3Display Results3313310.0804137.5
 (SQL Overall)1786913311.033172982.6
 
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.