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

197 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
lambdas124624(None) 
lambadas1354871lambadas
lambda1146111lambda_
alamedas1145442alamedas
gambas115817512gamb_as
gambias125010732gambias
hamadas1339662hamadas
lamas75532792lam__as
lambada1245642lambada
lambast11129892lamb_ast
lambers113817102lambers
lambies113015112lambies
lambs95921412lamb__s
lamedhs13444702lamedhs
lameds94812032lamed_s
lamias85020612lam_ias
laminas93615872laminas
lampads12477622lampads
lampas106615952lam_pas
limbas105313202limb_as
mambas125716242mamb_as
ramadas1039302ramadas
ramblas112710262ramblas
sambas104219262samb_as
abas68642083_a_b_as
abbas95918643_a_bbas
alameda1035493alameda_
alamodes1148013alamodes
albas75925393_alb_as
almas76629773alm__as
almudes10418263almudes
almuds9378773almud_s
amas67746293_am__as
ambers104519573_ambers
ambits103713413_ambits
ambles105121863_ambles
ambos95321253_amb_os
amebas10311453_amebas
amias75831473_am_ias
amidase1036723_amidase
amides95722663_amides
amids85627513_amid_s
amigas95912163_amigas
armadas1038173armadas
babas96325733ba_b_as
babkas146010143ba_bkas
balboas113710073balboas
bamboos1348753bamboos
bandas95120543ba_ndas
camas96333523cam__as
cambers134017433cambers
cambia124913153cambia_
cambial134010763cambial
cameras11313343cameras
camisas113411923camisas
clambers144211283clambers
cumbias13338963cumbias
dadas75819863da__das
flambeau1543323flambeau
flambeaus1642883flambeaus
flambes14419503flamb_es
gamas85431353gam__as
gamba106018513gamb_a_
gambade1336383gambade
gambades1435863gambades
gambado1344973gambado
gambados1444143gambados
gambes116318313gamb_es
gambia115912243gambia_
gambirs12359083gambirs
gambits12399723gambits
gambles124016203gambles
gambols1238593gambols
gambs105721123gamb__s
gammas115714693gam_mas
hamada1239913hamada_
hammadas1644783hammadas
hamzas20119013ham_zas
iambics13425643iambics
iambs95815063iamb__s
iambus10468903iamb_us
jambeau1843773jambeau
jambes175914053jamb_es
jambs166014623jamb__s
kamalas13339123kamalas
labels84515683la_bels
labia75219013la_bia_
labial84714343la_bial
labials9299873la_bials
labors84016403la_bors
labra75415463la_bra_
labs67145123la_b__s
lacunas9138173lacunas
lades65141273la__des
lads56549133la__d_s
lagunas8156823lagunas
lairds74711613laird_s
lama66635293lam__a_
lamb86832143lamb___
lambaste12145013lamb_aste
lambasts12145623lambasts
lambdoid1443443lambdoid
lambed115614783lamb_ed
lambent113711303lambent
lamber104418493lamb_er
lambert113617113lambert
lamberts12348783lamberts
lambie103213673lamb_ie
lambier113611643lambier
lambiest122410183lambiest
lambing123412413lambing
lambkin1545243lambkin
lambkins1664983lambkins
lamby125114843lamb__y
lamed85235293lamed__
lamedh12476363lamed_h
lamellas1098153lamellas
laments94314853laments
lames75445543lam__es
lamia75324323lam_ia_
lamiae84817453lam_iae
lamina84920443lamina_
laminae93512973laminae
laminal94113633laminal
laminals10339303laminals
laminar93810283laminar
lampad114510033lam_pad
lampers113817333lampers
lamps95624833lam__ps
lams66552263lam___s
landau7310613la_ndau
landaus8310343la_ndaus
lands65426903la_nd_s
lapides103012043lapides
lards65331863la_rd_s
larvas9310233la_rvas
latinas74416463latinas
latrias71913213latrias
lauds65618483la_ud_s
lauras63414333la_uras
lavas85422223la__vas
lemmas10349163lem_mas
libras83711703l_ibras
limas75627633lim__as
limba95414983limb_a_
limbers113614743limbers
limbos104712143limb_os
limbs96118943limb__s
limbus105710383limb_us
limpas105513083lim_pas
llamas888973llam__as
lumas75622913lum__as
lumbar103610593lumb_ar
lumbars11289763lumbars
lumbers113815913lumbers
mamas95930773mam__as
mamba116317523mamb_a_
mamboes135011823mamboes
mambos125414493mamb_os
mammas94616403mam_mas
nadas66320813na__das
pagodas11367553pagodas
pampas124913993pam_pas
panadas103312213panadas
pandas95521963pa_ndas
ramada9310183ramada_
rambla103510933rambla_
rambles113118313rambles
ramonas9311093ramonas
remudas1035833remudas
rumbas102512013rumb_as
sabras85116363sa_bras
samaras9312913samaras
samba95618773samb_a_
sambal105215183samb_al
sambals115213483sambals
sambar103914163samb_ar
sambars115113843sambars
sambhar1444853sambhar
sambhars1544833sambhars
sambos104315193samb_os
sambucas1444163sambucas
samburs11369343samburs
samosas939293samosas
tablas83716163ta_blas
tambac122210243tamb_ac
tambacs13219363tambacs
tambak14249263tamb_ak
tambaks15218153tambaks
tambalas1237033tambalas
tamburas12316043tamburas
tamburs11288603tamburs
ulamas8910453ulam__as
umbras1038643_umbras
vandas103915993va_ndas
wambles143714023wambles
zamias174212923zam_ias

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.1531167915.0
2DLD Change Limit1340271977.67317467.4
3Display Results1971970.0633127.0
 (SQL Overall)1786911977.88922650.7
 
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.