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

148 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
blader9361858(None) 
balder95318861balder
beader94623791beader
bladder11429151bladder
blade85923331blade_
bladed104717761bladed
bladers104214681bladers
blades95221251blades
blamer104417141blamer
blander103715161blander
blazer174414021blazer
lader65633721_lader
abrader1038642abrader
alder65421912al_der
badder103817512badder
bade75140882b_ade_
badger105415072b_adger
baker115629542b_aker
balded105417512balded
baler75635272b_aler
balker124519162balker
baller83825202baller
bander93928222bander
barer74535802b_arer
baser74828922b_aser
beaded104922422beaded
beaders104120182beaders
beadier103513912beadier
beaker125520692beaker
bearer85323912bearer
beater84729392beater
beaver114819252beaver
bedder104215782bedder
belayer12339502belayer
bender95223302bender
bidder104114862bidder
bider85728372b_ider
bilander1136672bilander
bilayer12347802bilayer
binder94422872binder
birder94915492birder
blabber10418922blabber
blacker154513512blacker
bladders12397802bladders
bladdery15344582bladdery
blae66134642bla_e_
blame95625492blame_
blamed116017952blamed
blamers115314212blamers
blames105121862blames
blanker134612022blanker
blare75826232blare_
blared95018242blared
blares85021632blares
blase75524232blase_
blaster94017302blaster
blate75933782blate_
blather125314202blather
blatter94415652blatter
blawed124713892blawed
blaze165520832blaze_
blazed184314712blazed
blazers184811682blazers
blazes174817352blazes
bleaker133510532bleaker
bleater94515302bleater
bleeder10359642bleeder
blender104613842blender
blinder103912982blinder
bloater94013422bloater
blonder104011942blonder
blower115316572blower
bludger11419562bludger
bluer74918492bl_uer
blunder103813152blunder
boarder103910322boarder
boater84622092boater
bolder94820932bolder
bonder95324782bonder
border94419972border
bracer104620582bracer
braider105112992braider
brander103915822brander
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
broader103412612broader
budder104314812budder
clade85821012clade_
clades94920462clades
claver113816972claver
clawer114512782clawer
deader84220472deader
elater64724202elater
elder64020022el_der
eluder73712212eluder
evader1036812evader
fader94421512_fader
flaker134916172flaker
flamer114919122flamer
flayer124713562flayer
gladder10398312gladder
glade75121962glade_
glades84820342glades
gladier93810992gladier
glazer164212262glazer
glider84614262glider
grader84919692grader
header104422542header
lacer75833752_lacer
ladder84617622_ladder
lade56345982_lade_
laded74232612_laded
laden65022192_laden
laders74927762_laders
lades65141272_lades
ladler74314932_ladler
lager65132862_lager
laker95432872_laker
lamer75233702_lamer
lander74028482_lander
larder73720972_larder
laser54633322_laser
later54843922_later
lauder73815012_lauder
laver85031792_laver
laxer125420332_laxer
layer84626472_layer
leader74824652leader
loader74316312loader
older65121172ol_der
placer105117742placer
planer84122652planer
plater84427692plater
player115215212player
pleader103511752pleader
reader73628292reader
shader104218762shader
slaker104219272slaker
slander84015442slander
slater64429182slater
slaver94419612slaver
slayer93916332slayer
slider73918362slider
spader94317132spader
trader75218762trader
wader95325362_wader

Search took 4 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.1231452772.4
2DLD Change Limit825511483.65622579.6
3Display Results1481480.0334484.8
 (SQL Overall)1786911483.81246875.9
 
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.