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

102 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
bluet7563119(None) 
blet66247671bl_et
blue65328461blue_
blued84520321blued
bluer74918491bluer
blues75127041blues
bluest84016481bluest
bluets87215491bluets
bluey104817051bluey
blunt75525021blunt
blurt77625621blurt
abluent939622abluent
baguet9316102baguet
ballet84733972ballet
beet66457542b_eet
beget85632562beget
beret74946362beret
beset76739132beset
bet58376672b__et
bhut95425712bhu_t
bidet84935622bidet
billet86029722billet
blae66134642blae_
blast76532572blast
blat66550952bl_at
blate75933782blate
bleat75737002bleat
bleb85425222bl_eb
bled75729312bl_ed
bleed85019802bleed
bleep95013452bleep
blent76230952blent
blest76431722blest
blets75324942bl_ets
blew94722432bl_ew
blite76225352blite
bloat75229922bloat
blot65842322bl_ot
blub85324872blu_b
blubs95818152blubs
bluely113310082bluely
bluesy11448982bluesy
blueys11419522blueys
bluff134413832bluff
blume95619892blume
blumed114313642blumed
blumes105917792blumes
blunts84512892blunts
blur66020532blu_r
blurb95214902blurb
blurs74619082blurs
blurts84412642blurts
blush105115312blush
bout66353292bou_t
bruit76126722bruit
brunet84419292brunet
brunt75728752brunt
brut66537962bru_t
brute75321782brute
bullet84528612bullet
bunt65850852b_unt
buret77444012buret
bust65947782b_ust
but55963022b_u_t
bute66739672b_ute
butt65143742b_utt
clue65324532clue_
clued84917682clued
clues74623032clues
cruet74831842cruet
culet76040342culet
duet56446262_duet
eluent6315482eluent
elute54822572elute
fleet85932332fleet
flue75329852flue_
flued95021252flued
fluent9313932fluent
flues84626922flues
flute86823752flute
fluyt114614202fluyt
gleet65532342gleet
glue55628492glue_
glued75118362glued
gluer65116772gluer
glues65125682glues
gluey95715262gluey
glut56331292glu_t
glute66020902glute
leet45957902_leet
let36481472_l_et
lues45943552_lues
lunet56835422_lunet
lunt46148842_lunt
lust47442602_lust
lute46341012_lute
sleet55639132sleet
slue45332192slue_
slued64220512slued
slues54527172slues
slut45040592slu_t
suet46754822_suet

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.310576422.6
2DLD Change Limit538001021.42337807.4
3Display Results1021020.0333090.9
 (SQL Overall)1786911021.766101184.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.