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

408 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
haemal11381165(None) 
hamal104623121ha_mal
hammal134512071hammal
hemal104419801h_emal
hiemal11339511hiemal
caecal103713732caecal
chaetal1238282chaetal
chasmal14158212chasmal
daedal849082daedal
faecal11359812faecal
hadal95518122ha_dal
haem95730982haem__
haematal1345142haematal
haemic133210082haemic
haemin113412662haemin
haems105517012haem_s
halal85623592ha_lal
hallal94415562hallal
halma108219262halma_
halmas117017902halmas
hamals114816832ha_mals
hamaul114210872ha_maul
hammals14409232hammals
hammam12419342hammam
hartal9415482hartal
hazmat20312272hazmat
heal75645692h_e_al
hyetal1236542hyetal
mammal95112762mammal
ramal74622252ra_mal
tamal73522632ta_mal
wadmal1237292wadmal
aal39058673_a__al
acetal84314903acetal
adman84517913_adman
aecial84817313_aecial
aerial64625713_aerial
agma77623273_agma_
agmas85919883_agmas
ahead96817053ahe_ad
ahem97225363ahem__
algal66518223_algal
alma66333033_alma_
almah106917263_almah
almas76629783_almas
ama510853313_a_ma_
amah98927503_a_mah
amas67746303_a_mas
amyl95515103_a_myl
anal48037523_a_nal
animal85016253animal
annal56520763_annal
appal95315223_appal
areal55928743_areal
argal65023403_argal
artal55525483_artal
arval86017023_arval
atma68121783_atma_
atman75520153_atman
atmas75721023_atmas
aural54428963_aural
axal116520493_a_xal
axeman1538103axeman
axial124515193_axial
axman144813193_axman
baal67033113ba__al
badman113813853badman
bagman114613823bagman
banal75925993ba_nal
barbal104016673barbal
barman103519723barman
basal75722283ba_sal
baseman1138553baseman
batman105214073batman
bayman133712713bayman
bema85825253_bema_
bemas96424283_bemas
bharal1138893bha_ral
bromal10313653bromal
brumal1049503brumal
cabal95222153ca_bal
cabman123812513cabman
caeca93915133caeca_
caeoma1039033caeoma_
caeomas1138403caeomas
caesar8410943caesar
caiman103615673caiman
camail10314833ca_mail
camas96333533ca_mas
camel96822803ca_mel
cameral11311283cameral
canal75428043ca_nal
cantal84122033cantal
carman103920763carman
carnal83919223carnal
carpal103716263carpal
casual81112873casual
caudal91611483caudal
causal81413203causal
caveman1437073caveman
cayman133613223cayman
cecal94619113_cecal
chacma1537903chacma_
chacmas1638003chacmas
chaebol1444943chaebol
chaeta11310683chaeta_
chaetae1238603chaetae
chapman1637893chapman
chiasmal15285033chiasmal
coaeval1245183coaeval
coeval1138893coeval
comal95125133_comal
credal9311673credal
daemon9279593daemon
daman84821173da_man
damar84117753da_mar
dammar11438913dammar
deal56347413_de_al
decal85523233_decal
dedal75719023_dedal
dermal93614353dermal
dharma1276113dharma_
dharmas1356523dharmas
dismal92412243dismal
domal85619203_domal
edema8610553edema_
edemas9310503edemas
egal55119433__egal
email74715103__email
enema7612743enema_
enemas8812003enemas
facial113615633facial
faena85014203faena_
faenas94412763faenas
fallal93612693fallal
farfal123410193farfal
fatal84819373fa_tal
faucal11339963faucal
faunal94711593faunal
feal713940423_fe_al
fecal105119213_fecal
female11310553_female
feral85424653_feral
fetal85623373_fetal
foeman11311233foeman
foetal9311883foetal
formal113215213formal
gagman103811253gagman
gama77035533ga_ma_
gamas85431373ga_mas
gamay116419123ga_may
gametal1037603gametal
gamma106116113gamma_
gammas115714703gammas
gasman92911753gasman
gateman1057473gateman
gavial10310083gavial
gayal9312713ga_yal
gharial1137343gharial
gimmal11247513gimmal
gremial1039153gremial
haaf106227733ha__af
haar77323493ha__ar
hackman1836433hackman
hae67364003hae___
haed86338583hae__d
haeing104118923haeing
haematic151310223haematic
haematin13148893haematin
haemins122811403haemins
haemoid1337203haemoid
haen76229453hae__n
haeres94017033haeres
haes77651023hae__s
haet75659503hae__t
haets86525123hae_ts
haha107821063ha_ha_
hahas117118443ha_has
haika125313793haika_
hail74839063ha__il
halala94715093ha_lala
halals95018313ha_lals
hall75741163ha__ll
hallah124115403hallah
hallel93514093hallel
halm95834973halm__
halms105225213halm_s
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
ham86363283ha_m__
hamada1239923ha_mada
hamate113319833ha_mate
hamauls12387823ha_mauls
hame97043133ha_m_e
hames106138703ha_mes
hammada1545093hammada
hammams13386443hammams
hammed144116973hammed
hammer138120033hammer
hammily1736063hammily
hammy155113433ha_mmy
hams96446133ha_m_s
hamuli1137063ha_muli
hamza19139773ha_mza
hamzah23135563hamzah
hamzas20119013hamzas
handax1749583handax
hangar104114523hangar
hangman1337813hangman
hangul1049223hangul
hansa85416783hansa_
hansas94616043hansas
hansel95214373hansel
hanuman1237133hanuman
hapax1739323ha_pax
harem104924453harem__
harems115513823harem_s
harl75740003ha__rl
harm95637803harm__
harmed125218843harmed
harmer114719563harmer
harmful1535763harmful
harmin113117403harmin
harms106829023harm_s
hartals10313023hartals
hassel95614213hassel
hateful13107683hateful
hatful12108743hatful
haul75530453ha__ul
haverel13397153haverel
hawala12368913ha_wala
haymow1773683haymow
hazan173813613ha_zan
hazel176414813ha_zel
hazmats2136603hazmats
hazzan17236803hazzan
head87137173h_e_ad
headman13229633headman
heals85733463h_e_als
heap96432893h_e_ap
hear76143883h_e_ar
heat77061423h_e_at
heehaw1543953heehaw
heel75034223h_e_el
heil76328933h_e_il
hell75637893h_e_ll
hem86148733h_em__
hematal1238953h_ematal
heme95034413h_em_e
hemes105031083h_emes
hemic125718623h_emic
hemin103620933h_emin
hemp115725623h_em_p
hemps126917333h_emps
hempy154912763h_empy
hems95534943h_em_s
herald10311343h_erald
herbal112513493herbal
herl75834553h_e_rl
herma105318893herma_
hermae115314483hermae
hermai118912873hermai
hetman112510603hetman
hexad164910623h_exad
hexyl1844463h_exyl
hiatal9310203hiatal
hitman112710223hitman
horal86328683h_oral
human102716033h_uman
humeral1238573humeral
hyaena1235363hyaena_
hyaenas1334983hyaenas
hyena11810253hyena_
hyenas1288953hyenas
hymenal1545203hymenal
hymnal1434913hymnal
hyphal1736423hyphal
iceman1037853iceman
ideal65716393ide_al
ileal56118083ile_al
jacal14313703ja_cal
jackal1937613jackal
kamala12339973ka_mala
karma113415033karma_
karmas123013763karmas
labial84714343labial
laical8312323laical
lama66635303la_ma_
lamas75532803la_mas
larval948513larval
lateral7313573lateral
lawman11289063lawman
layman113511313layman
leal46043273_le_al
legal65715943_legal
leman75622603_leman
lienal63912793lienal
madman113712393madman
maenad939413maenad
magma104513583magma_
magmas115512513magmas
mama86231603ma_ma_
mamas95930783ma_mas
mamma86317923mamma_
mammae94613223mammae
mammals10389273mammals
mammas94616413mammas
manual8313463manual
maximal18347093maximal
meal65643173_me_al
meatal84114733meatal
medal86221333_medal
metal75427383_metal
miasmal1176743miasmal
narial6317963narial
narwal938953narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
nema65522523_nema_
nemas75321573_nemas
normal83213543normal
oatmeal944973oatmeal
paean77222723pae_an
paella8410923paella
paesan85114093paesan
paleal84716673paleal
palmar104113473palmar
palpal104112053palpal
papal95820673pa_pal
parral85517543parral
pascal10812373pascal
pausal81511963pausal
peal68648103_pe_al
pedal86022503_pedal
penal75228373_penal
petal76526893_petal
phaseal1245673phaseal
plexal1536843plexal
preman104117453preman
premeal11310523premeal
primal104014623primal
quezal2435143quezal
racial83419243racial
radial74020393radial
ragman94013723ragman
rascal8511123rascal
ratal55025113ra_tal
real45750293_re_al
regal65023793_regal
remail85017123_remail
reman75730153_reman
remap95418103_remap
renal55929513_renal
sabal75422483sa_bal
sacral83414413sacral
salal55425703sa_lal
sambal105215183sambal
sandal73317283sandal
seal45654373_se_al
seaman84015903seaman
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
shaman113314283sha_man
shamas113717943sha_mas
shammas14358723shammas
sheal84927703she_al
steal56125473ste_al
stomal85213313stomal
tael46030713tae__l
tamale83717403ta_male
tamals84116633ta_mals
tapetal938273tapetal
tarmac10310353tarmac
tarnal63716513tarnal
tarsal63315283tarsal
taxman15328623taxman
teal45546503_te_al
tepal76319583_tepal
thecal113310313thecal
thenal92712433thenal
thermal125010973thermal
ulema7109713ulema_
ulemas888963ulemas
ureal56722683ure_al
uveal84411073uve_al
vagal94613633va_gal
valval12398863valval
vandal103713833vandal
vanman1139803vanman
vasal85516293va_sal
vassal979243vassal
veal76936813_ve_al
venal85523213_venal
wadmaal1343203wadmaal
wadmals1335513wadmals
wadmel1235523wadmel
wadmol1234053wadmol
waeful1238123waeful
weal75838683_we_al
whaleman1643973whaleman
wheal115716183whe_al
yasmak1534603yasmak
zeal135530333_ze_al
zoeal144813783zoe_al

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 Limit1127164084.95322757.1
3Display Results4084080.1263238.1
 (SQL Overall)1786914085.45232775.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.