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

150 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
blued8452032(None) 
bled75729311bl_ed
bleed85019801bleed
blue65328461blue_
bluer74918491bluer
blues75127041blues
bluet75631191bluet
bluey104817051bluey
blumed114313641blumed
clued84917681clued
flued95021251flued
glued75118361glued
slued64220511slued
abled86926832abl_ed
abluted10188362abluted
baaed85218162baaed
baked126130772baked
balded105417512balded
baled85436442baled
balked135219412balked
balled94926892balled
baned85436352baned
bared85144482bared
based85331582based
bated85935532bated
baud74928422bau_d
bayed115423022bayed
bed67950622b__ed
belied95022162belied
belled94626182belled
belted94020632belted
bided95424962bided
biked125320032biked
bilged105513182bilged
bilked134012942bilked
billed94224902billed
biped104718832biped
blade85923332blade
bladed104717762bladed
blae66134642blae_
blamed116017952blamed
bland85320452bland
blared95018242blared
blawed124713892blawed
blazed184314712blazed
bleb85425222bl_eb
bleeds95211592bleeds
bleep95013452bleep
blend85317452blend
blet66247672bl_et
blew94722432bl_ew
blind86319322blind
blond85618372blond
blood85319522blood
bloused104310642bloused
blowed125016692blowed
blub85324872blu_b
blubbed11338392blubbed
blubs95818152blubs
bludged12439312bludged
bluely113310082bluely
bluest84016482bluest
bluesy11448982bluesy
bluets87215492bluets
blueys11419522blueys
bluff134413832bluff
bluffed16326432bluffed
blume95619892blume
blumes105917792blumes
blunged114310132blunged
blunt75525022blunt
blunted104210662blunted
blur66020532blu_r
blurb95214902blurb
blurbed12337612blurbed
blurred10427802blurred
blurs74619082blurs
blurt77625622blurt
blurted10399782blurted
blush105115312blush
blushed134411752blushed
boded95124962boded
bolled94722652bolled
bolted94617802bolted
boned85133242boned
booed85127272booed
bored85034302bored
bound84819582bound
boused95322882boused
bowed114533422bowed
boxed154318612boxed
bred75130972b_red
breed85526692breed
bruted95113262bruted
bruxed16466982bruxed
bud67041272b_u_d
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bulled94626492bulled
bund75530662b_und
burd75534262b_urd
bused85624492bused
clue65324532clue_
clues74623032clues
cued76329562_cued
elude64517622elude
eluded84612772eluded
eluted74915262eluted
feued94715662feued
fled85429772fl_ed
flied96519432flied
flue75329852flue_
flues84626922flues
fluid94013962fluid
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
gled65631142gl_ed
gleed75320572gleed
glue55628492glue_
gluer65116772gluer
glues65125682glues
gluey95715262gluey
hued86925852_hued
kluged12427212kluged
led46254552_l_ed
leud57223422_leud
lied55838092_lied
lubed85319892_lubed
lude55331642_lude
lues45943552_lues
luged74019092_luged
lured65427492_lured
luted64826142_luted
muled85824432muled
pled75231432pl_ed
plied85118592plied
plumed114412882plumed
puled84926522puled
rued55729792_rued
ruled65822522ruled
sled55334372sl_ed
slue45332192slue_
slues54527172slues
spued84918472spued
sued56537932_sued
trued65117692trued
valued104011152valued

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.0931921408.6
2DLD Change Limit538001501.69031834.3
3Display Results1501500.0463260.9
 (SQL Overall)1786911501.82997698.7
 
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.