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

107 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
blander10371517(None) 
bander93928221b_ander
bilander1136671bilander
bladder11429151bladder
blader93618581bla_der
blanker134612021blanker
blender104613851blender
blinder103912991blinder
blonder104011951blonder
blunder103813161blunder
brander103915821brander
lander74028491_lander
slander84015451slander
badder103817512b_adder
balancer1246602balancer
balder95318862b_alder
banded105223172b_anded
banders104324562b_anders
banger94423642b_anger
banker124222732b_anker
banner84421502b_anner
banter84825342b_anter
beader94623792bea_der
bender95223302b_ender
bilanders1235962bilanders
binder94422872b_inder
blabber10418922blabber
blacker154513512blacker
bladders12397802bladders
bladdery15344582bladdery
blade85923332bla_de_
bladed104717762bla_ded
bladers104214682bla_ders
blades95221252bla_des
blamer104417142bla_mer
blancher15338632blancher
bland85320452bland__
blandest113811042blandest
blandly1336042blandly
blanked144011222blanked
blanket134313092blanket
blaster94017302blaster
blather125314212blather
blatter94415652blatter
blazer174414022bla_zer
bleeder10359642bleeder
blende95413442blende_
blended114710712blended
blenders115211002blenders
blendes104713682blendes
blinded114810022blinded
blinders113911152blinders
blinker134110212blinker
blonde94813292blonde_
blondes104213162blondes
blunders113911352blunders
blunger104112022blunger
blunter94512042blunter
boarder103910322boarder
bonder95324782b_onder
bounder104215542bounder
braider105112992braider
branded114414102branded
branders114313092branders
branner94212372branner
clanger104113492clanger
colander1139032colander
dander811222992_dander
flanger113412622flanger
flanker143911292flanker
flinder11319882flinder
gander84322762_gander
gladder10398312gladder
glancer103710072glancer
glanders103811512glanders
glandes95413832glandes
grander93315872grander
hander104526432_hander
inlander937222inlander
islander946102islander
ladder84617622_ladder
lader65633722_la_der
lancer84319972_lancer
landed84619242_landed
landers84026222_landers
landler84113202_landler
lanker104123002_lanker
lanner64920602_lanner
larder73720972_larder
lauder73815012_lauder
launder8309152_launder
lender73921282_lender
meander1049972meander
oleander936402oleander
pander93725532_pander
planer84122662plan_er
planner93511632planner
planter94017812planter
plunder103810512plunder
sander74828532_sander
slanders94014022slanders
slender83413602slender
solander948122solander
stander84316162stander
uplander1145542uplander
wander104423712_wander
zander163417112_zander

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 Filter1786911076710.390458182.1
2DLD Change Limit1076711073.28032826.5
3Display Results1071070.0333242.4
 (SQL Overall)1786911073.70348255.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.