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

123 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
bluer7491849(None) 
blue65328461blue_
blued84520321blued
blues75127041blues
bluet75631191bluet
bluey104817051bluey
blur66020531blu_r
gluer65116771gluer
abler75624312abl_er
alder65421912alder
alter54828502alter
baker115629542baker
balder95318862balder
baler75635272baler
balker124519162balker
baller83825202baller
barer74535802barer
baser74828922baser
beer65635992b_eer
belier84423562belier
belter84720962belter
bider85728372bider
bier65531832b_ier
biker116022562biker
bilker124913442bilker
biller84923482biller
biner75930692biner
biter75030032biter
blader93618582blader
blae66134642blae_
blamer104417142blamer
blare75826232blare
blazer174414022blazer
blear75918682blear
bleb85425222bl_eb
bled75729312bl_ed
bleed85019802bleed
bleep95013452bleep
blet66247672bl_et
blew94722432bl_ew
blower115316572blower
blub85324872blu_b
blubber10399292blubber
blubs95818152blubs
blucher143310222blucher
bludger11419562bludger
bluely113310082bluely
bluest84016482bluest
bluesy11448982bluesy
bluets87215492bluets
blueys11419522blueys
bluff134413832bluff
bluffer15396882bluffer
blume95619892blume
blumed114313642blumed
blumes105917792blumes
blunder103813152blunder
blunger104112012blunger
blunt75525022blunt
blunter94512032blunter
blurb95214902blurb
blurry11437672blurry
blurs74619082blurs
blurt77625622blurt
blurter9419832blurter
blush105115312blush
blusher124113112blusher
bluster94215312bluster
bolder94820932bolder
bolter83920752bolter
boner75133082boner
borer75131272borer
bower107328182bower
boxer145016522boxer
brier74527402brier
buhr95315382b_uhr
bulger94917352bulger
bur55744692b_u_r
burr65631232b_urr
buyer105013092buyer
clue65324532clue_
clued84917682clued
clues74623032clues
elder64020022elder
eluder73712212eluder
elver85216242elver
fleer86020772fleer
flier86023402flier
flue75329852flue_
flued95021252flued
flues84626922flues
fluor84512772fluor
fluter95316862fluter
flyer114916252flyer
glue55628492glue_
glued75118362glued
gluers75011152gluers
glues65125682glues
gluey95715262gluey
gluier7310262gluier
iller54821292iller
leer46239352_leer
lier45942462_lier
lues45943552_lues
luger65322082_luger
lure45142462_lure
lurer54625312_lurer
older65121172older
plier75221282plier
plyer106214332plyer
puler74826622puler
ruer46127562_ruer
ruler54923342ruler
slier54827242slier
slue45332192slue_
slued64220512slued
slues54527172slues
slur45525152slu_r
slyer85515122slyer
suer45334032_suer
truer54916642truer
ulcer7310752ulcer
valuer93911442valuer

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.313570897.8
2DLD Change Limit538001231.50035866.7
3Display Results1231230.0462673.9
 (SQL Overall)1786911231.85996122.1
 
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.