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

120 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
blamer10441714(None) 
blader93618581blader
blame95625491blame_
blamed116017951blamed
blamers115314211blamers
blames105121861blames
blazer174414021blazer
flamer114919121flamer
lamer75233701_lamer
baker115629542b_aker
balder95318862balder
baler75635272b_aler
balker124519162balker
baller83825202baller
balmier113811512balmier
barer74535802b_arer
baser74828922b_aser
beader94623792beader
beaker125520692beaker
beamed115720732beamed
beamier113411942beamier
bearer85323912bearer
beater84729392beater
beaver114819252beaver
belayer12339502belayer
bilayer12347802bilayer
blabber10418922blabber
blacker154513512blacker
bladder11429152bladder
blade85923332blade_
bladed104717762bladed
bladers104214682bladers
blades95221252blades
blae66134642bla_e_
blam86131702blam__
blams95023852blam_s
blander103715162blander
blanker134612022blanker
blare75826232blare_
blared95018242blared
blares85021632blares
blase75524232blase_
blaster94017302blaster
blate75933782blate_
blather125314202blather
blatter94415652blatter
blawed124713892blawed
blaze165520832blaze_
blazed184314712blazed
blazers184811682blazers
blazes174817352blazes
bleaker133510532bleaker
bleater94515302bleater
blimey13468452blimey
bloater94013422bloater
bloomer11419812bloomer
blower115316572blower
bluer74918492bl_uer
blume95619892blume_
blumed114313642blumed
blumes105917792blumes
boater84622092boater
boomer104618512boomer
bracer104620582bracer
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
bummer124014102bummer
calmer105216932calmer
claimer11279882claimer
clamber133311742clamber
clammer134211792clammer
clamor1049452clamor
clamper134012992clamper
claver113816972claver
clawer114512782clawer
elater64724202elater
flaker134916172flaker
flame105124442flame_
flamed124618972flamed
flamen115215992flamen
flamers124616362flamers
flames114723692flames
flamier123112142flamier
flayer124713562flayer
foamer114714312foamer
framer114817442framer
gamer84928942_gamer
glamor958182glamor
glazer164212262glazer
gleamer10328512gleamer
lacer75833752_lacer
lader65633722_lader
lager65132862_lager
laker95432872_laker
lamber104418492_lamber
lame66849292_lame_
lamed85235292_lamed
lames75445542_lames
laser54633322_laser
later54843922_later
laver85031792_laver
laxer125420332_laxer
layer84626472_layer
namer75622102_namer
palmer105816542palmer
placer105117742placer
planer84122652planer
plater84427692plater
player115215212player
reamer84325212reamer
roamer84715162roamer
seamer84223612seamer
slaker104219272slaker
slammer113913032slammer
slater64429182slater
slaver94419612slaver
slayer93916332slayer
tamer75230102_tamer

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511202.20037523.2
3Display Results1201200.0502400.0
 (SQL Overall)1786911202.61068464.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.