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

281 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
hiemal1133950(None) 
haemal113811641haemal
hemal104419801h_emal
dismal92412242dismal
gimmal11247512gimmal
hamal104623112h_amal
hammal134512062hammal
heal75645692h_e_al
hiatal9310202hiatal
hitman112710222hitman
hyetal1236542hyetal
lienal63912782lienal
acetal84314903acetal
aidman92410623aidman
airmail946213airmail
airman82414223airman
animal85016253animal
areal55928733are_al
axeman1538103axeman
bema85825253_bema_
bemas96424283_bemas
biaxal1536093biaxal
bima86723833bi_ma_
bimah127013273bi_mah
bimas95521743bi_mas
bimetal1138433bimetal
binal75323823bi_nal
bipedal1245683bipedal
bitmap1235613bitmap
bromal10313653bromal
brumal1049503brumal
caecal103713733caecal
cecal94619113_cecal
chaetal1238283chaetal
chasmal14158213chasmal
chiasmal15285033chiasmal
chiel104918973chie__l
chimar133911473chi_mar
chimla1337593chi_mla
chiral114614413chi_ral
chital114313883chi_tal
chrismal1575173chrismal
cinema1047653cinema_
cinemas1138043cinemas
citral81113893citral
coeval1138893coeval
comal95125133_comal
credal9311673credal
daedal849083daedal
deal56347413_de_al
decal85523233_decal
dedal75719023_dedal
dermal93614343dermal
dial55935063di__al
diel59034603die__l
diesel74410403diesel
dismals102010243dismals
dismay12229473dismay
distal73615773distal
domal85619203_domal
edema8610553edema_
edemas9310503edemas
egal55119433__egal
email74715103__email
enema7612743enema_
enemas8812003enemas
faecal11359813faecal
feal713940423_fe_al
fecal105119213_fecal
female11310553_female
feral85424653_feral
fetal85623373_fetal
filial93013253filial
final83922033fi_nal
finial92814183finial
fireman1249333fireman
firman112211343firman
fiscal1139333fiscal
foeman11311233foeman
foetal9311883foetal
formal113215203formal
gimbal11228813gimbal
gimel8313353gi_mel
gimmals12225823gimmals
gingal81010153gingal
gremial1039153gremial
hadal95518123h_adal
haem95730983haem__
haematal1345143haematal
haemic133210083haemic
haemin113412663haemin
haems105517013haem_s
halal85623593h_alal
hallal94415563hallal
halma108219253halma_
halmas117017893halmas
hamals114816823h_amals
hamaul114210873h_amaul
hammals14409223hammals
hammam12419333hammam
hartal9415473hartal
hazmat20312263hazmat
head87137173h_e_ad
heals85733453h_e_als
heap96432893h_e_ap
hear76143883h_e_ar
heat77061423h_e_at
heehaw1543933heehaw
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
herma105318883herma_
hermae115314473hermae
hermai118912863hermai
hetman112510603hetman
hexad164910623h_exad
hexyl1844463h_exyl
hibernal1344403hibernal
hie67652703hie___
hied85434043hie__d
hieing104216623hieing
hies74842833hie__s
hijab1736803hi_jab
hijra1535643hijra_
hijrah1934283hijrah
hijras1635773hijras
hila76228353hi_la_
hilar85418143hi_lar
hill76439493hi__ll
him86247663hi_m__
hims95230973hi_m_s
hirsel9138683hirsel
hitmen11239193hitmen
horal86328683h_oral
human102716033h_uman
humeral1238563humeral
hyena11810253hyena_
hyenas1288953hyenas
hymenal1545183hymenal
hymnal1434913hymnal
hyphal1736413hyphal
iceman1037853iceman
ideal65716393_ideal
ileal56118083_ileal
ilial55317843_ilial
imam81718333_i_mam
jingal1498593jingal
kinema1236023kinema_
kinemas1336893kinemas
kismat123011673kismat
leal46043273_le_al
legal65715943_legal
leman75622603_leman
liberal9310193liberal
lima65734133li_ma_
liman75921603li_man
limas75627633li_mas
lineal65616023lineal
lineman939123lineman
literal7613273literal
mammal95112753mammal
meal65643173_me_al
medal86221333_medal
metal75427383_metal
miasmal1176743miasmal
mineral9312733mineral
minimal114010603minimal
miskal123710263miskal
missal84314903missal
mitral81314323mitral
nema65522523_nema_
nemas75321573_nemas
nidal65217103ni_dal
nival84915773ni_val
normal83213533normal
oilman839483oilman
peal68648103_pe_al
pedal86022503_pedal
penal75228373_penal
petal76526893_petal
phial10313203phi__al
pial65636703pi__al
pibal95217323pi_bal
pical95524373pi_cal
piebald1245503piebald
pieta75421753pieta_
pietas84516503pietas
pikeman1535523pikeman
pima85428653pi_ma_
pimas94725103pi_mas
pineal84817683pineal
pinnal84814273pinnal
pipal95118353pi_pal
pitman102412123pitman
plexal1536843plexal
preman104117453preman
premeal11310523premeal
primal104014623primal
quezal2435143quezal
ramal74622243_ramal
real45750293_re_al
regal65023793_regal
remail85017123_remail
reman75730153_reman
remap95418103_remap
renal55929503_renal
rhinal9510193rhi_nal
rial45938093ri__al
rictal83113183rictal
riel46432383rie__l
ritual6310623ritual
rival85216503ri_val
riyal84413433ri_yal
seal45654373_se_al
seismal937303seismal
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
sheal84927703she_al
shiel811023773shie__l
shipman14247133shipman
shrieval1443363shrieval
sial45938833si__al
sideman1037973sideman
sigma84513833sigma_
sigmas94111363sigmas
signal73711483signal
sima64730783si_ma_
simar74920813si_mar
simas75727553si_mas
sisal54217733si_sal
steal56125473ste_al
stigmal10245923stigmal
stomal85213313stomal
tamal73522623_tamal
teal45546503_te_al
tepal76319583_tepal
thecal113310303thecal
thenal92712423thenal
thermal125010973thermal
tibial849843tibial
tical76021493ti_cal
tidal64516443ti_dal
timbal102510753timbal
tincal83913363tincal
tineal66216163tineal
tinman82411143tinman
titman82711003titman
ulema7109713ulema_
ulemas888963ulemas
ureal56722683ure_al
uveal84411073uve_al
veal76936813_ve_al
veinal93812963veinal
venal85523213_venal
vial76731093vi__al
vinal85725813vi_nal
vineal94814743vineal
viral86419593vi_ral
visual938803visual
vital84819673vi_tal
wadmal1237283wadmal
weal75838683_we_al
wheal115716183whe_al
wireman1237843wireman
withal1238933withal
zeal135530333_ze_al
zoeal144813783zoe_al

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.376475242.0
2DLD Change Limit1127162815.68619823.4
3Display Results2812810.0803512.5
 (SQL Overall)1786912816.14229093.3
 
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.