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

324 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
salamis931351(None) 
salami8313101salami_
salmis8514271sal_mis
alamos8415002_alamos
calami10313422calami_
calamus1139242calamus
dalasis8810532dalasis
kalams12310602kalam_s
palais8420422pala_is
safaris101110662safaris
salaams997702salaams
salads75316962sala_ds
salals65120082sala_ls
salaries8319572salaries
salmi7815862sal_mi_
salukis1136032salukis
slams74927902s_lam_s
swamis114212292s_wamis
tatamis939712tatamis
aaliis6312893aal_iis
abamps1236253_abamps
abatis84317933_abatis
agamas97413443_agamas
agamic113110543_agamic
agamid103710673_agamid
agamids11317003_agamids
alamo7418143_alam_o
alands75418373_alands
alanin6317273_alanin
alanins7315803_alanins
alans55636173_ala_ns
alants67722023_alants
alarmism1245853_alarmism
alarmist1049123_alarmist
alarms85913053_alarms
alas46358123_ala__s
alates64833963_alates
alfakis1475073_alfakis
alibis8311073_alibis
alkalis11148783_alkalis
almahs118611613_almahs
almas76629773_al_mas
almes75126543_al_mes
alms65834923_al_m_s
alumin8513543_alumin
alumins9512983_alumins
alums75720603_alum_s
amis66445323___amis
animis84615943_animis
arames84622573_arames
aramid93315603_aramid
aramids102810503_aramids
ascaris93613323ascaris
asramas938303asramas
assais6711963assa_is
balas76937213bala__s
balases93815433balases
balatas9311833balatas
balms95723923bal_m_s
balsamic1463803balsamic
balsams11579013balsam_s
bayamos1434663bayamos
blames105121863_blames
blams95023853_blam_s
calamar1149293calamar
calamaris1346073calamaris
calamars1238133calamars
calamine12314033calamine
calamines13312213calamines
calamint12315133calamint
calamints1348053calamints
calamite12312533calamite
calamites13410713calamites
calamity1547753calamity
calms95222353cal_m_s
chlamys1733783chlamys
claims105211573_claims
clamps124515083_clamps
clams95127673_clam_s
dalasi7610623dalasi_
degamis11268433degamis
elemis8312383_elemis
filmis114610283fil_mis
flames114723693_flames
flams105125013_flam_s
galabia1038313galabia
galabias1137733galabias
galagos938143galagos
galahs105512673gala_hs
galas65731643gala__s
galaxes1538873galaxes
galaxies1637163galaxies
gelatis83313513gelatis
glacis94012133_glacis
glams85822933_glam_s
halakic1656653halakic
halakist15158223halakist
halalas104214083halalas
halals95018313hala_ls
halmas117017893hal_mas
halms105225213hal_m_s
jalapic1844543jalapic
jalapin1645923jalapin
jalapins1745623jalapins
jalaps15299183jala_ps
kalam11315113kalam__
kalmia1238893kal_mia
kalmias1347973kal_mias
lamas75532793__lamas
lambs95921413__lambs
lames75445543__lames
lamia75324323__lamia
lamias85020613__lamias
lamps95624833__lamps
lams66552263__lam_s
lanais6316793lana_is
lapis76223153__lapis
laris54737463__laris
llamas888973_llamas
madames12310063madames
madams11310943madam_s
maladies11311933maladies
malaise9312673mala_ise
malaria9313693malaria
malarias10313763malarias
malars85020683mala_rs
malates93522603malates
malms95021553mal_m_s
miladis1049813miladis
nalas55528363nala__s
pahlavis1643343pahlavis
pajamas18278153pajamas
palaces114216453palaces
paladin101011773paladin
paladins11911003paladins
palapas11311493palapas
palates93624933palates
palmist112814343pal_mist
palms94921753pal_m_s
panamas113112753panamas
paramos113213513paramos
psalmic1345333psal_mic
psalmist1276353psal_mist
psalms1045673psal_m_s
sabals84618863saba_ls
sadis64930853s__adis
safari91110223safari_
sagaman10117553sagaman
sagamen10127503sagamen
sagas66025883saga__s
saimin8313663sa_imin
saimins9312113sa_imins
sakis95323663s__akis
salaam8711013sala_am
salaamed1134623salaamed
salaaming1265363salaaming
salable91415463salable
salably121610743salably
salacious1147103salacious
salacity1347853salacity
salad65321833sala__d
salal55425703sala__l
salariat8416303salariat
salariats947823salariats
salaried9311023salaried
salary9515213sala_ry
saleps85014903sal_eps
sales56055593sal__es
salic73424713sal__ic
salicin9311223salicin
salicins10310933salicins
salifies11314793salifies
salinas73116093salinas
salines74029413salines
salivas10309603salivas
sallets73719653sallets
sallies73227813sallies
sallows103915543sallows
salmon84614183sal_mon
salmons93713253salmons
salols64017873sal_ols
salons63823683sal_ons
saloons74415303saloons
saloops93510133saloops
salpas85116923sal_pas
salpid9510873sal_pid
salpids1038193salpids
salps74423243sal__ps
sals46851673sal___s
salsas65316133sal_sas
salters73622253salters
saltie63422423sal_tie
salties73725773salties
saltish10312163sal_tish
salts55431883sal__ts
saluki1036203saluki_
salutes73716253salutes
salvages1238123salvages
salvers103916003salvers
salves94221763sal_ves
salvia93310753sal_via
salvias10279933salvias
salvoes102811313salvoes
salvors103910903salvors
salvos94613383sal_vos
samadhis1444253samadhis
samaras9312913samaras
samps96124673s__amps
sandhis1139993sandhis
sanseis73011603sanseis
santims9312593santims
sarans64224433sara_ns
sarapes94617743sarapes
saris54544953s__aris
sashimis1343753sashimis
satangs8479713satangs
satanic939933satanic
satanism1039673satanism
satanist8313363satanist
sataras7315053sataras
satays94411683sata_ys
satis55633673s__atis
satoris7317233satoris
savages1139973savages
savagism1444883savagism
savants1038653savants
savarin10310003savarin
savarins1139893savarins
savates10312953savates
scalades11258803scalades
scalados11276083scalados
scalages113010253scalages
scalares103210983scalares
scalars93711903scala_rs
scamps125014173s_camps
scams94423973s_cam_s
sclaffs1543573sclaffs
scrams105216623scram_s
sealants82610743sealants
seams75731663s_eam_s
selahs9313213sela_hs
selamlik1442093selamlik
selamliks1541963selamliks
semis74623533s__emis
serais64326133sera_is
sesames9310743sesames
shaloms1288983shalom_s
shamas113717933s_hamas
shames114726223s_hames
shamois123210403s_hamois
shamos114216983s_hamos
shams105829413s_ham_s
shamus114112813s_hamus
shlumps1434143shlumps
silages82514443silages
silanes72517163silanes
slabs75322643s_la_bs
slacks124416533s_lacks
slags66525903s_la_gs
slain54923573s_la_in
slakes104021883s_lakes
slalomist1174953slalomist
slaloms9106543slalom_s
slam67737973s_lam__
slangs75615343s_langs
slants64819083s_lants
slaps76025713s_la_ps
slates64934063s_lates
slats55436903s_la_ts
slaves95023023s_laves
slavish1338233s_lavish
slaws85222713s_la_ws
slays85723683s_la_ys
slimes84722043s_limes
slims75423653s_lim_s
slumism1136513s_lumism
slumps104313583s_lumps
slums74623433s_lum_s
solaces93116133solaces
solands84412343solands
solanin7311943solanin
solanins8310513solanins
solanos74412853solanos
solans64122493sola_ns
solaria7312493solaria
solarise8512543solarise
solarism10810383solarism
solates73523853solates
solatia7312243solatia
solums85211333solum_s
souaris7312333souaris
spahis11310383s_pahis
spams94922193s_pam_s
splakes1349673splakes
splats84817303spla_ts
splays114910873spla_ys
stalags838643stala_gs
stamps105614023s_tamps
stasis63116873s_tasis
steams84916903steam_s
sunlamps1243293sunlamps
surimis938843surimis
swami105614523s_wami_
swamies123712063s_wamies
swamps135910263s_wamps
sylis84316023syl__is
talaria7412503talaria
talars66021683tala_rs
talas55935893tala__s
tallis63319963tal_lis
tamaris9413573tamaris
tamis76728723__tamis
taramas9612693taramas
tatami839183tatami_
thalami1246063thalami_
thalamic1545533thalamic
thalamus1343593thalamus
tsunamis1042383tsunamis
tuladis835693tuladis
uakaris1146633uakaris
ulamas8910453_ulamas
umamis1038273_umamis
wakames1635283wakames
wasabis1255363wasabis

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.1561145455.1
2DLD Change Limit1340273247.54617761.3
3Display Results3243240.1102945.5
 (SQL Overall)1786913247.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.