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

252 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
kamalas1333912(None) 
kabalas133911061kabalas
kamala12339961kamala_
cabalas113516002cabalas
halalas104214082halalas
hamadas1339672hamadas
hamals114816822hamal_s
hawalas13348352hawalas
kabakas12367402kabakas
kabala124011552kabala_
kabayas16316802kabayas
kabbalas1674352kabbalas
kanakas10327212kanakas
koalas104011662k_oalas
masalas9312052masalas
qabalas18289502qabalas
ramadas1039302ramadas
ramblas112710262ramblas
samaras9312912samaras
tamales93216152tamales
tamals84116632tamal_s
tambalas1237032tambalas
tampalas1245472tampalas
yamalkas1743102yamalkas
aals49941143_a_al_s
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
agamas97413453_agamas
akelas10311193_akelas
alas46358123___alas
amahs107819063_ama_hs
amalgam1244923_amalgam
amalgams1343203_amalgams
amas67746293_am__as
amass77119683_ama_ss
amazes175613473_amazes
ambles105121863_ambles
amebas10311453_amebas
amias75831473_am_ias
amigas95912173_amigas
amoles84122193_amoles
amylase1237023_amylase
amyls104512693_amyl_s
anabas8314083_anabas
anlas55626933_a_nlas
argalas84011093argalas
armadas1038173armadas
asanas6514113_asanas
atlas55821583_a_tlas
azaleas1636993_azaleas
baals76122703ba_al_s
bacalao1146613bacalao
bacalaos1245863bacalaos
balas76937213__balas
balatas9311833balatas
bananas93312223bananas
basalts9358963basalts
cabala103516913cabala_
cabals104020153cabal_s
cabanas112413033cabanas
cabbalas1467373cabbalas
callas84526753ca_llas
camails11311753camails
camas96333523cam__as
camases114216343camases
camass104114183cama_ss
camelias12510303camelias
camels105217083camel_s
cameras11313363cameras
camisas113411923camisas
canals84421663canal_s
canolas9313993canolas
cantalas104013523cantalas
canulas9312853canulas
casabas1139983casabas
casavas1237813casavas
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
cavallas1366843cavallas
cicalas1139303cicalas
coalas87418963_coalas
damages11511273damages
damans94715983dama_ns
damars93814993dama_rs
damasks1435073damasks
damianas1155573damianas
falbalas1345473falbalas
famulus1235043famulus
favelas1337023favelas
females12310663females
galas65731643__galas
gamas85431363gam__as
gamays126310913gama_ys
gambas115817513gam_bas
gambias125010733gambias
gambles124016203gambles
gamelan10106643gamelan
gamelans11115843gamelans
gammas115714693gam_mas
gayals1039513gayal_s
halala94715093halala_
halalah13429393halalah
halalahs14367443halalahs
halals95018313halal_s
hamada1239923hamada_
hamal104623113hamal__
hamates122917683hamates
hamauls12387813hamauls
hammadas1644793hammadas
hammals14409223hammal_s
hamular1236973hamular
hamulus1235323hamulus
hamzas20119013ham_zas
hawala12368913hawala_
impalas11236953impalas
jacales16310323jacales
jacals1539873jacal_s
jacanas1638263jacanas
kaas86531843k__a_as
kababs14409773kaba_bs
kabaka11348503kabaka_
kabalism1647043kabalism
kabalist14410083kabalist
kabars124513953kaba_rs
kabaya15387123kabaya_
kabbala1584613kabbala_
kabbalah1962433kabbalah
kabbalahs2051903kabbalahs
kahunas1473953kahunas
kaiaks937043kaia_ks
kails95525213ka_il_s
kakapos1243673kakapos
kakas85117343k__akas
kalam11315113k__alam
kalamatas1543713kalamatas
kalams12310603kala_ms
kales95730983k__ales
kalmias1347973kalmias
kalpas124112943ka_lpas
kamaainas1542283kamaainas
kames115024693kam__es
kamiks11387913kam_iks
kamsins1346963kamsins
kanaka9357523kanaka_
kanas95326913k__anas
kapas116021733k__apas
kappas144410363ka_ppas
karates115617473karates
karats106420493kara_ts
karmas123013733ka_rmas
kashas133311903ka_shas
katas95922093k__atas
kavas125919953k__avas
kavass13517303kava_ss
kayaks1236333kaya_ks
kayles134712003ka_yles
kiblas1239323k_iblas
kinaras1159123kinaras
koala95112213k_oala_
kolas94822233k__olas
kraals10378433kraal_s
lamas75532793lam__as
lambadas1354873lambadas
lambdas1246243lambdas
lamellas1098153lamellas
lamias85020613lam_ias
laminas93615873laminas
lampas106615953lam_pas
maculas113114023maculas
malar76424443__malar
malars85020683__malars
males75049793__males
malls76233433__malls
malms95021553__malms
malts76331753__malts
mamaligas1443383mamaligas
mamas95930773__mamas
mambas125716243mam_bas
mammals10389273mammal_s
mammas94616403mam_mas
mananas93414733mananas
manas76240423__manas
mandalas1139443mandalas
manilas93915873manilas
maracas11313773maracas
maras75443283__maras
marsalas1038253marsalas
masala8311813masala_
masas75630413__masas
mayas105924383__mayas
molas75132093__molas
naganas847983naganas
nalas55528363__nalas
napalms1144033napalms
nasals63312463nasal_s
nyalas936903_nyalas
paellas9411413paellas
pajamas18278153pajamas
palapas11311493palapas
pampas124913993pam_pas
panadas103312213panadas
panamas113112763panamas
papayas1437273papayas
patacas11311003patacas
payolas12148973payolas
qabala17399193qabala_
qabalah21285033qabalah
qabalahs22253293qabalahs
radulas839583radulas
ramada9310183ramada_
ramal74622243ramal__
rambla103510933rambla_
rambles113118313rambles
ramonas9311093ramonas
ranulas7311773ranulas
ratals64219583ratal_s
sabals84618863sabal_s
salals65120083salal_s
samara8313853samara_
sambals115213483sambal_s
sambas104219263sam_bas
samosas939293samosas
samples112815453samples
samsaras1045873samsaras
sataras7315063sataras
smalls84514123_smalls
smalts85214893_smalts
tablas83716163ta_blas
talas55935893__talas
tamal73522623tamal__
tamale83717403tamal_e
tamarao977593tamarao
tamaraos10105883tamaraos
tamarau9107063tamarau
tamaraus1096183tamaraus
tamaris9413593tamaris
tamashas13135683tamashas
tambala1138023tambala_
tampala1136613tampala_
tapalos938813tapalos
taramas9612703taramas
wadmaals1442413wadmaals
wadmals1335513wadmal_s
wallas95719393wa_llas
wambles143714023wambles
yamalka1652963yamalka
yamulkas1741793yamulkas
zamarras1943803zamarras
zamias174212923zam_ias
zananas16319563zananas

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272528.39015974.6
3Display Results2522520.0932709.7
 (SQL Overall)1786912528.63920684.2
 
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.