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

237 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
hamadas133967(None) 
hamada1239921hamada_
hammadas1644791hammadas
ramadas1039301ramadas
armadas1038172armadas
chamades16138652chamades
haggadas1463632haggadas
halalas104214082halalas
hamadryas1842212hamadryas
hamals114816822hama_ls
hamates122917682hamates
hamauls12387812hamauls
hammada1545092hammada_
hamzas20119012ham_zas
hawalas13348352hawalas
kamalas13339122kamalas
lambadas1354872lambadas
lambdas1246242lambdas
panadas103312212panadas
ramada9310182ramada_
samaras9312912samaras
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
agamas97413453_agamas
aggadas1055003aggadas
alamedas1145443alamedas
amadou977613_amadou
amadous1038503_amadous
amahs107819063_ama_hs
amas67746293_am__as
amass77119683_ama_ss
amazes175613473_amazes
amebas10311453_amebas
amias75831473_am_ias
amidase1036733_amidase
amides95722663_amides
amids85627513_amid_s
amigas95912173_amigas
anabas8314083_anabas
armada938783armada_
asanas6514113_asanas
balatas9311833balatas
bananas93312223bananas
bandas95120543ba_ndas
bemadam1445773bemadam
bemadams1543383bemadams
cabalas113516003cabalas
cabanas112413033cabanas
camails11311753camails
camas96333523cam__as
camases114216343camases
camass104114183cama_ss
cameras11313363cameras
camisas113411923camisas
casabas1139983casabas
casavas1237813casavas
chalazas2245893chalazas
chamade15138453chamad_e
chamisas15317813chamisas
champacas2042963champacas
charades141310853charades
cicadas1235993cicadas
dadas75819863__dadas
damages11511273damages
damans94715983dama_ns
damars93814993dama_rs
damasks1435073damasks
damianas1155573damianas
facades1339033facades
faraday1445633faraday
faradays1544273faradays
farads104713273farad_s
gamas85431363gam__as
gamays126310913gama_ys
gambades1435863gambades
gambados1444153gambados
gambas115817513gam_bas
gambias125010733gambias
gammas115714693gam_mas
geladas936313geladas
haafs115711163ha_a_fs
haars85620473ha_a_rs
hadal95518123h__adal
hades96035113h__ades
haematal1345143haematal
haftaras14136073haftaras
hagadic1445863hagadic
hagadist1347603hagadist
haggada1353643haggada_
haggadah1762593haggadah
haggadahs1872083haggadahs
hahas117118443h__ahas
hairdos1136823hairdos
halachas16317883halachas
halakah17517963halakah
halakahs18426633halakahs
halakhas18386723halakhas
halala94715093halala_
halalah13429393halalah
halalahs14367443halalahs
halals95018313hala_ls
halavah16447023halavah
halavahs17415793halavahs
halides113416663halides
halids104016133halid_s
halloas104318463halloas
halmas117017893ha_lmas
halvas124714173ha_lvas
hamadryad1951533hamadryad
hamadryads2051093hamadryads
hamal104623113ham__al
hamartias14115363hamartias
hamate113319833hama_te
hamaul114210873hama_ul
hames106138703ham__es
hamlets123211403hamlets
hammal134512063ham_mal
hammals14409223hammals
hammam12419333ham_mam
hammams13386443hammams
hammers144216063hammers
hampers143616953hampers
hams96446133ham___s
hamular1236973hamular
hamulus1235323hamulus
hamza19139773ham_za_
hamzah23135563ham_zah
hamzahs24134373hamzahs
handax1749583ha_ndax
hands95327383ha_nd_s
hansas94616043ha_nsas
hapaxes1936593hapaxes
harass9313943hara_ss
hardass1139753hardass
hards96435653ha_rd_s
harianas1139163harianas
hawala12368913hawala_
hazans183411653haza_ns
hazards2037463hazards
hazmats2136603hazma_ts
heads95127113h_ead_s
hematal1238953hematal
hexades18378703hexades
hexads17468193hexad_s
hodads1147963hodad_s
homages131011583homages
hondas10313353h_ondas
humans112312433huma_ns
humates122813193humates
jacanas1638263jacanas
jemadar1743373jemadar
jemadars1842543jemadars
kabakas12367403kabakas
kabalas133911063kabalas
kabayas16316803kabayas
kamala12339963kamala_
kanakas10327213kanakas
lamas75532793lam__as
lambada1245643lambada_
lambda1146113lambda_
lamedhs13444703lamedhs
lameds94812033lamed_s
lamias85020613lam_ias
laminas93615873laminas
lampads12477623lampad_s
lampas106615953lam_pas
macadam1446853macadam
macadams1545093macadams
madam10316223__madam
madams11310943__madams
madras94316433__madras
mads76845373__mad_s
mamas95930773__mamas
mambas125716243mam_bas
mammas94616403mam_mas
mananas93414733mananas
manas76240433__manas
maracas11313773maracas
maras75443293__maras
masalas9312053masalas
masas75630413__masas
mayas105924383__mayas
nadas66320813__nadas
naganas847983naganas
naiades838213naiades
naiads739013naiad_s
nomads94711603nomad_s
pagodas11367553pagodas
pajamas18278153pajamas
palapas11311493palapas
pampas124913993pam_pas
panada94113053panada_
panamas113112763panamas
pandas95521963pa_ndas
papadam1486913papadam
papadams15104783papadams
papayas1437273papayas
parades104121463parades
parados103816053parados
patacas11311003patacas
pomades123711733pomades
posadas1037193posadas
qabalas18289503qabalas
ramblas112710263ramblas
ramonas9311093ramonas
remudas1035833remudas
salads75316963salad_s
samadhi1344063samadhi
samadhis1444253samadhis
samara8313853samara_
sambas104219263sam_bas
samosas939293samosas
samsaras1045873samsaras
sataras7315063sataras
shamans123610903shama_ns
shamas113717943sham__as
shammas14358723sham_mas
tamales93216153tamales
tamals84116633tama_ls
tamanduas1242573tamanduas
tamandus1143943tamandus
tamarao977593tamarao
tamaraos10105883tamaraos
tamarau9107063tamarau
tamaraus1096183tamaraus
tamaris9413593tamaris
tamashas13135683tamashas
tambalas1237033tambalas
tampalas1245473tampalas
taramas9612703taramas
vandas103915993va_ndas
wakandas1643413wakandas
yamalkas1743103yamalkas
zamarras1943803zamarras
zamias174212923zam_ias
zananas16319563zananas

Search took 8 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.403443402.0
2DLD Change Limit1340272376.86019537.5
3Display Results2372370.0932548.4
 (SQL Overall)1786912377.35624291.9
 
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.