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 “blams” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

240 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
blams9502385(None) 
balms95723921balms
bams87044451b_ams
beams95328171beams
blabs95619631blabs
blahs105616511blahs
blam86131701blam_
blame95625491blame
blames105121861blames
blats75132501blats
blaws105620461blaws
clams95127671clams
flams105125011flams
glams85822931glams
lams66552261_lams
slams74927901slams
alamo7418142alamo
alamos8415002alamos
alans55636172alans
alarms85913052alarms
alas46358122ala_s
almas76629772almas
alms65834922al_ms
alums75720602alums
baals76122702baals
baas66844672b_aas
bads77048862b_ads
bags76645502b_ags
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balm85534202balm_
balmy125217472balmy
bals66354042b_als
balsams11579012balsams
bam78560142b_am_
bans66555132b_ans
baps86040842b_aps
barms96128462barms
bars66564092b_ars
bas58681752b_a_s
bass66146782b_ass
bats66962332b_ats
bays97143912b_ays
beads85429502beads
beaks115326622beaks
beam86939232beam_
beamy126218572beamy
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
bedlams1237052bedlams
belays114313852belays
beldams1237052beldams
bemas96424282bemas
berms95323662berms
bias64738162bia_s
bimas95521742bimas
blab86629132bla_b
black134719072black
blacks144914952blacks
blade85923332blade
blades95221252blades
blae66134642bla_e
blaff135216482blaff
blaffs14426622blaffs
blah98625062bla_h
blain75421792blain
blains84516372blains
blamed116017952blamed
blamer104417142blamer
blamers115314212blamers
bland85320452bland
blank115418552blank
blanks124112892blanks
blare75826232blare
blares85021632blares
blase75524232blase
blast76532572blast
blasts85116772blasts
blat66550952bla_t
blate75933782blate
blaw97026722bla_w
blawn106813702blawn
blaze165520832blaze
blazes174817352blazes
bleaks125112432bleaks
blears85116452blears
bleats85518612bleats
blebs96416152blebs
bless75917812bless
blets75324942blets
blimp115612942blimp
blimps12588152blimps
blimy125212822blimy
blips95615782blips
bliss75616912bliss
bloats85215762bloats
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blooms104613172blooms
blots75626172blots
blows105423832blows
blubs95818152blubs
blues75127042blues
blume95619892blume
blumes105917792blumes
blurs74619082blurs
boars75229602boars
boas66150832boa_s
boats75635152boats
bolas74733762bola_s
booms95427122booms
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breams104815042breams
brims94721622brims
bums85934592b_ums
bylaws14415832bylaws
calms95222352calms
cams87047282_cams
chams126028502chams
clads85722732clads
clags85621122clags
claims105211572claims
clam86332292clam_
clamp115517652clamp
clamps124515082clamps
clans75031012clans
claps95626182claps
class75525482class
claws106020832claws
clays105521332clays
crams96229152crams
dams77444372_dams
drams86025832drams
elans55527752elans
elms67322702el_ms
exams14199082exams
flabs105818642flabs
flags95321282flags
flam96333292flam_
flame105124442flame
flames114723692flames
flamy135217472flamy
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flays116321052flays
fleams115011942fleams
foams105017952foams
gams76648882_gams
glads75620612glads
glam76529342glam_
glans65125832glans
glass65518132glass
gleams94812252gleams
glims87417672glims
gloams95210662gloams
gloms85219782gloms
glums84621422glums
grams85327312grams
halms105225212halms
hams96446132_hams
imams91511112imams
jams135231072_jams
kalams12310602kalams
labs67145122_labs
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lam57666712_lam_
lama66635292_lama
lamas75532792_lamas
lamb86832142_lamb
lambs95921412_lambs
lame66849292_lame
lames75445542_lames
lamp86233822_lamp
lamps95624832_lamps
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
lats45962702_lats
lavs76734152_lavs
laws76441682_laws
lays76043252_lays
llama799892llama
llamas888972llamas
loams75619862loams
lums65734242_lums
malms95021552malms
ogams84112682ogams
palms94921752palms
pams85641762_pams
plans75731272plans
plasm94114632plasm
plasms103711332plasms
plats75531372plats
plays106320772plays
plums94619952plums
prams96125512prams
rams65950772_rams
reams75729622reams
roams74919612roams
scams94423972scams
seams75731662seams
shams105829412shams
slabs75322642slabs
slags66525902slags
slam67737972slam_
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slims75423652slims
slums74623432slums
spams94922192spams
tams67247932_tams
teams75726512teams
trams75327672trams
ulama7711472ulama
ulamas8910452ulamas
ulans54921302ulans
whams135515642whams
yams95330732_yams
ylems1039262ylems

Search took 2 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 Filter178691538000.0802233637.5
2DLD Change Limit538002401.76330516.2
3Display Results2402400.1102181.8
 (SQL Overall)1786912401.95391495.6
 
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.