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

188 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
stemmas1125697(None) 
stemma10328131stemma_
lemmas10349162_lemmas
osteomas1045332osteomas
shammas14358722shammas
smegmas1233502smegmas
steams84916902steam_s
stellas72813042stellas
stemmata1244212stemmata
stemmed12278152stemmed
stemmer113210182stemmer
stemmers12378442stemmers
stemmy13417032stemm_y
stems75219952ste_m_s
stigmas10206642stigmas
stomas84816322st_omas
strumas9419832strumas
summas104313162s_ummas
anemias92512143anemias
asterias8317013asterias
asthmas12117363ast_hmas
atemoyas1342853atemoyas
atmas75721013at__mas
bemas96424283_be_mas
caeomas1138403caeomas
commas124814573_commas
dermas94116813_dermas
dilemmas1343123dilemmas
edemas9310503ede_mas
emmys12446023__emmys
enemas8812003ene_mas
esteems935243esteem_s
femmes135410213_femmes
gammas115714693_gammas
gemma106311773_gemma_
gemmae11507793_gemmae
grammas12499773grammas
gummas114810513_gummas
items7499613ite_m_s
lemma94811033_lemma_
mammas94616403_mammas
mommas94110653_mommas
nemas75321573_ne_mas
osteoma945433osteoma_
pneumas1145103pneumas
pyemias1436803pyemias
sambas104219263s_ambas
satsumas1043573satsumas
scenas84114703sce_nas
schemas1468163schemas
seaman84015903s_eaman
seams75731663s_eam_s
seas45755273s_e__as
seedman1037373seedman
seemers93814333seemers
seems75525023s_eem_s
selvas93812913s_elvas
sememes11109203s_ememes
semens84616973s_emens
semes75731583s_e_mes
semimat11412913s_emimat
semis74623533s_e_mis
sennas64214233s_ennas
sepias83616103s_epias
shamas113717943s_hamas
shammash18293753shammash
shammes144312833shammes
shammos14307203shammos
sheas86331793she__as
sheilas1059403sheilas
sheltas10279673sheltas
sherpas1238093sherpas
siemens938413siemens
siennas736123siennas
sierras737863sierras
siestas738813siestas
sigmas94111363s_igmas
simas75727553s__imas
skelms12368023skelm_s
smegma1134113smegma_
somas76030373s__omas
sperms102512603sperm_s
stadias8411113stadias
stamens93411483stamens
staminas1048853staminas
stammel11607533stammel
stammels12495563stammels
stammer116013343stammer
stammers123611523stammers
stamps105614023st_amps
stanzas1636363stanzas
stead65520273ste__ad
steads74116223ste_ads
steak95219803ste__ak
steaks104415853ste_aks
steal56125473ste__al
steals64020063ste_als
steam76322933ste__am
steamed103712143steamed
steamer93313093steamer
steamers103410873steamers
steamy115112373steam_y
stedfast1243643stedfast
steeds73814883ste_eds
steeks103613703ste_eks
steels64117983ste_els
steeps85215193ste_eps
steers63820983ste_ers
steeves103410903steeves
steins64818343ste_ins
stela54019043ste_la_
stelae63716483ste_lae
stelai63912563ste_lai
stelar64013863ste_lar
steles63725663ste_les
stella63612973stella_
stellar72610433stellar
stem610628253ste_m__
stemless1036653stemless
stemmatic1546013stemmatic
stemmery15334693stemmery
stemmier1245253stemmier
stemmiest1335143stemmiest
stemming13408203stemming
stemson945163stemson
stemsons1045003stemsons
stemware1344883stemware
stemwares1444523stemwares
stengah1144563stengah
stengahs1243393stengahs
stenos63915773ste_nos
stents65019453ste_nts
steppes113110693steppes
steps76619883ste__ps
stereos74314973stereos
steres63929533ste_res
sterigmas1243563sterigmas
sterna63712763sterna_
sternal73411913sternal
sterns64616763ste_rns
sterols7313443sterols
stets55423913ste__ts
stewpan1234193stewpan
stewpans1343713stewpans
stews85519143ste__ws
sthenias1178163sthenias
stigma9226763stigma_
stigmal10245923stigmal
stimes85920573st_imes
stimies9316563stimies
stoas55126023st__oas
stoma75918273st_oma_
stomal85213313st_omal
stomps105612833st_omps
storms85814633storm_s
stramash1344573stramash
stratas73013583stratas
streams94713373stream_s
strettas846423strettas
stroma84313073stroma_
stromal93010593stromal
struma84313273struma_
strumae9368093strumae
strums84716453strum_s
stummed12348553stummed
stumps104912283st_umps
stums75320083st_um_s
stupas83910883st_upas
stymies1239213stymies
summa94713313s_umma_
summae103911013s_ummae
teams75726513_team_s
teas45851493_te__as
teems76019783_teem_s
teguas768013_teguas
tempos103812293_tempos
temps95417133_te_mps
tempts10439453_tempts
tenias64720073_tenias
tepas76521683_te_pas
terms75523473_term_s
terras63516973_terras
teslas64212173_teslas
tetras63017623_tetras
texas126514933_te_xas
tsimmes1133673tsimmes
ulemas888963ule_mas
uremias9249503uremias

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.416429545.7
2DLD Change Limit1340271887.10018877.0
3Display Results1881880.0702685.7
 (SQL Overall)1786911887.58623555.4
 
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.