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

478 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
stomal8521331(None) 
stoma75918271stoma_
stomas84816321stomas
stromal93010591stromal
atonal6514022atonal
bromal10313652bromal
comal95125132_comal
domal85619202_domal
shoal83920272sho_al
skoal93811462sko_al
soma65635292s_oma_
soman75024902s_oman
somas76030372s_omas
sporal82915452sporal
statal61613222statal
steal56125472st_eal
stigmal10245922stigmal
stoa45425912sto_a_
stoae55024262sto_ae
stoai55417872sto_ai
stoas55126022sto_as
stoat57135952sto_at
stoical9310282stoical
stomach1436032stomach
stomata938532stomata
stomatal1045832stomatal
stomate9313122stomate
stomp95616662stom_p
stomps105612832stomps
stool55619892sto_ol
storax1389782storax
stroma84313072stroma_
tamal73522622_tamal
toman75724052_toman
tombal102311022_tombal
tonal53724302_tonal
total55321822_total
aboma91114603aboma_
abomas101113583abomas
aboral8314373aboral
agonal7410053agonal
amoral8314633amoral
animal85016253animal
anodal72512123anodal
anomaly1238843anomaly
apodal9289833apodal
aroma71220143aroma_
aromas81018613aromas
asthma11126563asthma_
asthmas12117363asthmas
astomatal1144983astomatal
astral66919283ast_ral
atabal839743atabal
ataman81013063ataman
atma68121773at_ma_
atman75520143at_man
atmas75721013at_mas
atoll57913923ato_ll
atom67824523atom__
atomic104115603atomic
atomical1248903atomical
atoms76817563atom_s
atomy107415193atom_y
atrial65418943atrial
automan9310883automan
automat9414873automat
avowal1246323avowal
axonal1347653axonal
azonal1568273azonal
bestowal1344513bestowal
boral75831703_boral
bromals1139743bromals
brumal1049503brumal
choral115118493choral
clonal8310913clonal
coal66939253_co_al
coma87134853_coma_
comae97128423_comae
comas95833003_comas
copal95621783_copal
coral76033453_coral
coxal146116673_coxal
custumal12113593custumal
dermal93614343dermal
dismal92412243dismal
dotal64919623_dotal
estival1036323estival
estral64716513est_ral
estrual7367933estrual
etyma1036583etyma_
floral94313813floral
foal76630923_fo_al
focal104917673_focal
formal113215203formal
gimmal11247513gimmal
global937663global
goal55829303_go_al
gooral7310463gooral
goral65125753_goral
haemal113811643haemal
hamal104623113_hamal
hammal134512063hammal
hemal104419803_hemal
hiemal11339503hiemal
horal86328683_horal
intimal9109943intimal
joual12311653_joual
litoral7610763litoral
local74820273_local
loral55927823_loral
loyal84513483_loyal
mammal95112753mammal
modal85919243_modal
molal75120343_molal
moral75533433_moral
myoma1239273myoma_
myomas1338303myomas
nodal64717793_nodal
noma67529463_noma_
nomad86016183_nomad
nomas74726413_nomas
nopal75517103_nopal
normal83213533normal
notal55221353_notal
opal66923523__opal
optimal1145783optimal
oral47638123__oral
osmolal944393osmolal
osteal6312963ost_eal
osteoma945433osteoma_
osteomas1045333osteomas
ostomate1049573ostomate
ostomy1137833ostom_y
ottoman946283ottoman
oval77119523__oval
pastoral10310483pastoral
phonal11310383phonal
postoral10311723postoral
potman102813573potman
primal104014623primal
ptomain1146963ptomain
ramal74622243_ramal
restoral8810983restoral
retotal739843retotal
roman75424823_roman
royal85014703_royal
sabal75422483s_abal
sacral83414413sacral
sal36462883s___al
salal55425703s_alal
sambal105215183sambal
sandal73317283sandal
schmalz2345293schmalz
scotoma1155963scotoma_
scotomas1256263scotomas
scowl1012012973sco_wl
scrotal938493scrotal
seal45654373s__eal
seaman84015903seaman
seconal9310073seconal
sectoral10109543sectoral
seismal937303seismal
sendal73314993sendal
sepal77723003s_epal
septal84513383septal
seral56336383s_eral
serial64625863serial
serosal7311153serosal
serumal938783serumal
serval93913413serval
setal56430903s_etal
sexual1338423sexual
shaman113314283shaman
shamas113717943shamas
sheal84927703s_heal
shoals94215793sho_als
shoaly124010773sho_aly
shoat85633953sho_at
shofar1236313shofar
shool84523153sho_ol
shopman14247263shopman
shoran94016043shoran
shorl84720253sho_rl
shovel124611323shovel
showman15257293showman
sial45938833s__ial
sigma84513833sigma_
sigmas94111363sigmas
signal73711483signal
sima64730783s_ima_
simar74920813s_imar
simas75727553s_imas
sisal54217733s_isal
skoals10438243sko_als
skyman1535313skyman
slogan7539223slogan
small74016263s__mall
smalt74729333s__malt
snool55118643sno_ol
snowman12226623snowman
soak87227663s_o_ak
soap65831133s_o_ap
soar46838673s_o_ar
soba64927923s_oba_
sobas74424253s_obas
soca66330053s_oca_
socas74026183s_ocas
social8813333social
socman1039813socman
soda56329383s_oda_
sodas64123543s_odas
sofa75625603s_ofa_
sofar86115493s_ofar
sofas85320713s_ofas
soil46138833s_o_il
soja115619513s_oja_
sojas124716393s_ojas
sokol94612293s_okol
sol37256623s_o__l
sola45541863s_ola_
solan55328153s_olan
solar55927343s_olar
som59153813s_om__
somans84619303s_omans
somata8312383s_omata
some66040383s_om_e
somital939403s_omital
soms66239373s_om_s
sonar56523423s_onar
sora45746913s_ora_
soras55041013s_oras
sorel56231443s_orel
sororal7310653sororal
sotol54917653s_otol
soul46435713s_o_ul
sowar85821343s_owar
soya75724433s_oya_
soyas84520913s_oyas
spinal84915313spinal
spiral83715343spiral
spital83813873spital
spoil75818653spo_il
sponsal946343sponsal
spool75219043spo_ol
spousal965533spousal
squeal1538023squeal
stab67329933st__ab
stag57332003st__ag
stalag7310023stalag
stale55637103st__ale
stalk94518003st__alk
stall54722353st_all
stamen84115943stamen
staminal1046983staminal
stammel11607533stammel
stamp95217363stam_p
stamps105614023stamps
stanol6310723stanol
star48037763st__ar
stat47352693st__at
staw78627693st__aw
stay78333723st__ay
stead65520273st_ead
steak95219803st_eak
steals64020063st_eals
steam76322933st_eam
steams84916903steams
steamy115112373steamy
steel55721993st_eel
stela54019043stela_
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stella63612973stella
stem610628253stem__
stemma10328133stemma
stemmas11256973stemmas
stemmy13417033stemmy
stems75219953stem_s
sternal73411913sternal
sterol6613333sterol
stibial946583stibial
stigma9226763stigma_
stigmas10206643stigmas
still54922083st_ill
stime76521803stim_e
stimes85920573stimes
stimuli944513stimuli
stimy105114743stim_y
stipel84412123stipel
stoats65117483stoats
stob66724613sto__b
stobs75718233sto_bs
stock114417563sto_ck
stockman1644143stockman
stocks124715633stocks
stocky15369153stocky
stodge8369043stodge
stodgy11415733stodgy
stogey105811543stogey
stogie7311323stogie
stogy95414083sto_gy
stoic7317253sto_ic
stoics8311113stoics
stoke94922513sto_ke
stoked114718293stoked
stoker104417623stoker
stokes104821793stokes
stole54928813sto_le
stoled74521593stoled
stolen64315063stolen
stoles63927673stoles
stolid74213183stolid
stolon64112073stolon
stomachs1544953stomachs
stomachy1843823stomachy
stomates10313343stomates
stomatic12312003stomatic
stomodeal1252463stomodeal
stomped124110533stomped
stomper114111233stomper
stonable1039843stonable
stone55431183sto_ne
stoned75923143stoned
stoner65823203stoner
stones65130033stones
stoney96217353stoney
stonily1049433stonily
stony85818643sto_ny
stood65517713sto_od
stooge73811663stooge
stook95218213sto_ok
stooks105115373stooks
stools65117023stools
stoop75821543sto_op
stoops85917893stoops
stop66532033sto__p
stope74727243sto_pe
stoped94721013stoped
stoper84320103stoper
stopes84525893stopes
stopgap1243533stopgap
stopple1156583stopple
stops74827283sto_ps
stopt76528353sto_pt
storable10310733storable
storage8310473storage
store56333813sto_re
stored75524213stored
storer64721673storer
stores65533663stores
storey95217613storey
stork96819693sto_rk
storks106115953storks
storm76520403sto_rm
stormed1039043stormed
stormily1345243stormily
storms85814633storms
stormy115510733stormy
story86723033sto_ry
stoss54316343sto_ss
stot46347333sto__t
stotin63215063stotin
stots54828553sto_ts
stott56929793sto_tt
stotts64612863stotts
stound7399903stound
stoup75517073sto_up
stoups85313273stoups
stour54916743sto_ur
stoure64814943stoure
stours65015633stours
stoury9529943stoury
stout57434053sto_ut
stoutly1035833stoutly
stouts65019003stouts
stove85220253sto_ve
stover94115643stover
stoves93818923stoves
stow77325743sto__w
stowable1337613stowable
stowage1136703stowage
stowed105817203stowed
stowp105614233sto_wp
stowps115710583stowps
stows86622703sto_ws
strap77925263st_rap
stratal72710603stratal
straw813321293st_raw
stray88525573st_ray
streak104613623streak
stream84717293stream
streel64214023streel
stria55723213stria_
striae65422273striae
strobil936963strobil
stroll6311603stroll
stromata1047593stromata
struma84313273struma_
strumae9368093strumae
strumas9419833strumas
stull54916273st_ull
stum65526023stum__
stumble1147553stumble
stump94616463stum_p
stumps104912283stumps
stumpy13458133stumpy
stums75320083stum_s
stupa74112313stupa_
stupas83910883stupas
stylar9358113stylar
stymie1137623stymie
stymy13358293stym_y
styrax1675243styrax
suboral92011993suboral
suboval12216723suboval
subtotal1046263subtotal
sudoral8148543sudoral
sulcal8311273sulcal
sumac99514883s_umac
summa94713313summa_
summae103911013summae
summas104313163summas
sural55931263s_ural
sutural7310223sutural
synodal1145743synodal
tamale83717403_tamale
tamals84116633_tamals
teal45546503_t_eal
tepal76319583_tepal
tical76021493_tical
tidal64516443_tidal
timbal102510753_timbal
toad55830183_to_ad
today96416953_today
toea46732333_toea_
toeas55726423_toeas
toga57027413_toga_
togae67020113_togae
togas67823003_togas
toil46536283_to_il
tokay125513053_tokay
tola45236333_tola_
tolan55124013_tolan
tolar55524113_tolar
tolas54532773_tolas
toll45535263_to_ll
tolyl84710093_tolyl
tom514358053_tom__
tomans85419133_tomans
tomato8313453_tomato
tomb89029653_tom_b
tombac12258883_tombac
tombak14237753_tombak
tombs97818733_tombs
tomcat101013453_tomcat
tome67543193_tom_e
tomes76037383_tomes
tommy124712233_tommy
toms68343493_tom_s
tool46735683_to_ol
topaz16315323_topaz
tora47545993_tora_
torah87125273_torah
toras55540373_toras
totals63115163_totals
towel84920523_towel
trial54926353_trial
tubal75517203_tubal
tymbal13236823_tymbal
typal105311153_typal
vocal104715643_vocal
wadmal1237283wadmal
woman105818003_woman
yeoman1138823yeoman
zoeal144813783_zoeal
zonal145116853_zonal
zoonal1558083zoonal

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 Limit1127164785.44020719.9
3Display Results4784780.1403414.3
 (SQL Overall)1786914785.95330017.0
 
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.