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

288 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
shammas1435871(None) 
shamas113717931sha_mas
shammash18293741shammash
shammes144312831shammes
shammos14307201shammos
chacmas1637992chacmas
dharmas1356502dharmas
gammas115714692_gammas
grammas12499772grammas
halmas117017892_halmas
hammal134512062_hammal
hammals14409212_hammals
hammam12419332_hammam
hammams13386432_hammams
hamzas20119012_hamzas
mammas94616402_mammas
sambas104219262s_ambas
shaman113314272sha_man
shamans123610892shamans
shames114726222sha_mes
shammasim1552402shammasim
shammed153911422shammed
shammer144613142shammer
shammers153710832shammers
shammies15259672shammies
shammy16388502shamm_y
shamois123210402shamois
shamos114216982sha_mos
shamoys15367282shamoys
shams105829412sha_m_s
shamus114112812sha_mus
sharias102516002sharias
shawms14579562shawm_s
stemmas11256972stemmas
summas104313162s_ummas
agamas97413443aga_mas
agmas85919873__agmas
ahimsas1234783ahimsas
almas76629773__almas
amas67746293__a_mas
amias75831473__amias
ammos94815823__ammos
asramas938303asra_mas
atmas75721013__atmas
bhaktas1633643bhaktas
brahmas1436733brahmas
camas96333523_ca_mas
chacma1537903chacma_
chakras16428483chakras
challas124414123challas
chamisa14328853chamisa
chamisas15317793chamisas
chammies172910153chammies
chammy18488953chamm_y
chamois143512173chamois
champac1834953champac
champacs1934623champacs
champak2034493champak
champaks2134093champaks
champs154915683cha_mps
chams126028503cha_m_s
chapman1637893chapman
charas114223593cha_ras
charkas164810953charkas
charms135218833charm_s
chasmal14158213chasmal
chasms135513143chasm_s
chiasmas15306583chiasmas
chimlas1437453chimlas
chromas142512683chromas
commas124814573_commas
dammar11438903_dammar
dammars12308193_dammars
dharma1276103dharma_
dharnas1155373dharnas
digammas1442983digammas
dramas95814653dra_mas
gamas85431353_ga_mas
gambas115817513_gambas
gamma106116103_gamma_
gramas94317203gra_mas
gramma11499803gramma_
grammar12406893grammar
grammars13345943grammars
grammes123611323grammes
grampas12399253grampas
gummas114810513_gummas
haemal113811643_haemal
haems105517013_haem_s
hahas117118443_ha_has
halma108219253_halma_
halms105225213_halm_s
halvas124714173_halvas
hamadas1339663_hamadas
hamal104623103_ha_mal
hamals114816813_hamals
hames106138703_ha_mes
hammada1545083_hammada
hammadas1644783_hammadas
hammed144116973_hammed
hammer138120033_hammer
hammers144216053_hammers
hammy155113433_hamm_y
hams96446133_ha_m_s
hamza19139773_hamza_
hamzah23135553_hamzah
hamzahs24134373_hamzahs
hansas94616043_hansas
harms106829013_harm_s
hazmat20312263_hazmat
hazmats2136603_hazmats
hommos13128503_hommos
hummus1336243_hummus
karmas123013733_karmas
lamas75532793_la_mas
lamias85020613_lamias
lampas106615953_lampas
lemmas10349163_lemmas
llamas888973lla_mas
magmas115512503_magmas
mahatmas1543863mahatmas
mamas95930773_ma_mas
mambas125716243_mambas
mamma86317913_mamma_
mammae94613213_mammae
mammal95112753_mammal
mammals10389273_mammals
miasmas1167743miasmas
mommas94110653_mommas
pampas124913993_pampas
plasmas113010753plasmas
rhamnus1233133rhamnus
rhumbas14305163rhumbas
sabras85116363s_abras
sagas66025883s_a_gas
saigas74114293s_aigas
salmis8514273s_almis
salpas85116923s_alpas
salsas65316133s_alsas
samaras9312913s_amaras
samba95618773s_amba_
sambal105215183s_ambal
sambals115213483s_ambals
sambar103914163s_ambar
sambars115113843s_ambars
sambos104315193s_ambos
sameks12409323s_ameks
samosa8510203s_amosa
samosas939293s_amosas
sampan102511893s_ampan
sampans112411003s_ampans
samps96124673s_a_mps
sangas75222653s_angas
saunas63915433s_aunas
scammed14479543scammed
scammer133611973scammer
scammers14339773scammers
scamps125014173sca_mps
scams94423973sca_m_s
schemas1468163schemas
seaman84015903sea_man
seamers94719433seamers
seams75731663sea_m_s
shackos16429023shackos
shacks154817563sha_cks
shaders115915553shaders
shades105924533sha_des
shadows1437193shadows
shads95124483sha__ds
shadufs1433673shadufs
shafts125411433sha_fts
shags95123863sha__gs
shahs115919513sha__hs
shairds11216263shairds
shairns10276783shairns
shaitan1036883shaitan
shaitans1136403shaitans
shakers144015563shakers
shakes135024593sha_kes
shakoes144510013shakoes
shakos134912183sha_kos
shales94731253sha_les
shaloms1288983shaloms
sham96436353sha_m__
shamble14149263shamble
shambles15159043shambles
shame105726703sha_m_e
shamed125120213sha_med
shamefast1742963shamefast
shaming133016743shaming
shammashim1951593shammashim
shammied16265543shammied
shamming16289413shamming
shammosim1552363shammosim
shamoy14379913sha_moy
shampoo1435373shampoo
shampoos1544603shampoos
shamuses1336153shamuses
shanks135315583sha_nks
shantis103313083shantis
shapers124016893shapers
shapes115124943sha_pes
shards104319173sha_rds
sharers104720623sharers
shares95236413sha_res
sharia93116723sharia_
shariah132210533shariah
shariahs14206393shariahs
sharifs13279903sharifs
sharks135019723sha_rks
sharns95516983sha_rns
sharps115516083sha_rps
shaughs14245283shaughs
shauls94913113sha_uls
shavers134115093shavers
shaves125224933sha_ves
shavies134213203shavies
shawls125411973sha_wls
shawm135316143shawm__
shaws116226263sha__ws
shays116021433sha__ys
shazam2046603sha_zam
sheas86331793sh__eas
sheilas1059403sheilas
sheltas10279663sheltas
sherpas1238093sherpas
shiksas1484643shiksas
shimmed15338583shimmed
shimmer143310873shimmer
shimmers15269413shimmers
shimmies15287803shimmies
shimmy16306413shimm_y
shims104422543sh_im_s
shipman14247123shipman
shivas124512413sh_ivas
shlumps1434143shlumps
shmear1176933sh_mear
shmears1277073sh_mears
shmoes114612093sh_moes
shopman14247253shopman
showman15257283showman
shrimps14516753shrimps
shwas116415103sh__was
sigmas94111353s_igmas
simas75727553s__imas
slammed123511103slammed
slammer113913033slammer
slammers123511223slammers
slams74927903sla_m_s
smarms105712533smarm_s
smegmas1233503smegmas
somas76030373s__omas
spammed14348523spammed
spammer133410433spammer
spammers14378693spammers
spams94922193spa_m_s
spasms10418973spasm_s
sradhas1176153sradhas
stadias8411113stadias
stamens93411483stamens
staminas1048853staminas
stammel11607533stammel
stammels12495563stammels
stammer116013343stammer
stammers123611523stammers
stamps105614023sta_mps
stanzas1636363stanzas
stemma10328133stemma_
stigmas10206633stigmas
stomas84816323s_tomas
strumas9419833strumas
summa94713313s_umma_
summae103911013s_ummae
swagman1334913swagman
swamies123712063swamies
swamis114212293swa_mis
swamps135910263swa_mps
swarms116112163swarm_s
tharms115712243tharm_s
traumas938583traumas
ulamas8910453ula_mas
wammus13426733_wammus
whammed18345133whammed
whammies18265503whammies
whammo16405193whamm_o
whammy19375293whamm_y
whams135515643wha_m_s
zamias174212923_zamias

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272886.69020033.9
3Display Results2882880.1062717.0
 (SQL Overall)1786912886.95225703.5
 
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.