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

112 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
blazer17441402(None) 
blader93618581blader
blamer104417141blamer
blaze165520831blaze_
blazed184314711blazed
blazers184811681blazers
blazes174817351blazes
brazer174917531brazer
glazer164212261glazer
ablaze17239832ablaze_
baker115629542b_aker
balder95318862balder
baler75635272b_aler
balker124519162balker
baller83825202baller
barer74535802b_arer
baser74828922b_aser
bazar163816002b_azar
beader94623792beader
beaker125520692beaker
bearer85323912bearer
beater84729392beater
beaver114819252beaver
beezer174010522beezer
belayer12339502belayer
bilayer12347802bilayer
blabber10418922blabber
blacker154513512blacker
bladder11429152bladder
blade85923332blade_
bladed104717762bladed
bladers104214682bladers
blades95221252blades
blae66134642bla_e_
blame95625492blame_
blamed116017952blamed
blamers115314212blamers
blames105121862blames
blander103715162blander
blanker134612022blanker
blare75826232blare_
blared95018242blared
blares85021632blares
blase75524232blase_
blaster94017302blaster
blate75933782blate_
blather125314202blather
blatter94415652blatter
blawed124713892blawed
blazered2035062blazered
blazon1736762blazon
blazoner1944132blazoner
bleaker133510532bleaker
bleater94515302bleater
blitzer18447662blitzer
bloater94013422bloater
blower115316572blower
bluer74918492bl_uer
boater84622092boater
bonzer175313672bonzer
boozer174815962boozer
bracer104620582bracer
braver114719042braver
brawer114216332brawer
brayer115315312brayer
braze165423452braze_
brazed184717082brazed
brazen174812452brazen
brazers184513942brazers
brazes175522192brazes
brazier183911472brazier
buzzer16379112buzzer
claver113816972claver
clawer114512782clawer
elater64724202elater
emblazer2144562emblazer
flaker134916172flaker
flamer114919122flamer
flayer124713562flayer
gazer155720072_gazer
glaze155418162glaze_
glazed174711772glazed
glazers174410042glazers
glazes165315642glazes
glazier17409352glazier
grazer164815762grazer
hazer174820232_hazer
lacer75833752_lacer
lader65633722_lader
lager65132862_lager
laker95432872_laker
lamer75233702_lamer
laser54633322_laser
later54843922_later
laver85031792_laver
laxer125420332_laxer
layer84626472_layer
lazar144113642_lazar
laze136235052_laze_
lazed154925842_lazed
lazes145129572_lazes
lazier154214612_lazier
mazer165722422_mazer
placer105117742placer
planer84122652planer
plater84427692plater
player115215212player
razer144824272_razer
slaker104219272slaker
slater64429182slater
slaver94419612slaver
slayer93916332slayer

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 Filter178691825510.220812231.8
2DLD Change Limit825511124.92016778.7
3Display Results1121120.0502240.0
 (SQL Overall)1786911125.19034429.9
 
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.