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

225 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
goals6552129(None) 
coals76129601coals
foals85721691foals
gals57946501g_als
gaols66717571gaols
goads77022851goads
goal55829301goal_
goas55239941goa_s
goats65527301goats
gorals76917651gorals
aals49941142_aals
als36663022__als
baals76122702baals
bals66354042_bals
boars75229602boars
boas66150832boa_s
boats75635152boats
boils75427192boils
bolas74733762bolas
bolls75531312bolls
borals86721912borals
bowls106121432bowls
coal66939252coal_
coala77521122coala
coalas87418962coalas
coaly105521592coaly
coats75635002coats
coils75030082coils
colas75436772colas
cols66553082co_ls
cools75632632cools
copals105018942copals
corals85325142corals
cowls106922212cowls
dals57145122_dals
deals65435342deals
dhals95415442dhals
dials64925342dials
doats65224882doats
dolls66126922dolls
dols56943052do_ls
duals65620082duals
foal76630922foal_
foams105017952foams
foils85025812foils
fools86824202fools
fouls87221432fouls
fowls115518892fowls
gabs76740422g_abs
gads67843382g_ads
gaes56348032g_aes
gags66441062g_ags
gal46055512g_al_
gala55635162g_ala
galas65731642g_alas
gale56347322g_ale
gales65442482g_ales
gall56335992g_all
galls64729322galls
gams76648882g_ams
gaol56925412gaol_
gaps76042972g_aps
gars55750742g_ars
gas48870252g_a_s
gats56753442g_ats
gayals1039512gayals
gays87338022g_ays
gears64628692gears
gels56836102g_els
ghats95818612ghats
ghouls1036042ghouls
gills64728192gills
girls64518392girls
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gloams95210662gloams
gloats74515422gloats
gnarls74210772gnarls
gnars66718852gnars
gnats65217712gnats
gnaws96311142gnaws
goa47343802goa__
goad66830982goa_d
goaled85014362goaled
goalie7413162goalie
goalies8316022goalies
goat56250832goa_t
gobans94412042gobans
gobos86219382gobos
gobs76935572go_bs
godly104913292godly
gods65438042go_ds
goers65520252goers
goes55644092go_es
gogos77516522gogos
gold65430162go_ld
golds75421312golds
golf85731182go_lf
golfs95616102golfs
golly95121102golly
gonads84511732gonads
gongs74921612gongs
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goorals838712goorals
goos57644912go_os
goral65125752goral_
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132go__s
goths96513002goths
gouts64826172gouts
gowans105512292gowans
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
graals74112912graals
grabs85719692grabs
grads75625752grads
grails77518782grails
grams85327312grams
grans64832542grans
grass66125202grass
grays95621332grays
groans74815062groans
groats74816652groats
growls104711112growls
guans64419442guans
guars65021052guars
gulls65222982gulls
guls55930852g_uls
heals85733462heals
hoars85925552hoars
hols76946292ho_ls
howls116219222howls
jouals1338932jouals
jowls156214522jowls
koala95112212koala
koalas104011662koalas
koans95818622koans
koas85635092koa_s
koels94613902koels
kohls12437802kohls
kolas94822232kolas
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
locals83714502locals
lolls512121732lolls
meals75933382meals
moans74624372moans
moas65545342moa_s
moats75827642moats
modals93914462modals
moils76125752moils
molas75132092molas
molls75129782molls
mols65948572mo_ls
mools76027172mools
morals85324642morals
noels56418702noels
noils55024332noils
nopals84914022nopals
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oats46554212_oats
ogams84112682ogams
oils46337972_oils
opals75718352opals
orals55826482orals
ovals85413392ovals
owls76022932_owls
pals66951352_pals
peals75235492peals
polls74627722polls
pols66044562po_ls
pools74427702pools
reals55038652reals
rials55026672rials
roads66523622roads
roams74919612roams
roans54926442roans
roars55622242roars
roils54826792roils
rolls55326232rolls
rotls55620162rotls
royals93711262royals
sals46851672_sals
seals54839702seals
shoals94215792shoals
sials54227242sials
skoals10438242skoals
soaks95220292soaks
soaps75120712soaps
soars54732512soars
soils55327982soils
sols45448162so_ls
souls55127362souls
teals56234132teals
toads65621072toads
toils54527492toils
tolas54532772tolas
tolls54728432tolls
tools55325242tools
totals63115162totals
veals84926192veals
vials85822382vials
vocals113811582vocals
weals85428742weals
woads94818442woads
woald94813072woald
woalds10427582woalds
wools84421462wools
yowls115715432yowls
zeals145320852zeals

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 Filter178691538000.313570897.8
2DLD Change Limit538002251.59033836.5
3Display Results2252250.0633571.4
 (SQL Overall)1786912251.96690890.6
 
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.