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

231 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
samosas93929(None) 
samosa8510201samosa_
camisas113411922camisas
mimosas1136752mimosas
ramonas9311092ramonas
salsas65316132sa_lsas
samaras9312912samaras
sambas104219262sam_bas
samovar1244242samovar
samovars1343702samovars
sapotas939612sapotas
saroses73619332saroses
serosas7312662serosas
vamoses1239142vamoses
abomas101113583_abomas
aftosas10147153aftosas
agoras7613343_agoras
alohas9411703_alohas
amas67746293_am__as
amass77119683_amas_s
amebas10311453_amebas
amias75831473_am_ias
amigas95912173_amigas
amiss75823073_amis_s
amoebas1135963_amoebas
amoks11413553_amo_ks
amoles84122193_amoles
amoral8314633_amoral
amours83512663_amours
amuses85117943_amuses
amusias938583_amusias
anoas57226493_ano_as
aromas81018613_aromas
balsas86417523ba_lsas
caeomas1138403caeomas
calesas9411833calesas
camas96333523cam__as
camases114216343camases
camass104114183camas_s
cameras11313363cameras
camisa103114323camisa_
camises114218463camises
camisias12268603camisias
camorras12116503camorras
camos95927613camo__s
canolas9313993canolas
casas75327843ca__sas
chamisas15317813chamisas
dagobas1145143dagobas
damasks1435073damasks
damosel10126693damosel
damosels11195233damosels
damsons1038013damsons
demoses103815823demoses
famous11412393famo_us
gamas85431363gam__as
gambas115817513gam_bas
gambias125010733gambias
gammas115714693gam_mas
gaposis1038423gaposis
hamadas1339673hamadas
hamzas20119013ham_zas
hansas94616043ha_nsas
kamalas13339123kamalas
kaross101910013karos_s
lamas75532793lam__as
lambdas1246243lambdas
lamias85020613lam_ias
laminas93615873laminas
lampas106615953lam_pas
mamas95930773mam__as
mambas125716243mam_bas
mammas94616403mam_mas
masas75630413__masas
massas85116463ma_ssas
mesas76823203__mesas
mimosa1036363mimosa_
moas65545343__mo_as
molas75132093__molas
monas74732153__monas
moras76438783__moras
mosks116117003__mosks
moss67641033__mos_s
mosts76028543__mosts
moxas145014393__moxas
mucosas11146683mucosas
oakmoss1342533oakmos_s
osmoses9138123osmoses
osmosis976573osmosis
pagodas11367553pagodas
paisas84317493pa_isas
pakoras1337473pakoras
pampas124913993pam_pas
payolas12148973payolas
ramadas1039303ramadas
ramblas112710263ramblas
ramona8412413ramona_
ramose8314403ramos_e
ramous8417113ramo_us
ramsons939563ramsons
remoras9314073remoras
rugosas844973rugosas
sabots8314703sabo_ts
sabras85116363sa_bras
sadisms10359113sadisms
sadists83310853sadists
sagas66025883sa__gas
sagos66123873sago__s
saigas74114293sa_igas
sajous13310583sajo_us
salinas73116093salinas
salivas10309603salivas
salmons93713263salmo_ns
salols64017873salo_ls
salons63823693salo_ns
saloons74415323saloons
saloops93510133saloops
salpas85116923sa_lpas
salsa56718923sa_lsa_
salvias10279933salvias
samara8313853samara_
samba95618773sam_ba_
sambal105215183sam_bal
sambals115213483sambals
sambar103914163sam_bar
sambars115113843sambars
sambhar1444853sambhar
sambhars1544833sambhars
sambos104315193sam_bos
sambucas1444163sambucas
samburs11369343samburs
samechs14285353samechs
samekhs16303923samekhs
sameks12409323sam_eks
samiels939763samiels
samisen937673samisen
samisens1035483samisens
samites93118713samites
samlets93813553samlets
samoyed1335893samoyed
samoyeds1442663samoyeds
sampan102511893sam_pan
sampans112411003sampans
samples112815453samples
samps96124673sam__ps
samsara936913sam_sara
samsaras1045873samsaras
samshu11134623sam_shu
samshus12125353samshus
samurai945923samurai
samurais1046143samurais
sangas75222653sa_ngas
sansar63613393sa_nsar
sansars73313913sa_nsars
sapors84118813sapo_rs
sapota8310213sapota_
sapotes9313943sapotes
sapours93610623sapours
sarcomas1247223sarcomas
sarodes84216143sarodes
sarods74918573saro_ds
sarongs84511803sarongs
saros55238063saro__s
sarsar63011843sa_rsar
sarsars73512143sa_rsars
sass45035623sa__s_s
sasses64124393sa_sses
sataras7315063sataras
satoris7317253satoris
saunas63915433sa_unas
savors95616103savo_rs
savours10389343savours
savoys12427893savo_ys
scabiosas1362613scabiosas
semioses10611013semioses
semiosis1059873semiosis
semises93916553semises
senoras72714953senoras
serosa6313023serosa_
serosae7310243serosae
serosal7311153serosal
shamas113717943sham__as
shammas14358723sham_mas
shamois123210423shamo_is
shamos114216983shamo__s
shamosim1544753shamosim
shamoys15367283shamo_ys
shamuses1336153shamuses
shiksas1484643shiksas
shmoes114612103shmo_es
siameses1036403siameses
simas75727553sim__as
simooms1135573simooms
simoons937943simoons
smocks145710013s_mocks
smogs85112163s_mo_gs
smokes124814343s_mokes
smolts84411883s_molts
sobas74424253s__obas
socas74026183s__ocas
sodas64123543s__odas
sofas85320713s__ofas
sojas124716393s__ojas
somas76030373s__omas
soras55041013s__oras
soroses73117483soroses
sorosis72611973sorosis
soyas84520913s__oyas
squamosal2051823squamosal
squamosals2151323squamosals
staminas1048853staminas
stoas55126023s_to_as
stomas84816323s_tomas
stoss54316343s_tos_s
summas104313163sum_mas
sumoists1046733sumoists
sumos75720093sumo__s
sycoses1249133sycoses
sycosis1238823sycosis
tamashas13135683tamashas
tamises92715973tamises
utmosts934593utmosts
vamooses1345523vamooses
vamose1159283vamos_e
vamosed1335923vamosed
wamuses1237023wamuses
zamias174212923zam_ias
zymosan2143803zymosan
zymosans2243223zymosans
zymoses21608693zymoses
zymosis21487493zymosis

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272316.54620474.6
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.04525364.2
 
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.