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

238 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
lambda114611(None) 
lambada1245641lambada
lambdas1246241lambdas
alameda1035492alameda
cambia124913152cambia
gamba106018512gamb_a
gambia115912252gambia
hamada1239922hamada
labia75219012la_bia
labra75415462la_bra
lama66635292lam__a
lamb86832142lamb__
lambadas1354872lambadas
lambed115614782lambed
lamber104418492lamber
lambie103213672lambie
lambs95921412lamb_s
lamby125114842lamb_y
lamed85235292lamed_
lamedh12476362lamedh
lameds94812032lameds
lamia75324322lam_ia
lamina84920442lamina
lampad114510032lampad
limba95414982limb_a
mamba116317522mamb_a
ramada9310182ramada
rambla103510932rambla
samba95618772samb_a
aba512850953_a_b_a
abba810522653_a_bba
alamedas1145443alamedas
alamode1038153alamode
alba68328333_alb_a
alma66333023alm__a
almud84012183almud_
almude9399933almude
almuds9378773almuds
ama510853303_am__a
amber94523213_amber
ambit94223713_ambit
amble95924643_amble
ambo88225143_amb_o
ambos95321253_ambos
ambry123512103_ambry
ameba9312383_ameba
amia66836903_am_ia
amid77036353_amid_
amide86128483_amide
amido85720983_amido
amids85627513_amids
amiga85514813_amiga
amnia75918643_amnia
armada938783armada
baba88828353ba_b_a
babka137812913ba_bka
balboa10389963balboa
bamboo12310013bamboo
banda85223103ba_nda
blamed116017953blamed_
camber124418483camber
cambial134010763cambial
camera10313693camera
camisa103114323camisa
clamber133311743clamber
cumbia12379893cumbia
dada66422443da__da
famed115928343famed_
flambe13489153flamb_e
flambeau1543323flambeau
flambee144210013flambee
flambes14419503flambes
flamed124618973flamed_
gama77035523gam__a
gamb96331843gamb__
gambade1336383gambade
gambado1344973gambado
gambas115817513gambas
gambe106219213gamb_e
gambes116318313gambes
gambias125010733gambias
gambir11509773gambir
gambit114714213gambit
gamble115417183gamble
gambol1138223gambol
gambs105721123gamb_s
gamed95126393gamed_
gamma106116103gam_ma
garda7316763ga_rda
hamadas1339673hamadas
hammada1545093hammada
hamza19139773ham_za
iamb86623733iamb__
iambi95512223iamb_i
iambic12468283iambic
iambs95815063iamb_s
iambus10468903iambus
jamb155523853jamb__
jambe165314753jamb_e
jambeau1843773jambeau
jambed184811403jambed
jambes175914053jambes
jambs166014623jamb_s
kamala12339963kamala
lab58864783la_b__
labara83712893labara
label75019383la_bel
labial84714343la_bial
labor75117313la_bor
labs67145123la_b_s
laced87132643laced_
lacuna8118123lacuna
lad48165703la__d_
lade56345983la__de
laded74232613laded_
lads56549133la__ds
lady86527153la__dy
laguna7127223laguna
laid56439143la_id_
laird65417793laird_
lairds74711613lairds
laked105731123laked_
lam57666713lam___
lamas75532793lam_as
lambast11129893lambast
lambdoid1443453lambdoid
lambent113711303lambent
lambers113817113lambers
lambert113617113lambert
lambier113611643lambier
lambies113015113lambies
lambing123412413lambing
lambkin1545243lambkin
lame66849293lam__e
lamedhs13444703lamedhs
lamella988613lamella
lamely114013223lamely
lament85024943lament
lamer75233703lam_er
lames75445543lam_es
lamest84722763lamest
lamiae84817453lamiae
lamias85020613lamias
laminae93512973laminae
laminal94113633laminal
laminar93810283laminar
laminas93615873laminas
laming94528363laming
lammed113915623lammed
lamp86233823lam__p
lampads12477623lampads
lampas106615953lampas
lamped114017543lamped
lamps95624833lam_ps
lams66552263lam__s
land56337313la_nd_
landau7310613la_ndau
lands65426903la_nds
lard56742003la_rd_
lards65331863la_rds
lardy96119273la_rdy
larva8312483la_rva
lased65132343lased_
lated65240673lated_
latina65621143latina
latria62313593latria
laud56527723la_ud_
lauds65618483la_uds
laura54116203la_ura
lava76725423la__va
laved95028593laved_
lawed96028323lawed_
layed95127383layed_
lazed154925843lazed_
lemma94811033lem_ma
libra74712423l_ibra
lima65734133lim__a
limb85429383limb__
limbas105313203limbas
limbed114513183limbed
limber104316793limber
limbi96513813limb_i
limbic12528743limbic
limbo95614813limb_o
limbos104712143limbos
limbs96118943limb_s
limbus105710383limbus
limby125714073limb_y
limed85426803limed_
limina83514503limina
limpa97014463lim_pa
llama799893llam__a
loamed94414613loamed_
luma65527523lum__a
lumbar103610593lumbar
lumber103817773lumber
lumina84613543lumina
mama86231593mam__a
mambas125716243mambas
mambo115215743mamb_o
mambos125414493mambos
mamma86317913mam_ma
nada58022903na__da
named85223063named_
pagoda10487873pagoda
pampa114913423pam_pa
panada94113053panada
panda85022613pa_nda
ramadas1039303ramadas
ramblas112710263ramblas
ramble104519973ramble
ramona8412413ramona
remuda936823remuda
rumba93612513rumb_a
sabra75317853sa_bra
samara8313853samara
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sambhar1444853sambhar
sambo95118013samb_o
sambos104315193sambos
sambuca1344343sambuca
sambur10469503sambur
samosa8510203samosa
tabla73318363ta_bla
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
tambur10358713tambur
tambura11326463tambura
tamed85528513tamed_
ulama7711473ulam__a
umbra948513_umbra
vanda94515923va_nda
wamble134415753wamble
wambly16388663wambly
zamia165115213zam_ia

Search took 6 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.1231452772.4
2DLD Change Limit1127162385.29621283.2
3Display Results2382380.0633777.8
 (SQL Overall)1786912385.48232596.0
 
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.