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

181 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
lambast1112989(None) 
lambaste12145011lambaste
lambasts12145621lambasts
bombast1348222bombast
cambist13312112cambist
gambas115817512gambas_
lamas75532792lam_as_
lambada1245642lambada
lambasted14103252lambasted
lambastes13114692lambastes
lambdas1246242lambdas_
lambent113711302lambent
lambert113617112lambert
lambiest122410182lambiest
lambs95921412lamb_s_
lamest84722762lam_est
lamias85020612lamias_
lampas106615952lampas_
limbas105313202limbas_
mambas125716242mambas_
sambas104219262sambas_
abaft10318063_a_baft
abas68642083_a_bas_
abase76023483_a_base
abash106016513_a_bash
abbas95918643_abbas_
aghast105711373_aghast
albas75925393_albas_
almas76629773alm_as_
almost81014433alm_ost
amas67746293_am_as_
amass77119683_am_ass
ambage11510603_ambage
ambari103012173_ambari
ambary134010543_ambary
ambit94223713_amb_it
ambits103713413_ambits
ambos95321253_ambos_
ambush1336113_ambush
amebas10311453_amebas_
amias75831473_amias_
amidst94913233_amidst
avast85519363_a_vast
babas96325733ba_bas_
ballast9313993ballast
bast66362413___bast
bombasts1444953bombasts
camas96333523cam_as_
camass104114183cam_ass
cambism1538033cambism
cambists1437023cambists
clamant11312433clam_ant
clambake1843893clambake
combat12316753comba_t
combats13311683combats
combust1338363combust
damask1335843dam_ask
dampest12411043dampest
demast9517063dem_ast
dumbest1238743dumbest
fabbest1438033fabbest
fantast10311703fantast
flambes14419503flambes_
flamiest133111973flamiest
gabbart1248883gabbart
gamas85431363gam_as_
gamba106018513gamba__
gambade1336383gambade
gambado1344973gambado
gambes116318313gambes_
gambias125010733gambias_
gambit114714213gamb_it
gambits12399723gambits
gambs105721123gamb_s_
gamest94919933gam_est
gamiest102816233gamiest
gammas115714693gammas_
gymnast1344163gymnast
hamzas20119013hamzas_
iambs95815063iamb_s_
iambus10468903iambus_
jambes175914053jambes_
jambs166014623jamb_s_
labara83712893la_bara
labret8320223la_bret
labs67145123la_b_s_
laciest93819033laciest
lactase937953lactase
lakiest113517263lakiest
lama66635293lam_a__
lamb86832143lamb___
lambadas1354873lambadas
lambasting1543343lambasting
lambda1146113lamb_da
lambed115614783lamb_ed
lamber104418493lamb_er
lambers113817113lambers
lamberts12348793lamberts
lambie103213673lamb_ie
lambier113611643lambier
lambies113015113lambies
lambing123412413lambing
lambkin1545243lambkin
lamby125114843lamb__y
lameds94812033lameds_
lament85024943lam_ent
laments94314853laments
lames75445543lam_es_
lamia75324323lamia__
lamiae84817453lamia_e
laminas93615873laminas_
lampad114510033lampa_d
lampads12477623lampads
lampases1267293lampases
lamppost1443513lamppost
lamps95624833lam_ps_
lams66552263lam__s_
lankest112714113lankest
largest83715103largest
lariat6629043laria_t
lariats7615053lariats
larvas9310233larvas_
last46260323l___ast
latest63822703la_test
lauras63414333lauras_
lavas85422223la_vas_
lavash12597373la_vash
laxest134913363la_xest
laziest163814473laziest
least56134883l__east
lemmas10349163lemmas_
limas75627633lim_as_
limba95414983limba__
limbate1139213limbate
limbiest12258893limbiest
limbos104712143limbos_
limbs96118943limb_s_
limbus105710383limbus_
limiest93716103limiest
limpas105513083limpas_
limpest113712313limpest
llamas888973llam_as_
loamiest102310203loamiest
lumas75622913lum_as_
lumbago1243833lumbago
lumbar103610593lumba_r
lumbars11289763lumbars
mamas95930773mam_as_
mamba116317523mamba__
mambos125414493mambos_
mammas94616403mammas_
mast65959963__m_ast
numbat10312083numba_t
numbats1137673numbats
numbest1138793numbest
pampas124913993pampas_
rabat72832223ra_ba_t
rabats83116223ra_bats
ramblas112710263ramblas_
rampant11312173rampant
rampart11311993rampart
rumbas102512013rumbas_
sabbat10314713sabba_t
sabbats1138633sabbats
samba95618773samba__
sambaed1238303sambaed
sambal105215183samba_l
sambals115213483sambals
sambar103914163samba_r
sambars115113843sambars
sambos104315193sambos_
tambac122210243tamba_c
tambacs13219363tambacs
tambak14249263tamba_k
tambaks15218153tambaks
tambala1138023tambala
tamest85721293tam_est
ulamas8910453ulam_as_
wombat1339863womba_t
wombats1435893wombats
zamias174212923zamias_

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.423422437.4
2DLD Change Limit1340271816.78019768.0
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.26624592.8
 
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.