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

469 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
palpal10411205(None) 
paleal84716671paleal
papal95820671pa_pal
pulpal10408451pulpal
algal66518222_algal
appal95315222_appal
calpac123211062calpac
carpal103716252carpal
fallal93612692fallal
halal85623592hal_al
hallal94415562hallal
kalpa114512192kalpa_
kalpac14428222kalpac
kalpak11437242kalpak
kalpas124112942kalpas
palapa10310672palapa
palapas11311492palapas
palatal9310152palatal
palea75028662palea_
paleae84820292paleae
pall65039342pal__l
pallial92911252pallial
palmar104113462palmar
palp85828572palp__
palpable1448032palpable
palpably1745362palpably
palpate113213922palpate
palped114513642palped
palpi95414552palp_i
palps94719562palp_s
palpus104210282palpus
paludal1035682paludal
pampa114913422pampa_
pampas124913992pampas
papa85827142pa_pa_
papas94927492pa_pas
papaw125112492pa_paw
parral85517532parral
pascal10812372pascal
pausal81511962pausal
pawpaw1653502pawpaw
pipal95118352p_ipal
plagal948572plagal
pupal97616872p_upal
salal55425702sal_al
salpa75018352salpa_
salpae84614272salpae
salpas85116922salpas
valval12398862valval
aal39058673_a__al
ala312463603_al_a_
alae45643753_al_ae
alan46844083_al_an
alar46340073_al_ar
alas46358123_al_as
alba68328333_alba_
albas75925393_albas
aldol61212333_aldol
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algas65624933_algas
alias55834603_alias
alkali10127563_alkali
alkyl12518043_alkyl
all36148233_al__l
allay85620393_allay
allyl85310543_allyl
alma66333023_alma_
almah106917253_almah
almas76629773_almas
alp56641133_alp__
alpaca1047383_alpaca
alpha1049653_alpha
alphas1139513_alphas
alphyl1484083_alphyl
alps65529243_alp_s
altar55520643_altar
alula5317093_alula
alway116113923_alway
ampul91110853_ampul
anal48037523_a_nal
annal56520763_annal
apical10913903apical
apneal83411123apneal
apodal9289833apodal
appall10379743_appall
appals104812943_appals
appeal103911613appeal
appel94615893_appel
areal55928733_areal
argal65023393_argal
artal55525473_artal
arval86017013_arval
aural54428963_aural
axal116520493_a_xal
axial124515193_axial
baal67033113ba__al
balas76937213bal_as
ball66043323bal__l
ballad94315323ballad
balneal936573balneal
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banal75925993ba_nal
barbal104016663barbal
basal75722283ba_sal
cabal95222153ca_bal
caecal103713733caecal
calcar10312753calcar
caliphal1544033caliphal
call66838673cal__l
calla74827073calla_
callan83619603callan
callas84526753callas
calpack17338333calpack
calpacs133110343calpacs
calpain11310413calpain
canal75428043ca_nal
cantal84122033cantal
carnal83919213carnal
carpale113414353carpale
carpals113414633carpals
carpel105418473carpel
casual81112863casual
caudal91611483caudal
causal81413203causal
copal95621783_copal
culpa93610963culpa_
culpae10389263culpae
cuspal1037883cuspal
daedal849083daedal
facial113615633facial
faecal11359813faecal
falbala1235873falbala
fall75535313fal__l
fallals103310193fallals
farfal123410183farfal
fatal84819373fa_tal
faucal11339963faucal
faunal94711593faunal
filial93013253filial
gala55635163gal_a_
galah95917643gal_ah
galas65731643gal_as
galax135314463gal_ax
galea64722943galea_
galeae74717453galeae
galeas74618513galeas
gall56335993gal__l
galyac1235973galyac
galyak1445333galyak
gavial10310083gavial
gayal9312713ga_yal
glial66715433_glial
hadal95518123ha_dal
haemal113811643haemal
halala94715093hal_ala
halals95018313hal_als
hall75741163hal__l
hallah124115403hallah
hallel93514093hallel
halma108219253halma_
halmas117017893halmas
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
hamal104623113ha_mal
hammal134512063hammal
hapax1739323ha_pax
hartal9415473hartal
ileal56118083_ileal
ilial55317843_ilial
jacal14313703ja_cal
jackal1937613jackal
jalap143612473jal_ap
jalaps15299183jalaps
japan14411233ja_pan
kalam11315113kal_am
kalian10312163kalian
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kapa106021293ka_pa_
kapas116021733ka_pas
kappa13469743kappa_
kappas144410363kappas
keypal1534893keypal
labial84714343labial
laical8312323laical
lall45531313lal__l
lallan63414173lallan
lampad114510033lampad
lampas106615953lampas
lapel73716683la_pel
larval948503larval
leal46043273__leal
malar76424443mal_ar
mall64639373mal__l
maltol8310843maltol
mammal95112753mammal
manual8313463manual
milpa92111403milpa_
milpas101710273milpas
molal75120343mol_al
nala46930393nal_a_
nalas55528363nal_as
napa66927263na_pa_
napalm1047263na_palm
napas75924353na_pas
nappa98511863nappa_
nappas105511613nappas
narial6317953narial
narwal938943narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
nopal75517103_nopal
opal66923523__opal
paca85132243pa_ca_
pacas96029403pa_cas
pacha126518063pacha_
pachas135017143pachas
padnag1036073padnag
paean77222723pa_ean
paella8410913paella_
paellas9411413paellas
paesan85114093paesan
pagan86121163pa_gan
paginal10269493paginal
pail66141833pa__il
pailful1236103pailful
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
pal56761673___pal
palace104516923palace
palais8420423palais
palatals1037773palatals
palate84226793palate
palatial10410623palatial
pale66055013pal__e
paleate94120003paleate
paled85538723pal_ed
palely11311933palely
paler75436933pal_er
pales75753803pal_es
palest83926223palest
palet74650803pal_et
palets85122313palets
palier85023563palier
palikar1335453palikar
paling93530133paling
palish114718273palish
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallid93915283pallid
pallor8313673pallor
palls74332563pal_ls
pally105727123pal_ly
palm85331363pal__m
palmary14338553palmary
palmate113215233palmate
palmed114314643palmed
palmer105816543palmer
palmful1445053palmful
palms94921753pal_ms
palmy126016733pal_my
palpated13249763palpated
palpates122613063palpates
palpator1247133palpator
palpebral1542213palpebral
palping124112873palping
pals66951353pal__s
palsy105417463pal_sy
palter84423263palter
paltry114910403paltry
paly95835533pal__y
pampean1335543pampean
pamper124316663pamper
panda85022613panda_
pandas95521963pandas
panel76023623pa_nel
panful1179743panful
panga85323533panga_
pangas99921103pangas
pap76758403pa_p__
papacy1547493pa_pacy
papain10313793pa_pain
papally1437973pa_pally
papaws13419113pa_paws
papaya1337503pa_paya
paper95128663pa_per
pappi84810893pa_ppi
pappus9408373pappus
pappy114713803pa_ppy
paps86443453pa_p_s
papula103011113pa_pula
papule102212133pa_pule
papyral1445773papyral
para65242173pa_ra_
parae76335703pa_rae
paraph13311263paraph
paras76143043pa_ras
parcel103915473parcel
pardah123412823pardah
pariah114320583pariah
parian83223963parian
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parol74826273pa_rol
parrals94414573parrals
parrel84515983parrel
partan83820563partan
partial92616263partial
pascals11610013pascals
paschal14157243paschal
pasha105417183pasha_
pashas115117063pashas
passel85117003passel
pasta76624533pasta_
pastas85422873pastas
pastel85918713pastel
pastil85018323pastil
patrol83213023patrol
pauper103511943pauper
pavan106518473pa_van
pawl95123263pa__wl
pawpaws1732823pawpaws
paxwax1742953paxwax
payday1536613payday
payload1336403payload
payola11208113payola
peal68648103p__eal
pedal86022503p_edal
peepul1035783peepul
penal75228373p_enal
penial84120893penial
pepla9312863pepla_
petal76526893p_etal
phaseal1245673phaseal
phial10313203p_hial
phonal11310383phonal
pial65636703p__ial
pibal95217323p_ibal
pical95524373p_ical
pilaf103923483pil_af
pilar75221503pil_ar
pilau73618523pil_au
pilaw103913743pil_aw
pilea75123953pilea_
pill65339463pil__l
pillar8314023pillar
pineal84817683pineal
pinnal84814273pinnal
pipals104213643p_ipals
plan65833943p_l_an
planar84212713planar
plat66048873p_l_at
platan83913693platan
play95928983p_l_ay
playa105812943playa_
playas114612283playas
plaza164311063plaza_
plazas17409913plazas
plea66830603p_lea_
plead85818463p_lead
pleas75627033p_leas
pleat74734473p_leat
plexal1536843plexal
plical10411683plical
plural839823plural
polar75623453pol_ar
poleax1547993poleax
polka11310413polka_
polkas1239103polkas
poll66332133pol__l
polyol1138713polyol
poplar103611113poplar
poppa8409893poppa_
poppas93710713poppas
portal84218463portal
postal84317533postal
prepay13310313prepay
primal104014623primal
propel103714063propel
propyl13358183propyl
pula65129373pul_a_
pull64731663pul__l
pulp84825353pulp__
pulpally1544453pulpally
pulped114612533pulped
pulper103513273pulper
pulpily1436103pulpily
pulpit10310933pulpit
pulpital1243873pulpital
pulps95116483pulp_s
pulpy124612363pulp_y
pulsar8329363pulsar
pupa85422813p_upa_
pupae96515643p_upae
pupas95219283p_upas
pupil94712983p_upil
racial83419243racial
radial74020393radial
ralph1078743ralp_h
ralphs1135373ralphs
ramal74622243ra_mal
rappel104211953rappel
rascal8511123rascal
ratal55025113ra_tal
sabal75422483sa_bal
sacral83414413sacral
salaam8711013salaam
salad65321833sal_ad
salals65120083sal_als
sall44544683sal__l
salol55222143sal_ol
salp64534093salp__
salpian938493salpian
salpid9510883salpid
salps74423243salp_s
salsa56718923salsa_
salsas65316133salsas
saltpan935303saltpan
sambal105215183sambal
sampan102511893sampan
sandal73317283sandal
scalpel11377713scalpel
sepal77723003_sepal
spacial1138763spacial
spall74919303spal__l
spathal1236263spathal
spatial9310323spatial
sulcal8311273sulcal
taipan82410663taipan
tala45938053tal_a_
talar56225383tal_ar
talas55935893tal_as
tall47240213tal__l
tallol63612223tallol
tamal73522623ta_mal
tampala1136613tampala
tampan102512323tampan
tapa65129143ta_pa_
tapalo839793ta_palo
tapas74627713ta_pas
tarnal63716503tarnal
tarpan82814293tarpan
tarsal63315273tarsal
telial65815363telial
tepal76319583_tepal
typal105311153_typal
ulpan7310123_ulpan
vagal94613633va_gal
valvar12388653valvar
vandal103713833vandal
vasal85516293va_sal
vassal979243vassal
vulval12417663vulval
wadmal1237283wadmal
wall76236103wal__l
walla85321033walla_
wallah124011993wallah
wallas95719393wallas

Search took 7 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 Limit1127164695.90619085.0
3Display Results4694690.1403350.0
 (SQL Overall)1786914696.43627764.3
 
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.