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

259 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
hammam1241933(None) 
hammal134512061hammal
hammams13386441hammams
dammar11438902dammar
gamma106116102gamma_
gammas115714692gammas
haemal113811642haemal
halma108219252halma_
halmas117017892halmas
hamal104623112ha_mal
hammada1545092hammada
hammals14409222hammals
hammed144116972hammed
hammer138120032hammer
hammy155113432hamm_y
hamza19139772hamza_
hamzah23135562hamzah
hamzas20119012hamzas
hazmat20312262hazmat
mamma86317912mamma_
mammae94613212mammae
mammal95112752mammal
mammas94616402mammas
shammas14358722shammas
abeam9316533_abeam
adman84517903_adman
agma77623263_agma_
agmas85919873_agmas
alma66333023_alma_
almah106917253_almah
almas76629773_almas
ama510853303_a_ma_
amah98927493_a_mah
amas67746293_a_mas
amia66836903_amia_
amias75831473_amias
ammo85520133_amm_o
ammos94815823_ammos
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
axman144813183_axman
badman113813843badman
bagman114613813bagman
balsam105612233balsam
bammed133913243bammed
bantam10314063bantam
barman103519703barman
batman105214063batman
bayman133712703bayman
cabman123812503cabman
caiman103615663caiman
camas96333523ca_mas
cammie124615293cammie
carman103920743carman
cayman133613213cayman
chacma1537903chacma_
chacmas1638003chacmas
chammy18488953chamm_y
champac1834953champac
champak2034493champak
chapman1637893chapman
chasmal14158213chasmal
comma114514793comma_
commas124814573commas
daman84821163da_man
damar84117743da_mar
dammars12308193dammars
dammed124214793dammed
dammer114317933dammer
dammit11311133dammit
dharma1276103dharma_
dharmas1356513dharmas
gagman103811243gagman
gama77035523ga_ma_
gamas85431363ga_mas
gamay116419113ga_may
gamba106018513gamba_
gambas115817513gambas
gammed124216163gammed
gammer1112318333gammer
gammon1138903gammon
gammy135514893gamm_y
gasman92911743gasman
gemma106311773gemma_
gemmae11507793gemmae
gimmal11247513gimmal
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
gumma105313103gumma_
gummas114810513gummas
haaf106227733ha__af
haar77323493ha__ar
hackman1836433hackman
hadal95518123ha_dal
haem95730983ha__em
haemic133210083haemic
haemin113412663haemin
haems105517013haem_s
haha107821063ha_ha_
hahas117118443ha_has
haika125313793haika_
hakeem15407383hakeem
hakim14311833ha_kim
halal85623593ha_lal
hallah124115403hallah
hallal94415563hallal
halm95834973ha__lm
halms105225213halm_s
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
ham86363283h___am
hamada1239923hamada
hamadas1339673hamadas
hamals114816823hamals
hamate113319833hamate
hamaul114210873hamaul
hame97043133ha_m_e
hames106138703ha_mes
hamlet113722793hamlet
hammadas1644793hammadas
hammers144216063hammers
hammier143510653hammier
hammily1736063hammily
hamming153014093hamming
hammock2064633hammock
hamper134518653hamper
hams96446133ha_m_s
hamular1236973hamular
hamuli1137063hamuli
hamzahs24134373hamzahs
handax1749583handax
hangar104114513hangar
hangman1337813hangman
hansa85416783hansa_
hansas94616043hansas
hansom11219153hansom
hanuman1237133hanuman
hapax1739323ha_pax
hareem114312063hareem
harem104924453ha_rem
harm95637793ha__rm
harmed125218833harmed
harmer114719553harmer
harmin113117393harmin
harms106829013harm_s
hartal9415473hartal
haulm104415413ha_ulm
haymow1773683haymow
hazan173813613ha_zan
hazmats2136603hazmats
hazzan17236803hazzan
headman13229633headman
hemal104419803h_emal
hemmed144211463hemmed
hemmer134112643hemmer
herma105318883herma_
hermae115314473hermae
hermai118912863hermai
hetman112510603hetman
hiemal11339503hiemal
hitman112710223hitman
hmm106218993h__m_m
hommos13128503hommos
human102716033h_uman
hummed144812673hummed
hummer133615273hummer
hummus1336243hummus
hymnal1434913hymnal
imam81718333__imam
jammed183811503jammed
jammer174014133jammer
jammy194810193jamm_y
kalam11315113ka_lam
karma113415003karma_
karmas123013733karmas
lactam10310943lactam
lama66635293la_ma_
lamas75532793la_mas
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
lammed113915623lammed
lampad114510033lampad
lampas106615953lampas
lawman11289053lawman
layman113511303layman
lemma94811033lemma_
lemmas10349163lemmas
madam10316223ma_dam
madman113712383madman
magma104513573magma_
magmas115512503magmas
mama86231593ma_ma_
mamas95930773ma_mas
mamba116317523mamba_
mambas125716243mambas
mammals10389273mammals
mammary1335993mammary
mammate104411273mammate
mammati10398373mammati
mammee94417853mammee
mammer94218863mammer
mammet94319253mammet
mammey124310893mammey
mammie94313783mammie
mammon939643mammon
mammy115215163mamm_y
marram10313883marram
momma85111053momma_
mommas94110653mommas
palmar104113463palmar
pampa114913423pampa_
pampas124913993pampas
ragman94013713ragman
ramal74622243ra_mal
rammed113117303rammed
rammer103519653rammer
rammy124312493ramm_y
salaam8711013salaam
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sampan102511893sampan
shaman113314283sha_man
shamas113717943sha_mas
shammash18293753shammash
shammasim1552423shammasim
shammed153911423shammed
shammer144613143shammer
shammes144312833shammes
shammos14307203shammos
shammy16388503shamm_y
shazam2046623sha_zam
summa94713313summa_
summae103911013summae
summas104313163summas
tamal73522623ta_mal
tambac122210243tambac
tambak14249263tambak
tammie104212693tammie
tammy124013223tamm_y
tampan102512323tampan
tarmac10310333tarmac
taxman15328613taxman
vanman1139793vanman
wadmal1237283wadmal
wammus13426733wammus
wampum15406053wampum
whammed18345133whammed
whammo16405193whamm_o
whammy19375293whamm_y
yammer133713183yammer
yasmak1534593yasmak
zamia165115213zamia_
zamias174212923zamias

Search took 6 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.373479064.3
2DLD Change Limit1127162595.44020719.9
3Display Results2592590.0932784.9
 (SQL Overall)1786912595.90630255.8
 
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.