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

299 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
hamada123992(None) 
hamadas1339671hamadas
hammada1545091hammada
ramada9310181ramada
armada938782armada
chamade15138452chamade
haggada1353642haggada
halala94715092halala
hamal104623112hama_l
hamals114816822hamals
hamate113319832hamate
hamaul114210872hamaul
hammadas1644792hammadas
hamza19139772ham_za
hawala12368912hawala
kamala12339962kamala
lambada1245642lambada
lambda1146112lambda
panada94113052panada
ramadas1039302ramadas
samara8313852samara
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
agama85815583_agama
aggada955223aggada
ahead96817053ahead_
alameda1035493alameda
ama510853303_am__a
amadou977613_amadou
amah98927493_ama_h
amahs107819063_amahs
amain74922913_amain
amarna839793_amarna
amas67746293_ama_s
amass77119683_amass
amaze166016603_amaze
ameba9312383_ameba
amia66836903_am_ia
amid77036353_amid_
amide86128483_amide
amido85720983_amido
amids85627513_amids
amiga85514813_amiga
amnia75918643_amnia
armadas1038173armadas
asana5315483_asana
balata8614673balata
banana83213413banana
banda85223103ba_nda
bemadam1445773bemadam
bemata10411693bemata
cabala103516913cabala
cabana103913563cabana
camail10314833camail
camas96333523cama_s
camass104114183camass
cambia124913153cambia
camera10313693camera
camisa103114323camisa
casaba1079263casaba
casava1157873casava
chalaza2145733chalaza
chamades16138653chamades
chamisa14328853chamisa
champaca1943203champaca
charade13129913charade
cicada1136413cicada
comade114415323comade
dada66422443__dada
damage10410773damage
daman84821163dama_n
damans94715983damans
damar84117733dama_r
damars93814993damars
damask1335843damask
damiana1046563damiana
dramady1443553dramady
facade1238803facade
famed115928343famed_
farad95720673farad_
faraday1445633faraday
farads104713273farads
gama77035523gam__a
gamas85431363gama_s
gamay116419113gama_y
gamays126310913gamays
gamba106018513gam_ba
gambade1336383gambade
gambado1344973gambado
gambia115912253gambia
gamed95126393gamed_
gamma106116103gam_ma
gammadia1443923gammadia
garda7316763ga_rda
gelada837623gelada
haaf106227733ha_a_f
haafs115711163ha_afs
haar77323493ha_a_r
haars85620473ha_ars
had77658763h__ad_
hadal95518123hada_l
hade85440193h__ade
haded105227623haded_
hadj155818673h__adj
haed86338583ha_ed_
haemal113811643haema_l
haematal1345143haematal
haftara13136093haftara
hagadic1445863hagadic
haggadah1762593haggadah
haggadas1463633haggadas
haha107821063h__aha
hahas117118443haha_s
haika125313793ha_ika
hairdo1036433hairdo
halacha15388003halacha
halakah17517963halakah
halakha17416583halakha
halal85623593hala_l
halalah13429393halalah
halalas104214083halalas
halals95018313halals
halavah16447023halavah
haled95335823haled_
halid94424983halid_
halide103417993halide
halids104016133halids
halloa94918123halloa
halma108219253ha_lma
halmas117017893halma_s
halva115414433ha_lva
ham86363283ham___
hamadryad1951533hamadryad
hamadryas1842213hamadryas
hamartia13115943hamartia
hamates122917683hamates
hamauls12387813hamauls
hame97043133ham__e
hames106138703ham_es
hamlet113722793hamlet
hammal134512063hammal
hammals14409223hammals
hammam12419333hammam
hammams13386443hammams
hammed144116973hammed
hammer138120033hammer
hammy155113433ham_my
hamper134518653hamper
hams96446133ham__s
hamular1236973hamular
hamuli1137063hamuli
hamzah23135563hamzah
hamzahs24134373hamzahs
hamzas20119013hamzas
hand86833713ha_nd_
handax1749583handax
handmade1545963handmade
hands95327383ha_nds
handy125520873ha_ndy
haniwa1236743haniwa
hansa85416783ha_nsa
hapax1739323hapa_x
harass9313943harass
hard85443503ha_rd_
hards96435653ha_rds
hardy125622063ha_rdy
hared95742183hared_
hariana10310243hariana
harmed125218833harmed_
hated95734023hated_
hawalas13348353hawalas
hawed126025423hawed_
hayed125822013hayed_
hazan173813613haza_n
hazans183411653hazans
hazard1938403hazard
hazards2037463hazards
hazed185222203hazed_
hazmat20312263hazma_t
hazmats2136603hazmats
head87137173h_ead_
heads95127113h_eads
heady125117263h_eady
hemal104419803hema_l
hematal1238953hematal
hexad164910623hexad_
hexade17438903hexade
hexads17468193hexads
himatia1248593himatia
hodad10311353hodad_
hodads1147963hodads
homage121210603homage
homed115425423homed_
honda9414983h_onda
human102716033huma_n
humane112812173humane
humans112312433humans
humate113214443humate
humid114213763humid_
jacana1537933jacana
jemadar1743373jemadar
kabaka11348503kabaka
kabala124011553kabala
kabaya15387123kabaya
kamalas13339123kamalas
kanaka9357523kanaka
labara83712893labara
lama66635293lam__a
lamas75532793lama_s
lambadas1354873lambadas
lambdas1246243lambdas
lamed85235293lamed_
lamedh12476363lamedh
lameds94812033lameds
lamia75324323lam_ia
lamina84920443lamina
lampad114510033lampad_
lampads12477623lampads
macadam1446853macadam
mad68958713__mad_
madam10316223__madam
made75440243__made
mads76845373__mads
magmata1237463magmata
malady1237863malady
mama86231593__mama
mamas95930773mama_s
mamba116317523mam_ba
mamma86317913mam_ma
mana65341963__mana
manana84816073manana
manmade1237963manmade
mara67444573__mara
maraca10314153maraca
masa65034723__masa
masala8311813masala
maya95824593__maya
nada58022903__nada
nagana748943nagana
naiad6313403naiad_
naiads739013naiads
named85223063named_
nomad86016183nomad_
nomads94711603nomads
omasa749483_omasa
pagoda10487873pagoda
pajama17317653pajama
palapa10310673palapa
pampa114913423pam_pa
panadas103312213panadas
panama104213353panama
panda85022613pa_nda
papadam1486913papadam
papaya1337503papaya
parade94720643parade
pataca10311193pataca
pomade113611333pomade
posada937163posada
qabala17399193qabala
ramal74622243rama_l
ramate83921683ramate
rambla103510933rambla
ramona8412413ramona
remade94316983remade
remuda936823remuda
salad65321833salad_
salads75316963salads
samadhi1344063samadhi
samaras9312913samaras
samba95618773sam_ba
samosa8510203samosa
samsara936913samsara
satara6315533satara
shaman113314283shama_n
shamans123610903shamans
shamas113717943shama_s
shamed125120213shamed_
somata8312383somata
tamal73522623tama_l
tamale83717403tamale
tamals84116633tamals
tamandu1044433tamandu
tamandua1142593tamandua
tamarao977593tamarao
tamarau9107063tamarau
tamari8313403tamari
tamasha12125433tamasha
tambala1138023tambala
tamed85528513tamed_
tampala1136613tampala
tarama8412733tarama
unmade92911063unmade
vanda94515923va_nda
wakanda1544013wakanda
yamalka1652963yamalka
zamarra1843783zamarra
zamia165115213zam_ia
zanana153810363zanana

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.406440125.6
2DLD Change Limit1127162995.90619085.0
3Display Results2992990.0933215.1
 (SQL Overall)1786912996.40527898.7
 
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.