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

272 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
hammals1440922(None) 
hamals114816821ha_mals
hammal134512061hammal_
hammams13386441hammams
mammals10389271mammals
dammars12308192dammars
gammas115714692gamma_s
gimmals12225822gimmals
haemal113811642haemal_
halals95018312ha_lals
halmas117017892halma_s
hamal104623112ha_mal_
hamauls12387812hamauls
hammada1545092hammada
hammadas1644792hammadas
hammam12419332hamma_m
hammers144216062hammers
hammily1736062hammily
hamzahs24134372hamzahs
hamzas20119012hamza_s
hartals10313022hartals
hazmats2136602hazmats
hymnals1543522hymnals
mammal95112752mammal_
mammas94616402mamma_s
sambals115213482sambals
shammas14358722shamma_s
tamals84116632ta_mals
wadmals1335512wadmals
aals49941143_a__als
admass957143_admass
agmas85919873_agma_s
almahs118611613_almahs
almas76629773_alma_s
amahs107819063_a_mahs
amas67746293_a_ma_s
amass77119683_a_mass
amias75831473_amia_s
ammonals1245403_ammonals
ammos94815823_amm_os
ampuls1098893_ampuls
amyls104512693_a_myls
animals94111703animals
annals66415923_annals
appals104812943_appals
argals75517713_argals
atmans84413963_atmans
atmas75721013_atma_s
baals76122703ba__als
bharals1236733bha_rals
bromals1139743bromals
bummalo1353793bummalo
bummalos1442873bummalos
cabals104020153ca_bals
caimans113811783caimans
camails11311753camails
camas96333523ca_ma_s
camass104114183ca_mass
camels105217083ca_mels
cammies134016483cammies
canals84421663ca_nals
cantals93919573cantals
carpals113414623carpals
casuals91410523casuals
causals91411183causals
caymans14349513caymans
chacmas1638003chacma_s
chammies172910163chammies
champacs1934633champacs
champaks2134103champaks
chasmal14158213chasmal_
commas124814573comma_s
cymbals16236143cymbals
damans94715983da_mans
damars93814993da_mars
dammar11438903damma_r
dammers123214273dammers
damsels10126703damsels
dharmas1356513dharma_s
dismals102010243dismals
facials123310743facials
fallals103310193fallals
farfals13268503farfals
faucals12326563faucals
formals123312893formals
gamas85431363ga_ma_s
gamays126310913ga_mays
gambas115817513gamba_s
gambols1238593gambols
gamma106116103gamma__
gammers123214563gammers
gammons1237973gammons
gavials1136603gavials
gayals1039513ga_yals
gharials1245123gharials
gimbals12257823gimbals
gimmal11247513gimmal_
grammars13345943grammars
grammas12499773gramma_s
gummas114810513gumma_s
haafs115711163ha__afs
haars85620473ha__ars
hadal95518123ha_dal_
haemins122811403haemins
haems105517013haem__s
hahas117118443ha_ha_s
hails85231643ha__ils
halal85623593ha_lal_
halala94715093ha_lala
halalas104214083ha_lalas
hallahs133912463hallahs
hallal94415563hallal_
hallels103310133hallels
halls85633783ha__lls
halma108219253halma__
halms105225213halm__s
halvahs16417533halvahs
halvas124714173halva_s
hamada1239923ha_mada
hamadas1339673hamadas
hamate113319833ha_mate
hamates122917683hamates
hamaul114210873ha_maul
hames106138703ha_m_es
hamlets123211403hamlets
hammed144116973hamm_ed
hammer138120033hamm_er
hammier143510653hammier
hammiest152610003hammiest
hamming153014093hamming
hammock2064633hammock
hammocks2164343hammocks
hammy155113433hamm__y
hampers143616953hampers
hams96446133ha_m__s
hamular1236973hamular
hamuli1137063ha_muli
hamulus1235323hamulus
hamza19139773hamza__
hamzah23135563hamza_h
hangars114313493hangars
hansas94616043hansa_s
hansels104011653hansels
hanumans1344953hanumans
harass9313943ha_rass
hardass1139753hardass
harls85634503ha__rls
harmers124116593harmers
harmins123716723harmins
harms106829013harm__s
hartal9415473hartal_
hassels104311013hassels
hatfuls1386023hatfuls
hauls86123733ha__uls
hawala12368913ha_wala
hawalas13348353ha_walas
haymows1883813haymows
hazans183411653ha_zans
hazels185710083ha_zels
hazmat20312263hazma_t
hazzans18215783hazzans
heals85733453h__eals
hemal104419803h_emal_
hemmers143310843hemmers
herbals122710603herbals
hetmans12187593hetmans
hiemal11339503hiemal_
hommos13128503homm_os
humans112312433h_umans
humerals1347173humerals
hummable1744583hummable
hummers143813063hummers
hummus1336243humm_us
hymnal1434913hymnal_
jacals1539873ja_cals
jackals2036893jackals
jammable2144513jammable
jammers183710703jammers
jammies183611293jammies
jumbals18106533jumbals
kamala12339963ka_mala
kamalas13339123ka_malas
karmas123013733karma_s
kummels15234793kummels
labials9299873labials
lamas75532793la_ma_s
lamias85020613lamia_s
laminals10339303laminals
lampads12477623lampads
lampas106615953lampa_s
lemmas10349163lemma_s
magmas115512503magma_s
mamas95930773ma_ma_s
mambas125716243mamba_s
mamma86317913mamma__
mammae94613213mamma_e
mammary1335993mammary
mammate104411273mammate
mammati10398373mammati
mammatus1144233mammatus
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mammies104314763mammies
mammons1048513mammons
manuals9311213manuals
maximals19325223maximals
meals75933373__meals
mommas94110653momma_s
narwals1036983narwals
nasals63312463na_sals
normals92510903normals
oatmeals1043843oatmeals
pampas124913993pampa_s
parrals94414573parrals
pascals11610013pascals
pommels13235783pommels
pummels13236543pummels
radials83614633radials
ramal74622243ra_mal_
ramblas112710263ramblas
rammers113715043rammers
ramtils938413ramtils
rascals959663rascals
ratals64219583ra_tals
sabals84618863sa_bals
sacrals93311793sacrals
salals65120083sa_lals
sambal105215183sambal_
sambars115113843sambars
sambas104219263samba_s
samiels939763samiels
sampans112411003sampans
sandals82715203sandals
shamans123610903sha_mans
shamas113717943sha_ma_s
shammash18293753shammash
shammers153710843shammers
shammes144312833shamm_es
shammies15259683shammies
shammos14307203shamm_os
stammels12495563stammels
summas104313163summa_s
tamal73522623ta_mal_
tamale83717403ta_male
tamales93216153ta_males
tambacs13219363tambacs
tambaks15218153tambaks
tambala1138023tambala
tambalas1237033tambalas
tammies113814683tammies
tampala1136613tampala
tampalas1245473tampalas
tampans113310983tampans
tarmacs1138323tarmacs
tarsals72512603tarsals
thermals13518533thermals
timbals11239533timbals
trammels12295413trammels
tymbals14265723tymbals
vandals113211663vandals
vassals1057953vassals
wadmaals1442413wadmaals
wadmal1237283wadmal_
wadmels1334303wadmels
wadmols1333913wadmols
wammus13426733wamm_us
whammies18265513whammies
yammers143410323yammers
yasmaks1633653yasmaks
zamias174212923zamia_s

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.406440125.6
2DLD Change Limit1340272726.56020430.9
3Display Results2722720.0962833.3
 (SQL Overall)1786912727.06225303.2
 
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.