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

247 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
hamaul11421087(None) 
hamal104623111hama_l
hamauls12387811hamauls
ampul91110852_ampul
camail10314832camail
hadal95518122hada_l
haemal113811642haema_l
halal85623592hala_l
hamada1239922hamada
hamals114816822hamals
hamate113319832hamate
hammal134512062hammal
hamuli1137062ham_uli
hangul1049212hangul
harmful1535762harmful
hatful12108742hatful
haul75530452h__aul
hemal104419802hema_l
maul64830722__maul
ramal74622242rama_l
tamal73522622tama_l
aal39058673_a_a_l
afoul8510193_afoul
aimful1166703aimful
ama510853303_ama__
amah98927493_ama_h
amahs107819063_amahs
amain74922913_amain
amas67746293_ama_s
amass77119683_amass
amatol838693_amatol
amaze166016603_amaze
amour75014853_amour
ampule10710613_ampule
ampuls1098893_ampuls
amu58237323_am_u_
amus65529613_am_us
amyl95515103_am_yl
anal48037523_ana_l
annul55813383_annul
armful1167163armful
avail8313883_avail
awful1178143_awful
axal116520493_axa_l
baal67033113ba_a_l
babul96317713ba_bul
bagful1237213bagful
banal75925993bana_l
basal75722283basa_l
bharal1138893bhara_l
cabal95222153caba_l
camails11311753camails
camas96333523cama_s
camass104114183camass
camel96822803cam_el
campus125213923campus
canal75428043cana_l
canful11610263canful
capful1368173capful
caracul1138823caracul
carful11610973carful
casual81112863casual
caul65630003__caul
chamade15138453chamade
chasmal14158213chasma_l
comal95125133coma_l
damage10410773damage
daman84821163dama_n
damans94715983damans
damar84117733dama_r
damars93814993damars
damask1335843damask
damsel9148033damsel
domal85619203doma_l
earful958963earful
email74715103_email
famous11412393famous
famuli1136763fam_uli
fatal84819373fata_l
gama77035523gama__
gamas85431363gama_s
gamay116419113gama_y
gamays126310913gamays
gambol1138223gambol
gamut8322983gam_ut
gayal9312713gaya_l
haaf106227733ha_a_f
haafs115711163ha_afs
haar77323493ha_a_r
haars85620473ha_ars
habu97325483ha_bu_
habus106317143ha_bus
haematal1345143haematal
hagbut1278923hagbut
haha107821063haha__
hahas117118443haha_s
haiku126113693haiku_
haikus13538293haikus
hail74839063h__ail
haku116923893ha_ku_
hakus125114113ha_kus
halala94715093halala
halals95018313halals
hall75741163h__all
hallal94415563hallal
hallel93514093hallel
hallux1637363hallux
halma108219253halma__
halmas117017893halma_s
ham86363283ham___
hamadas1339673hamadas
hamates122917683hamates
hamburg1544123hamburg
hame97043133ham__e
hames106138703ham_es
hamlet113722793hamlet
hammada1545093hammada
hammals14409223hammals
hammam12419333hammam
hammams13386443hammams
hammed144116973hammed
hammer138120033hammer
hammily1736063hammily
hammy155113433ham_my
hamper134518653hamper
hams96446133ham__s
hamular1236973ham_ular
hamulus1235323hamulus
hamza19139773ham_za
hamzah23135563hamzah
hamzahs24134373hamzahs
hamzas20119013hamzas
handful14127253handful
hangup1277293hangup
hansel95214373hansel
hapax1739323hapa_x
harass9313943harass
harl75740003h__arl
hartal9415473hartal
hassel95614213hassel
hatable121713963hatable
hateful13107683hateful
hatfuls1386023hatfuls
hatsful13106193hatsful
haulm104415413h__aulm
hauls86123733h__auls
haut75949733h__aut
hawala12368913hawala
hazan173813613haza_n
hazans183411653hazans
hazard1938403hazard
hazel176414813ha_zel
hazmat20312263hazma_t
hazmats2136603hazmats
headful1445563headful
heal75645693h_ea_l
hematal1238953hematal
hiatal9310203hiata_l
hiemal11339503hiema_l
homage121210603homage
horal86328683hora_l
human102716033huma_n
humane112812173humane
humanly1545683humanly
humans112312433humans
humate113214443humate
humbug1434803humbug
hummus1336243hummus
humour11116753humour
humus106215073hum_us
hymnal1434913hymnal
iambus10468903iambus
imaum9139643_imaum
inhaul936803inhaul
jacal14313703jaca_l
jarful1646683jarful
kamala12339963kamala
karakul1042553karakul
lama66635293lama__
lamas75532793lama_s
lapful1156483lapful
lawful1235493lawful
mail65543453__mail
mall64639373__mall
mama86231593mama__
mamas95930773mama_s
mamluk1434743mamluk
mammal95112753mammal
manful11610213manful
manual8313463manual
maraud938943maraud
marl66341623__marl
maud75325403__maud
mauls76524953__mauls
maun65727213__maun
maut65448453__maut
miaul71612123_miaul
namable11312343namable
nasal56217593nasa_l
natal53921493nata_l
naval85315833nava_l
padauk1335643padauk
palmful1445053palmful
panful1179743panful
papal95820673papa_l
ramada9310183ramada
ramate83921683ramate
ramous8417113ramous
ramtil8311023ramtil
ramus76418283ram_us
ratal55025113rata_l
remail85017123remail
rhamnus1233133rhamnus
sabal75422483saba_l
salal55425703sala_l
samara8313853samara
sambal105215183sambal
sambur10469503sambur
samiel8313333samiel
saul45836523__saul
shamable15168803shamable
shamably18165803shamably
shaman113314283shama_n
shamans123610903shamans
shamas113717943shama_s
shameful1644283shameful
shamus114112813sham_us
shaul85418103_shaul
small74016263_small
tamable11312853tamable
tamale83717403tamale
tamals84116633tamals
tamari8313403tamari
tambur10358713tambur
vagal94613633vaga_l
vasal85516293vasa_l
vatful12107083vatful
wadmaal1343203wadmaal
wadmal1237283wadma_l
waeful1238123waeful
wameful1535673wameful
wammus13426733wammus
wampum15406053wampum
wampus13499013wampus
wamus105514683wam_us
waul76927313__waul
yamun10419273yam_un

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.420425454.8
2DLD Change Limit1127162475.53320371.6
3Display Results2472470.0763250.0
 (SQL Overall)1786912476.02929638.6
 
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.