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

230 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
balsams1157901(None) 
balsam105612231balsam_
balsas86417521balsa_s
balas76937212bal_a_s
balases93815432balases
ballads104212912ballads
balms95723922bal__ms
balsa77920412balsa__
balsamed1344542balsamed
balsamic1463802balsamic
bantams1149062bantams
beldams1237052beldams
blams95023852b_l_ams
kalams12310602kal_ams
salaams997702salaams
salsas65316132salsa_s
abysms13565653abys_ms
alamo7418143_al_amo
alamos8415003_al_amos
alans55636173_al_ans
alarms85913053_alarms
alas46358123_al_a_s
albas75925393_alba_s
albums10198273_albums
alfas87219043_alfa_s
algas65624933_alga_s
algums9208043_algums
alias55834603_alia_s
allays94313743_allays
almahs118611613_almahs
almas76629773_alma_s
alms65834923_al__ms
altars64518153_altars
alums75720603_al_ums
always12409133_always
amalgams1343203amalgams
assais6711963_assais
assays977903_assays
baalisms1238033baalisms
baals76122703ba__als
baas66844673ba__a_s
baases85218013baas_es
baaskaps1641953baaskaps
babas96325733ba_ba_s
babkas146010143babka_s
backsaws1946803backsaws
badass949293ba_dass
bagass938933ba_gass
bailsman1245003bailsman
baizas173810823baiza_s
balata8614673bal_ata
balatas9311833balatas
balboas113710073balboas
baldies105317703baldies
balds85524643bal__ds
baleens938473baleens
balers85626933bal_ers
bales76250083bal__es
balisaur1043263balisaur
balisaurs1143093balisaurs
balkers134915723balkers
balks114926293bal__ks
ballad94315323balla_d
ballade104012563ballade
ballades114211643ballades
ballast9313993ballast
ballasts1037933ballasts
ballers94421013ballers
ballets93719513ballets
ballgame1343653ballgame
ballgames1443573ballgames
ballies93725743ballies
ballons93916963ballons
ballots94116033ballots
balls76236413bal__ls
balm85534203bal__m_
balmy125217473bal__my
bals66354043bal___s
balsaming1445123balsaming
bams87044453b___ams
bandas95120543banda_s
bandsaws1444623bandsaws
banians9312033banians
bantam10314063bantam_
banyans1237913banyans
banzais1837163banzais
baobabs1044443baobabs
barcas101016603barca_s
bariums1139143bariums
barms96128463ba__rms
basal75722283ba_sa_l
basalt83519583ba_salt
basalts9358963ba_salts
bases75644353ba_s_es
bashaws15347713bashaws
bashes115631393ba_shes
basics104915123ba_sics
basils85717473ba_sils
basins85722763ba_sins
basis75429863ba_s_is
basks115621763ba_s_ks
bass66146783ba_s__s
basses85428303ba_sses
bassets96414823bassets
bassos85313703ba_ssos
bastes85330383ba_stes
basts75936933ba_s_ts
batsman1157993batsman
bayamo1335603ba_yamo
bayamos1434663ba_yamos
bazaars18275883bazaars
bazars174613113ba_zars
bazooms20285383bazooms
beams95328173b__eams
bedlams1237053bedlams
belays114313853bel_ays
beldam11410113beldam_
beldame1237233beldame
beldames1336803beldames
beleaps1138053beleaps
belgas9311713belga_s
besoms105712733b_esoms
blabs95619633b_l_abs
blahs105616513b_l_ahs
blam86131703b_l_am_
blame95625493b_l_ame
blames105121863b_l_ames
blasts85116773blas_ts
blats75132503b_l_ats
blaws105620463b_l_aws
bleaks125112433b_leaks
blears85116453b_lears
bleats85518613b_leats
bloats85215763b_loats
blooms104613173b_looms
bolas74733763bol_a_s
bolases93315003bolases
bolsons969483bolsons
bosoms104913053b_osoms
breams104815043b_reams
bursars94510893bursars
bursas85318273bursa_s
bylaws14415833byl_aws
caesars9410733caesars
calami10313423cal_ami
calamus1139243cal_amus
calcars11312653calcars
calesas9411833calesa_s
callans94518473callans
callas84526753calla_s
calms95222353cal__ms
calpacs133110343calpacs
casas75327843ca_sa_s
causals91411183causals
clams95127673_cl_ams
dalasis8810533dalasis
fallals103310193fallals
falsies103515013falsies
flams105125013_fl_ams
fleams115011943_fleams
fulhams1543983fulhams
fullams1236553fullams
galahs105512673gal_ahs
galas65731643gal_a_s
galeas74618513galea_s
galyacs1335273galyacs
galyaks1534623galyaks
glams85822933_gl_ams
gleams94812253_gleams
gloams95210663_gloams
halals95018313hal_als
hallahs133912463hallahs
halmas117017893halma_s
halms105225213hal__ms
halvahs16417533halvahs
halvas124714173halva_s
hammams13386443hammams
hansas94616043hansa_s
hansoms12238523hansoms
jalaps15299183jal_aps
jetsams16124103jetsams
kalam11315113kal_am_
kalians11310183kalians
kaliums1336603kaliums
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
lactams1136953lactams
lallans74113533lallans
lams66552263__l_ams
loams75619863__loams
madams11310943ma_dams
malars85020683mal_ars
malms95021553mal__ms
marrams11310123marrams
masas75630413ma_sa_s
massas85116463massa_s
matsahs1236563matsahs
nalas55528363nal_a_s
nasals63312463na_sals
naysays1344123naysays
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
palais8420423pal_ais
palms94921753pal__ms
palsies94420273palsies
plasmas113010753plasmas
plasms103711333plas_ms
pulsars9358913pulsars
ransoms92410163ransoms
salaam8711013salaam_
salads75316963sal_ads
salals65120083sal_als
salami8313103sal_ami
salamis9313513sal_amis
salpas85116923salpa_s
salsa56718923salsa__
sansars73313913sansars
sarsars73512143sarsars
slams74927903_sl_ams
talars66021683tal_ars
talas55935893tal_a_s
talcums1135513talcums
tarsals72512603tarsals
valses94514613vals_es
vassals1057953vassals
wallahs13409473wallahs
wallas95719393walla_s
warsaws1335763warsaws

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 Limit1340272306.79619721.5
3Display Results2302300.0802875.0
 (SQL Overall)1786912307.29924481.6
 
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.