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

405 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
panada9411305(None) 
panadas103312211panadas
panama104213341panama
panda85022611pan_da
banana83213412banana
banda85223102ban_da
empanada1341882empanada
hamada1239912hamada
kanaka9357522kanaka
manana84816072manana
nada58022902__nada
pagoda10487872pagoda
pajama17317652pajama
palapa10310672palapa
panacea1137782panacea
panamas113112752panamas
pandas95521962pandas
pandy115021172pan_dy
paned85437182paned_
panga85323532pan_ga
papadam1486912papadam
papaya1337502papaya
parade94720642parade
pataca10311192pataca
pinata83817212pinata
pintada1096072pintada
posada937162posada
ramada9310182ramada
vanda94515922van_da
zanana153810362zanana
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
agama85815573_agama
aggada955203aggada
ana39559823_an__a
anabas8314083_anabas
anadem939183_anadem
anal48037523_ana_l
anas46649863_ana_s
and47244163_an_d_
ands57833613_an_ds
anga56831353_an_ga
anima74620073_anima
anna45529013_an_na
anoa45634473_an_oa
anodal72512113_anodal
anode65021033_anode
ansa45927773_an_sa
anta46839583_an_ta
antra56521923_antra
apanage1036803apanage
apnea73413413apn_ea
apnoea867093apnoea
armada938783armada
asana5315483_asana
balata8614673balata
banal75925993bana_l
bananas93312223bananas
band76740903ban_d_
bandana10179463bandana
bandas95120543bandas
bands85233423ban_ds
bandy114824183ban_dy
baned85436353baned_
cabala103516913cabala
cabana103913563cabana
canal75428043cana_l
canals84421663canals
canape10913513canape
canard9314763canard
canards10311203canards
canary11314693canary
canasta938363canasta
cancha134411613cancha
candida114110253candida
candy115119823can_dy
caned85838093caned_
canid85526343canid_
canids95118133canids
canna75919333can_na
canola8313623canola
cantala94114673cantala
cantata93811813cantata
canula8312963canula
casaba1079263casaba
casava1157873casava
cicada1136413cicada
cnida878953_cnida
dada66422443__dada
dandy104416703dan_dy
empanadas1441723empanadas
facade1238803facade
fanega1055783fanega
fanegada1341613fanegada
fanga96119623fan_ga
farad95720673farad_
faraday1445633faraday
farads104713273farads
ganja131410003gan_ja
garda7316763ga_rda
gelada837623gelada
gonad75216053gonad_
gonadal956523gonadal
gonads84511733gonads
haggada1353623haggada
halala94715093halala
hamadas1339663hamadas
hammada1545083hammada
hand86833703han_d_
handax1749583handax
hands95327383han_ds
handy125520873han_dy
haniwa1236743haniwa
hansa85416783han_sa
hawala12368913hawala
honda9414983hon_da
jacana1537933jacana
jnana12159043_jnana
kabaka11348503kabaka
kabala124011553kabala
kabaya15387123kabaya
kamala12339963kamala
kana85928523kan__a
kanakas10327213kanakas
kanas95326913kana_s
kinara10310363kinara
labara83712893labara
lambada1245643lambada
lambda1146113lambda
lanai5319573lana_i
lanais6316793lanais
lanate6421263lanate
land56337303lan_d_
landau7310613landau
lands65426903lan_ds
lantana739603lantana
macadam1446853macadam
maenad939413maenad_
maenads1037373maenads
malady1237863malady
mana65341943man__a
manage93818903manage
mananas93414733mananas
manas76240423mana_s
manat76039983mana_t
manats84623463manats
mandala10310203mandala
maned86634093maned_
manga85026193man_ga
mania75634143man_ia
manila84518303manila
manmade1237963manmade
manna75522533man_na
manta75629903man_ta
mantra84116093mantra
mantua84412023mantua
maraca10314153maraca
masala8311813masala
menad85918983menad_
menads95514383menads
monad85519473monad_
monadal1047893monadal
monads94515303monads
monarda1046613monarda
nadas66320813__nadas
nagana748943nagana
naiad6313403naiad_
naiads739013naiads
nala46930393__nala
nana46632893__nana
nanas55928633nana_s
napa66927263__napa
paca85132243p__aca
pacas96029403paca_s
paced106931683paced_
pacha126518063pa_cha
pad68057323p__ad_
padauk1335643padauk
paddy125913593pa_ddy
padi76331783p__adi
padnag1036073padna_g
padnags1135083padnags
pads76742953p__ads
paean77222723paea_n
paeans85118263paeans
paella8410913paella
pagan86121163paga_n
pagans95717923pagans
paged95926783paged_
pagod95013683pagod_
pagodas11367553pagodas
pagods105310193pagods
paid75737483pa_id_
pained95622853pained_
paisa76021073pa_isa
paisana94010223paisana
pajamas18278153pajamas
pakeha1533933pakeha
pakora1247283pakora
palabra1137183palabra
palace104516913palace
paladin101011773paladin
palais8420423palais
palapas11311493palapas
palatal9310153palatal
palate84226783palate
palea75028663pa_lea
paled85538723paled_
palladia1146633palladia
pallia83015593pallia
paludal1035683paludal
pampa114913423pa_mpa
pan58466443pan___
panacean1244733panacean
panaceas1236763panaceas
panache1458423panache
panatela1044913panatela
pancake1536673pancake
panchax2134983panchax
pandani1039903pandani
pander93725523pander
pandit93820753pandit
pandora1039543pandora
pandura1037143pandura
pane64950283pan__e
panel76023623pan_el
panels84716523panels
panes76148693pan_es
panfry14456413panfry
panful1179743panful
pang75336283pan__g
pangas99921103pangas
panged104722333panged
pangen94115913pangen
pangram1239023pangram
pangs84628663pan_gs
panic93923903pan_ic
panics103815363panics
panier84425503panier
panini8314273panini
panino8315683panino
panjandra1951423panjandra
panne76623653pan_ne
panned94123433panned
panner84224763panner
pannes85522853pannes
panocha1444983panocha
panorama1244943panorama
pans65855723pan__s
pansy105717973pan_sy
pant66061253pan__t
panted95024823panted
pantie84326473pantie
panto76129413pan_to
pantos85222743pantos
pantry115014103pantry
pants76536923pan_ts
panty105929303pan_ty
panzer174213233panzer
papa85827143p__apa
papacy1547493papacy
papadams15104783papadams
papadom1466763papadom
papadum1475233papadum
papain10313793papain
papal95820673papa_l
papas94927493papa_s
papaw125112493papa_w
papaws13419113papaws
papayan1445303papayan
papayas1437273papayas
pappadam1443233pappadam
papula103011113papula
para65242173p__ara
paraded114014263paraded
parader103914863parader
parades104121463parades
parador103311413parador
parados103816053parados
paradox17358173paradox
parae76335703para_e
paramo102614643paramo
parang93715513parang
paraph13311263paraph
paras76143043para_s
pard76441323pa_rd_
pardah123412823pardah
pardi85723953pa_rdi
pards85634333pa_rds
pardy115523953pa_rdy
pared86946763pared_
parka115120883pa_rka
parkade1437583parkade
parody12410093parody
parura8310583parura
pasha105417183pa_sha
passade1039233passade
passado1037053passado
pasta76624533pa_sta
patacas11311003patacas
patagia1068783patagia
patamar1147093patamar
pated85237843pated_
patina86022193patina
pavan106518473pava_n
pavane114113443pavane
pavans115715593pavans
paved115525263paved_
pavid115717003pavid_
pawed115725613pawed_
pawnage1335873pawnage
pawned124513283pawned_
payday1536613payday
payed115925933payed_
payola11208113payola
pazazz1554023pazazz
penal75228373pena_l
penang92511113penang
pend75934533pen_d_
pends85527193pen_ds
penna74520203pen_na
pennia84412973pennia
pentad9313763pentad_
pentads1039523pentads
pesade9311103pesade
piasaba1144193piasaba
piasava1243883piasava
picara10311903picara
pina65842633pin__a
pinang92611593pinang
pinas75434453pina_s
pinatas93711483pinatas
pined85935323pined_
pineta85815563pineta
pinna75320183pin_na
pinta75727053pin_ta
pintadas11105063pintadas
pintado1096573pintado
pirana8713263pirana
piraya1167713piraya
pitaya1186603pitaya
planar84212713plana_r
planaria1047353planaria
planate9314573planate
planed94420913planed_
planula935773planula
playa105812943p_laya
plaza164311063p_laza
plead85818463plead_
pleads94613953pleads
pomade113611333pomade
pond75530493pon_d_
ponds85323403pon_ds
posadas1037193posadas
puna65331653pun__a
punas74826753puna_s
punka114515483pun_ka
purana8712933purana
purda82914693p_urda
pyjama20303483pyjama
qabala17399193qabala
qanat144426843qana_t
qanats154112813qanats
ramadas1039303ramadas
rand55839563ran_d_
randan7315253randan
rands65930453ran_ds
randy95022083ran_dy
ranid66429333ranid_
ranids75118703ranids
ranula6311813ranula
salad65321833salad_
salads75316963salads
samara8313853samara
sancta839833sancta
sand55338463san_d_
sandal73317283sandal
sanddab1144923sanddab
sands65228583san_ds
sandy94221133san_dy
saned65636273saned_
sanga66023793san_ga
satara6315533satara
sonata6313223sonata
tanga64923683tan_ga
tanka93817483tan_ka
tantara72410813tantara
tantra63713353tantra
tarama8412723tarama
ulnad65611453ulnad_
vanadate1245513vanadate
vanadic1336743vanadic
vandal103713833vandal
vandas103915993vandas
vaned94622423vaned_
wakanda1544013wakanda
wand85833873wan_d_
wands96425483wan_ds
waned95831783waned_
yantra9449623yantra
zananas16319563zananas
zanza1378703zan_za
zenaida17914783zenaida
zenana15297983zenana

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.1401276364.3
2DLD Change Limit1127164056.04618643.1
3Display Results4054050.1402892.9
 (SQL Overall)1786914056.32628247.1
 
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.