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 “plagal” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

303 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
plagal94857(None) 
algal66518222al_gal
lagan66520342_lagan
legal65715942_legal
pagan86121162p_agan
palatal9310152palatal
paleal84716672paleal
palpal104112052palpal
papal95820672p_apal
pelagial1146542pelagial
plage84520402plag_e
plages94520152plages
plague93610852plague
plaguy12386412plaguy
planar84212712planar
platan83913692platan
playa105812942playa_
playas114612282playas
plaza164311062plaza_
plazas17409912plazas
plexal1536842plexal
plical10411682plical
plural839822plural
vagal94613632_vagal
aal39058673__a_al
adagial946373adagial
aga410447233__aga_
agar58726413__agar
agas55938843__agas
alanyl955483alanyl
alegar739283alegar
alga57927603al_ga_
algae65319623al_gae
algas65624933al_gas
anal48037523__anal
apologal1144723apologal
argal65023393_argal
atabal839743atabal
axal116520493__axal
baal67033113_ba_al
bagel85116793_bagel
banal75925993_banal
basal75722283_basal
bharal1138893bharal
biaxal1536093biaxal
cabal95222153_cabal
canal75428043_canal
clag75924573clag__
clags85621123clag_s
clausal936273clausal
clinal8311553clinal
cloacal1135163cloacal
clonal8310913clonal
coaxal15387303coaxal
craal74117753cra_al
egal55119433__egal
fallal93612693fallal
fatal84819373_fatal
flag87427083flag__
flaggy14415923flaggy
flagman13186173flagman
flagon1037983flagon
flags95321283flag_s
flail85316183fla_il
floral94313813floral
frugal1036393frugal
fugal95613033_fugal
fungal10388733fungal
gaga66625553_gaga_
gal46055513___gal
galangal1043893galangal
gayal9312713_gayal
gingal81010153gingal
glacial1038143glacial
glial66715433gl_ial
global937663global
graal64316503gra_al
hadal95518123_hadal
halal85623593_halal
hallal94415563hallal
hamal104623113_hamal
hiatal9310203hiatal
ileal56118083il_eal
ilial55317843il_ial
illegal854763illegal
jacal14313703_jacal
jingal1498593jingal
jugal135612403_jugal
kraal94511823kra_al
label75019383_label
labial84714343_labial
lag47862123_lag__
lagans75717783_lagans
lager65132863_lager
lags56546223_lag_s
lahar83114263_lahar
laical8312323_laical
lall45531313_la_ll
lama66635293_lama_
lamas75532793_lamas
lanai5319573_lanai
laogai735983_laogai
lapel73716683_lapel
larval948503_larval
lauan55216793_lauan
lava76725423_lava_
lavas85422223_lavas
lazar144113643_lazar
leal46043273_l_eal
legals73412733_legals
ligan67920283_ligan
llama799893llama_
llamas888973llamas
local74820273_local
logan68123283_logan
loral55927823_loral
loyal84513483_loyal
meatal84114733meatal
nasal56217593_nasal
natal53921493_natal
naval85315833_naval
paca85132243p_aca_
pacas96029403p_acas
paean77222723p_aean
pagans95717923p_agans
page76036103p_ag_e
paged95926783p_aged
pager84728203p_ager
pages85235073p_ages
paginal10269493p_aginal
pagod95013683p_agod
pail66141833p_a_il
pal56761673p___al
palapa10310673palapa_
palapas11311493palapas
palatals1037773palatals
palatial10410623palatial
palea75028663palea_
paleae84820293paleae
pall65039343p_a_ll
pallial92911253pallial
palmar104113463palmar
paludal1035683paludal
panel76023623p_anel
panga85323533panga_
pangas99921103pangas
papa85827143p_apa_
papas94927493p_apas
papaw125112493p_apaw
para65242173p_ara_
parae76335703p_arae
paras76143043p_aras
parol74826273p_arol
parral85517533parral
pascal10812373pascal
patagial1157173patagial
pausal81511963pausal
pavan106518473p_avan
pawl95123263p_a_wl
peag75431343peag__
peage84723573peag_e
peages94321853peages
peags86122843peag_s
peal68648103p__eal
pearl75324463pea_rl
pedal86022503p_edal
pelage9515363pelag_e
pelages10714613pelages
pelagic1237863pelagic
penal75228373p_enal
penial84120893penial
petal76526893p_etal
phage115113673phag_e
phages125213513phages
phalangal1552473phalangal
phaseal1245673phaseal
phial10313203p_hial
phonal11310383phonal
phrasal1246163phrasal
pial65636703p__ial
pibal95217323p_ibal
pical95524373p_ical
pineal84817683pineal
pinnal84814273pinnal
pipal95118353p_ipal
placable14169243placable
placably17156673placably
placard1236783placard
placate11312433placate
place94824613pla_ce
placed114318003placed
placer105117743placer
places104323703places
placet103923673placet
placid114012543placid
plack135017843pla_ck
placks144414153placks
plagiary1443643plagiary
plagued11307473plagued
plaguer10328273plaguer
plagues103311063plagues
plaguey13335943plaguey
plaguily1443513plaguily
plaice10311553plaice
plaid85118303pla_id
plaids94312443plaids
plain74823303pla_in
plainly1236473plainly
plains85019593plains
plaint85323203plaint
plait75631573pla_it
plaits83816473plaits
plan65833943pl__an
planate9314573planate
planch133711443planch
plane74929143pla_ne
planed94420913planed
planer84122653planer
planes85028083planes
planet84228353planet
plank115221143pla_nk
planks124116753planks
plans75731273pla_ns
plant75437113pla_nt
plantar9369993plantar
plants84921803plants
planula935773planula
plaque17317643plaque
plash104616563pla_sh
plashy14448873plashy
plasm94114633pla_sm
plasma103810913plasma
plasmas113010753plasmas
plasms103711333plasms
plastral1046913plastral
plat66048873pl__at
platane93112303platane
platans93413123platans
plate74635113pla_te
plateau937403plateau
plated95225773plated
platen84518203platen
plater84427693plater
plates85432243plates
plats75531373pla_ts
platy105021663pla_ty
platys11459853platys
play95928983pl__ay
playable15137923playable
playact1446553playact
playday1643823playday
played124815033played
player115215213player
playful1544653playful
playgirl1442553playgirl
plays106320773pla_ys
plea66830603pl_ea_
plead85818463pl_ead
pleas75627033pl_eas
pleat74734473pl_eat
pleiad947833pleiad
plena75816393plena_
pleonal937243pleonal
pleural956673pleural
plica9613373plica_
plicae10410953plicae
plight123513363plight
plug74915993plug__
plugola1043013plugola
plugs85213493plug_s
plurals936913plurals
pluvial1245433pluvial
podagral1243373podagral
polygala1443893polygala
portal84218463portal
postal84317533postal
praam94815613pra_am
preanal9310713preanal
prelegal1145053prelegal
primal104014623primal
pulpal10408453pulpal
pupal97616873p_upal
raga55930813_raga_
ragas65326063_ragas
ramal74622243_ramal
ratal55025113_ratal
regal65023793_regal
rugal65916093_rugal
sabal75422483_sabal
saga55331173_saga_
sagas66025883_sagas
salal55425703_salal
slag55934353slag__
slaggy11438793slaggy
slags66525903slag_s
slogan7539223slogan
statal61613223statal
tamal73522623_tamal
tergal72912833tergal
ulama7711473ulama_
ulamas8910453ulamas
valval12398863valval
vasal85516293_vasal

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127163035.25021469.7
3Display Results3033030.0933258.1
 (SQL Overall)1786913035.73331168.8
 
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.