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

219 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
foals8572169(None) 
coals76129601coals
foal76630921foal_
foams105017951foams
foils85025811foils
fools86824201fools
fouls87221431fouls
fowls115518891fowls
goals65521291goals
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
fabs98635862f_abs
fads86939872f_ads
fags86939122f_ags
fails85631482fails
fall75535312f_all
falls85727652falls
false84818122f_alse
falx147120782f_alx
fans76247372f_ans
farls85731112farls
fas68262932f_a_s
fats76252502f_ats
fays108535362f_ays
feal713940422feal_
fears84829392fears
feats86432752feats
feels85223042feels
fells85327382fells
ferals94216642ferals
fiars86720832fiars
fiats85324482fiats
fills84632372fills
fils75838692f_ils
finals94316162finals
flabs105818642flabs
flags95321282flags
flails94313002flails
flams105125012flams
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flays116321052flays
floats96816252floats
florals104210062florals
foaled104515962foaled
foam97127172foa_m
foamy135313202foamy
fobs96034272fo_bs
focal104917672focal_
focus105815882focus
foes76543442fo_es
fogs87035002fo_gs
fohns117310782fohns
foil76433912foil_
foins85523382foins
fold86528942fo_ld
folds95221692folds
folk116021542fo_lk
folks126017122folks
folles93820472folles
follis93113902follis
folly115022602folly
fonds95824822fonds
fons76943892fo_ns
fonts86124752fonts
foods95924162foods
fool75330592fool_
foots85528282foots
fops96532682fo_ps
forams115115912forams
forays124813002forays
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
formals123312892formals
forms105327052forms
forts86034452forts
foss76431642fo_ss
foul77027582foul_
fours85521492fours
fowl105723632fowl_
foxes156321092foxes
foys105628292fo_ys
frags96322172frags
frails93716472frails
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
fuels87117352fuels
fulls84623522fulls
furls85322052furls
gals57946502_gals
gaols66717572gaols
goads77022852goads
goal55829302goal_
goas55239942goa_s
goats65527302goats
gorals76917652gorals
heals85733452heals
hoars85925552hoars
hols76946292ho_ls
howls116219222howls
jouals1338922jouals
jowls156214522jowls
koala95112212koala
koalas104011662koalas
koans95818622koans
koas85635092koa_s
koels94613902koels
kohls12437802kohls
kolas94822232kolas
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
locals83714502locals
lolls512121732lolls
meals75933372meals
moans74624372moans
moas65545342moa_s
moats75827642moats
modals93914452modals
moils76125752moils
molas75132092molas
molls75129782molls
mols65948572mo_ls
mools76027172mools
morals85324632morals
noels56418702noels
noils55024332noils
nopals84914022nopals
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oats46554212_oats
ofays11488922ofays
offals1235892offals
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
seals54839692seals
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.0931921408.6
2DLD Change Limit538002191.64032804.9
3Display Results2192190.0633476.2
 (SQL Overall)1786912191.79699493.9
 
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.