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

173 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
hamular123697(None) 
alular6311352_alular
canular9310322canular
fabular12288692fabular
facular122810442facular
hamulate1359012hamulate
hamuli1137062hamul_i
hamulus1235322hamulus
hauler95015122ha_uler
macular113011942macular
pabular11259472pabular
papular11299762papular
radular837832radular
ranular739432ranular
simular938672simular
tabular9279762tabular
tumular9236542tumular
alar46340073_a__lar
alula5317093_alula_
alulae6312743_alulae
ambler104916453_ambler
ampler104313303_ampler
ampullar1253133_ampullar
amulet8419573_amulet
amuser84712623_amuser
angular838533angular
annular737693annular
ashlar9338193_ashlar
aurar54420253_a_urar
bacula103112673bacula_
basilar937303basilar
cannular1046283cannular
canula8312963canula_
canulae9311183canulae
canulas9312853canulas
capsular1245403capsular
copular113810603copular
cupular11317623cupular
damar84117733dam__ar
dammar11438903dam_mar
facula112912233facula_
faculae123210353faculae
familiar1365953familiar
famuli1136763famul_i
famulus1235043famulus
fibular12267973fibular
gambler123612683gambler
gamelan10106643gamelan
granular946893granular
gular6314833__gular
haar77323493ha___ar
hackler163512353hackler
haggler12328933haggler
hailer94720343ha_iler
halal85623593ha__lal
halala94715093halala_
halalah13429393halalah
halalas104214083halalas
haler85033523ha__ler
hallah124115403ha_llah
hallal94415563ha_llal
hamada1239923hamada_
hamadas1339673hamadas
hamal104623113ham__al
hamals114816823hamal_s
hamaul114210873hamaul__
hamauls12387813hamaul_s
hamlet113722793ham_let
hammal134512063ham_mal
hammals14409223hammals
hammam12419333ham_mam
hammer138120033ham_mer
hammier143510653hammier
hamper134518653ham_per
hamster12810423hamster
hamulose1344283hamulose
hamulous1344923hamulous
hamza19139773ham_za_
hamzah23135563ham_zah
hamzas20119013ham_zas
handcar1337373handcar
handler113516163handler
hangar104114513ha_ngar
hanuman1237133hanuman
haul75530453ha_ul__
haulage1136913ha_ulage
hauled104415213ha_uled
haulers104012443ha_ulers
haulier1059943ha_ulier
haulm104415413ha_ul_m
haulms11558503ha_ulms
haulmy14455553ha_ulmy
hauls86123733ha_ul_s
haulyard1583223ha_ulyard
hawala12368913hawala_
hawalas13348353hawalas
hilar85418143h__ilar
hula74923753h__ula_
hulas84920883h__ulas
humbler143411943humbler
insular7138703insular
jaguar1435283jagu_ar
jocular1637303jocular
jugular1534513jugular
kamala12339963kamala_
kamalas13339123kamalas
lacunar9136293lacunar
lamellar1096493lamellar
laminar93810283laminar
ligular8348533ligular
lobular936663lobular
locular938953locular
lunular736013lunular
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443__malar
mauler84416713ma_uler
modular1087363modular
molar75223093__molar
morular978223morular
mutular936643mutular
mylar105311533__mylar
nebular956483nebular
nodular876703nodular
nummular1242693nummular
ocular8610133_ocular
oracular1047533oracular
oscular937933oscular
osmolar944483osmolar
ovular946833_ovular
papula103011113papula_
papulae11249353papulae
piacular1246573piacular
pilular938203pilular
planular1044753planular
plumular1243303plumular
popular11319563popular
radula749313radula_
radulae837963radulae
radulas839583radulas
rambla103510933rambla_
ramblas112710263ramblas
rambler113313263rambler
ranula6311813ranula_
ranulas7311773ranulas
regular838423regular
saccular1246893saccular
sambar103914163sam_bar
sambhar1444853sambhar
samovar1244243samovar
sampler113212013sampler
samurai945923samurai
scapular1245373scapular
secular92211533secular
similar937853similar
simulars1047073simulars
spatular1044653spatular
talar56225383ta__lar
tegular836603tegular
templar1145643templar
titular737523titular
tubular9267473tubular
undular837123undular
ungular836773ungular
uvular955563_uvular
vacuolar1353483vacuolar
valvular1443463valvular
vascular1346293vascular
venular1037683venular
yamulka1651773yamulka
yamulkas1741793yamulkas
zonular1656493zonular

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271736.22021547.7
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.68626726.1
 
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.