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

461 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
lemmas1034916(None) 
lemma94811031lemma_
bemas96424282be_mas
commas124814572commas
dermas94116812dermas
dilemmas1343122dilemmas
emmys12446022_emmys
femmes135410212femmes
gammas115714692gammas
gemma106311772gemma_
gemmae11507792gemmae
gummas114810512gummas
lamas75532792l_amas
lamias85020612lamias
lampas106615952lampas
leas45954182le__as
legman949652legman
lehuas935942lehuas
leman75622602le_man
lemans85316392lemans
lemmata1144672lemmata
lemons84415052lemons
lemurs837252lemurs
limas75627632l_imas
limbas105313192limbas
limpas105513082limpas
llamas888972llamas
loumas84812332loumas
lumas75622912l_umas
mammas94616402mammas
mommas94110652mommas
nemas75321572ne_mas
stemmas11256972stemmas
summas104313162summas
ulemas888962ule_mas
abomas101113583abomas
agamas97413443agamas
agmas85919873_agmas
alexias14249793alexias
almas76629773_almas
almemar1144303almemar
almemars1243523almemars
amas67746293__amas
amebas10311453amebas
amias75831463_amias
ammos94815823_ammos
analemmas13103583analemmas
anemias92512143anemias
animas84418723animas
aromas81018613aromas
atmas75721013_atmas
beams95328173beam_s
belgas9311713belgas
bema85825253be_ma_
bemean10410683bemean
bemeans1148733bemeans
bemoan10310253bemoan
bemoans1138253bemoans
bermes106023003bermes
berms95323663berm_s
betas75528763be_tas
bettas84913923bettas
bimas95521743_bimas
caeomas1138393caeomas
camas96333523_camas
ceibas1038503ceibas
centas85020703centas
cerias83321973cerias
cestas85018543cestas
cleomes1138813cleomes
comas95833003_comas
comma114514793comma_
compas125817063compas
cymas126417883_cymas
dammar11438903dammar
dammars12308193dammars
deems85421773deem_s
degas75119163de_gas
deltas74414823deltas
demast9517063de_mast
demean9510563demean
demeans1039713demeans
demes86032693de_mes
demies94825803demies
demits94918073demits
demobs11429483demobs
demons94917723demons
demos86022993de_mos
demurs939773demurs
derma84918513derma_
dermal93614343dermal
dermis94717163dermis
derms85022893derm_s
desman9311693desman
desmans1039003desmans
devas96218883de_vas
dilemma1243063dilemma_
dogmas105011243dogmas
dolmas95213043dolmas
doumas95314813doumas
dramas95814653dramas
dumas85420433_dumas
edemas9310503edemas
elemis8312383elemis
elms67322703_elm_s
embar94011593_embar
embars103812873_embars
embay123410593_embay
embays131408323_embays
emdash12244113_emdash
emes65434663_e_mes
emeus76913333_emeus
emirs76116153_emirs
emits75421463_emits
emmer94314463_emmer
emmers104013223_emmers
emmet94221383_emmet
emmets10349153_emmets
emmy116013243_emm_y
ems56435493_e_m_s
emus66821683_e_mus
emyds1144923_emyds
enemas8812003enemas
ephas10311543_ephas
eras45441503_e_ras
etas46432273_e_tas
etnas54713933_etnas
exams14199083_exams
eyas76427433_e_yas
eyras84715923_eyras
fellas95116963fellas
femes105626223fe_mes
femme125011433femm_e
fems96428703fe_m_s
femurs1136713femurs
ferias95020393ferias
fermis114313503fermis
fetas85624403fe_tas
fleams115011943fleam_s
fleas86423663fle__as
gamas85431353_gamas
gambas115817513gambas
gamma106116103gamma_
gemmate12418383gemmate
gemmates13307673gemmates
gemmed12329573gemmed
gemmy135211053gemm_y
gemots93712153gemots
gems75329113ge_m_s
genoas74013623genoas
german9611983german
germans1079463germans
germs85118873germ_s
getas65421483ge_tas
geums85414113geum_s
gimmal11247513gimmal
gimmals12225823gimmals
gimmes113010903gimmes
gleams94812253gleam_s
gleeman1035363gleeman
gliomas1035333gliomas
gramas94317203gramas
grammas12499773grammas
gumma105313103gumma_
halmas117017893halmas
hammal134512063hammal
hammals14409213hammals
hammam12419333hammam
hammams13386433hammams
hamzas20119013hamzas
helms105619463helm_s
hemal104419803he_mal
hemes105031083he_mes
hemins113417563hemins
hemmed144211463hemmed
hemmer134112643hemmer
hemmers143310843hemmers
hemps126917333he_mps
hems95534943he_m_s
hennas94211803hennas
herma105318883herma_
hermae115314473hermae
hermai118912843hermai
herms105626433herm_s
hetman112510603hetman
hetmans12187593hetmans
hommos13128503hommos
hummus1336243hummus
imams91511103_imams
jemmies18318333jemmies
jemmy19498553jemm_y
karmas123013733karmas
keas86337093ke__as
kemps135012523ke_mps
kermes124616123kermes
kermis124012393kermis
kormas124511233kormas
lama66635293l_ama_
lambast11129893lambast
lambdas1246243lambdas
lambs95921413l_ambs
lameds94812033lameds
lames75445543l_ames
lamia75324323lamia_
lamiae84817453lamiae
laminas93615873laminas
lammed113915623lammed
lampad114510033lampad
lampads12477623lampads
lamps95624833l_amps
lams66552263l_am_s
larvas9310233larvas
las37281473l___as
lauras63414333lauras
lavas85422223l_avas
lawman11289053lawman
layman113511303layman
lea37660183le__a_
lead56038853le__ad
leadman10237843leadman
leads66028493le_ads
leaf76441033le__af
leafs85721183le_afs
leak86233713le__ak
leaks95923913le_aks
leal46043273le__al
lean46345243le__an
leans55536253le_ans
leap66032683le__ap
leaps75522933le_aps
lear47045953le__ar
learns65513743learns
lears55938733le_ars
lease55230263le__ase
leases65428113leases
leash85519213le__ash
least56134883le__ast
leasts64616413leasts
leaves94222383leaves
lebens8310093lebens
leches115421313leches
ledges84917983ledges
leeks95318893le_eks
leers54828983le_ers
lees45455883le__es
leets54927123le_ets
leeway1255883leeway
leeways1354453leeways
lefts86517813le_fts
legal65715943le_gal
legals73412733legals
legers74518313legers
leges64427283le_ges
legits71313003legits
legmen939343legmen
legs56133693le__gs
legumes1036633legumes
lehrs86111133le_hrs
lehua837953lehua_
leis45739603le__is
leks85427603le__ks
lekvar1333043lekvar
lekvars1432693lekvars
lemming12269393lemming
lemmings13254723lemmings
lemon75618183le_mon
lemony11419553lemony
lempiras1243853lempiras
lemur739773le_mur
lemures938793lemures
lends65326253le_nds
lenes54738523le_nes
lenis56326863le_nis
lenos56024863le_nos
lens46146493le__ns
lenses64620893lenses
lensman937563lensman
lentos65317403lentos
leones64417723leones
lepers84817323lepers
lepta75714393lepta_
les35663073le___s
lesbos837403lesbos
leses54930813le_ses
less45635103le__ss
lethal939803lethal
lethals1038113lethals
lethes94818083lethes
lets47147943le__ts
letups8317683letups
leucomas1244453leucomas
leudes75314093leudes
leuds66214813le_uds
leukomas1443483leukomas
leva77020713le_va_
levees93714523levees
levels94113283levels
levers94621323levers
levies93919863levies
levins94514653levins
levis85818553le_vis
lewis85315843le_wis
lexemes1635673lexemes
lexes127225263le_xes
lexis125916033le_xis
leys76430183le__ys
lezzes14387833lezzes
lianas63713383lianas
libras83711703libras
lima65734133l_ima_
liman75921603l_iman
limans84816303limans
limba95414973limba_
limbos104712133limbos
limbs96118933l_imbs
limbus105710373limbus
limens84618033limens
limes75636503l_imes
limeys11429273limeys
limits82514133limits
limmer104314793limmer
limmers113413083limmers
limns75718393l_imns
limos75320813l_imos
limpa97014463limpa_
limps95522673l_imps
lingas75116563lingas
lipomas1156443lipomas
liras56021983l_iras
litas54923773l_itas
litmus836323litmus
llama799893llama_
loams75619863loam_s
loofas9429833loofas
looms75124643loom_s
lotas55926303l_otas
louma76213633louma_
luffas12337483luffas
luma65527523l_uma_
lumbar103610593lumbar
lumbars11289763lumbars
lumens85013973lumens
lummox1733053lummox
lumps95624983l_umps
lums65734243l_um_s
lunas55025013l_unas
lycras11287243lycras
lymphs1635053lymphs
lyssas935443lyssas
lyttas985073lyttas
magmas115512503magmas
mamas95930773_mamas
mambas125716243mambas
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammals10389273mammals
mas58175813___mas
meccas1239493meccas
medias93620783medias
memes94927703me_mes
memos95719113me_mos
mems85931503me_m_s
mensas85115853mensas
merman10513853merman
mesas76823203me_sas
moas65545343__moas
momma85111053momma_
mumms85513153mumm_s
myomas1338293myomas
neems77316293neem_s
nema65522523ne_ma_
neumes83112623neumes
neums75414253neum_s
nomas74726413_nomas
oedemas1056693oedemas
oleums8358783oleum_s
omegas936973omegas
pampas124913993pampas
peas65755063pe__as
penman10312323penman
perms95524513perm_s
pimas94725103_pimas
plasmas113010753plasmas
pleas75627033ple__as
pleuras937413pleuras
pneumas1145103pneumas
primas104418103primas
pumas95121563_pumas
pyemias1436803pyemias
reams75729623ream_s
reatas64021013reatas
redias74523603redias
regma84612333regma_
reman75730153re_man
remans84823003remans
remap95418103re_map
remaps105012873remaps
remiss84216353remiss
remits85622943remits
remoras9314073remoras
rems66237723re_m_s
remudas1035833remudas
rumbas102512013rumbas
sambas104219263sambas
seaman84015903seaman
seams75731663seam_s
seas45755273se__as
seems75525023seem_s
selvas93812913selvas
sememes11109203sememes
semens84616963semens
semes75731583se_mes
semimat11412903semimat
semis74623533se_mis
sennas64214233sennas
sepias83616103sepias
shamas113717933shamas
shammas14358713shammas
sigmas94111353sigmas
simas75727553_simas
smegmas1233503smegmas
somas76030373_somas
stemma10328133stemma_
stomas84816323stomas
summa94713313summa_
summae103911013summae
teams75726513team_s
teas45851493te__as
teems76019783teem_s
teguas768013teguas
tempos103812293tempos
temps95417133te_mps
tempts10439453tempts
tenias64720073tenias
tepas76521683te_pas
terms75523473term_s
terras63516953terras
teslas64212173teslas
tetras63017613tetras
texas126514933te_xas
ulamas8910453ulamas
ulema7109713ule_ma_
ultimas936363ultimas
uremias9249503uremias
veenas91410413veenas
vermes115019143vermes
vermis114214963vermis
vestas95916683vestas
wammus13426733wammus
wekas123911793we_kas
xenias133712973xenias
yeas78638423ye__as
yentas94614213yentas
yeoman1138823yeoman
yerbas11119293yerbas
ylems1039263yle_m_s
zamias174212923zamias
zebras1737853zebras
zetas145018163ze_tas
zeugmas1942543zeugmas

Search took 9 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164617.54614937.2
3Display Results4614610.2831629.0
 (SQL Overall)1786914617.96922423.3
 
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.