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

106 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
smegmas123350(None) 
smegma1134111smegma_
magmas115512502_magmas
omegas936972omeg_as
sigmas94111362s_igmas
stemmas11256972stemmas
stigmas10206642stigmas
agmas85919873__agmas
amebas10311453ame_bas
amigas95912173amig_as
bemas96424283_be_mas
bregma1134963bregma_
caeomas1138403caeomas
degas75119163_deg_as
dermas94116813_dermas
dogmas105011243_dogmas
edemas9310503ede_mas
enemas8812003ene_mas
enigmas1045173enigmas
legman949653_legman
lemmas10349163_lemmas
magma104513573_magma_
mamas95930773_m_amas
mammas94616403_mammas
meccas1239493_meccas
medias93620783_medias
mega77620873_meg_a_
megass9219443_megass
megs75530633_meg__s
memes94927703_me_mes
memos95719113_me_mos
mems85931503_me_m_s
mensas85115863_mensas
merman10513863_merman
mesas76823203_me_sas
mommas94110653_mommas
myomas1338303_myomas
nemas75321573_ne_mas
omega836383omeg_a_
osteomas1045333osteomas
pneumas1145103pneumas
regma84612333_regma_
sagas66025883s_ag_as
saigas74114293saig_as
sangas75222653sang_as
scenas84114703sce_nas
schemas1468163schemas
seaman84015903s_eaman
seams75731663s_eam_s
seas45755273s_e__as
seedman1037373seedman
seems75525023s_eem_s
seggar8357813s_eggar
seggars9377783s_eggars
segnos73610443s_egnos
segos64919483s_eg_os
segs54933883s_eg__s
segues7412073s_egues
selvas93812913s_elvas
sememes11109203sememes
semes75731583s_e_mes
semimat11412913semimat
semis74623533s_e_mis
senegas837253seneg_as
sennas64214233s_ennas
sepias83616103s_epias
shamas113717943s_hamas
shammas14358723shammas
sheas86331793she__as
sheilas1059403sheilas
sheltas10279673sheltas
sherpas1238093sherpas
sieges73816833sieg_es
siennas736123siennas
sierras737863sierras
siestas738813siestas
sigma84513833s_igma_
simas75727553s__imas
skegs105011233skeg__s
skelms12368023skelm_s
smarms105712533smarm_s
smear74416393sme__ar
smears84714433sme_ars
smeeks12428433sme_eks
smells83914743sme_lls
smelts85412773sme_lts
smerks12449713sme_rks
smews104612293sme__ws
smogs85112163smog__s
somas76030373s__omas
sperms102512603sperm_s
steams84916903steam_s
stellas72813043stellas
stemma10328133stemma_
stems75219953ste_m_s
sterigmas1243563sterigmas
stigma9226763stigma_
stigmal10245923stigmal
stomas84816323s_tomas
strumas9419833strumas
summas104313163s_ummas
swagman1334913swagman
syngas10368913syng_as
teguas768013_teguas
ulemas888963ule_mas
zeugmas1942543zeugmas

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 Limit1340271066.75019855.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.20224811.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.