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

218 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
blues7512704(None) 
blubs95818151blubs
blue65328461blue_
blued84520321blued
bluer74918491bluer
bluest84016481bluest
bluesy11448981bluesy
bluet75631191bluet
bluets87215491bluets
bluey104817051bluey
blueys11419521blueys
blumes105917791blumes
blurs74619081blurs
clues74623031clues
flues84626921flues
glues65125681glues
lues45943551_lues
slues54527171slues
ables75935542abl_es
agues64919052agues
ales47067102al_es
almes75126542almes
aloes54933672aloes
alums75720602alums
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bates75846342bates
bauds85821042bauds
bees65453382b_ees
belies84631052belies
belles85325992belles
benes75536232benes
bes56557432b__es
beses75830722beses
bhuts105812952bhuts
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bilges94915632bilges
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
blabs95619632blabs
blades95221252blades
blae66134642blae_
blahs105616512blahs
blames105121862blames
blams95023852blams
blares85021632blares
blase75524232blase
blats75132502blats
blaws105620462blaws
blazes174817352blazes
bleb85425222bl_eb
blebs96416152blebs
bled75729312bl_ed
bleed85019802bleed
bleeds95211592bleeds
bleep95013452bleep
bleeps10499102bleeps
bless75917812bless
blest76431722bl_est
blet66247672bl_et
blets75324942blets
blew94722432bl_ew
blips95615782blips
bliss75616912bliss
blites84721212blites
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blokes123813882blokes
blots75626172blots
blouse84714722blouse
blouses94014462blouses
blows105423832blows
blub85324872blu_b
bludges114511122bludges
blueish1236482blueish
bluely113310082bluely
bluff134413832bluff
bluffs14388372bluffs
bluish1159242bluish
blume95619892blume
blumed114313642blumed
blunges104212222blunges
blunt75525022blunt
blunts84512892blunts
blur66020532blu_r
blurb95214902blurb
blurbs10489312blurbs
blurt77625622blurt
blurts84412642blurts
blush105115312blush
blushes124314822blushes
blypes13357542blypes
bodes84935102bodes
boles75448602boles
bolus79125542bolu_s
boluses94113832boluses
bones76446532bones
bores76448252bores
boules84925972boules
bouse75931852bouse
bouses84931782bouses
bouts75131312bouts
boxes145625072boxes
braes75735052braes
brees75632552brees
bries74942152bries
brumes106417072brumes
brutes86118682brutes
bruts75922952bruts
bruxes154811022bruxes
bubs86235502b_ubs
buds75235172b_uds
bugs76035912b_ugs
bulbs96016932bulbs
bulges95919322bulges
bulks115920612bulks
bulls75629572bulls
bums85934592b_ums
buns66243722b_uns
burs65847422b_urs
bus56950972b_u_s
buses75936012buses
buss65134912b_uss
butes714535872butes
buts67247692b_uts
buys95726792b_uys
byes95230532b_yes
byres104421382byres
bytes105217492bytes
clubs95415102clubs
clue65324532clue_
clued84917682clued
cues65438982_cues
dues56045502_dues
eludes75417682eludes
elutes64020312elutes
elves85118742elves
flees85828752flees
flies85630712flies
floes85528142floes
flubs105515442flubs
flue75329852flue_
flued95021252flued
flukes135114192flukes
flumes115119732flumes
flus75626542flu_s
flutes95421782flutes
fluxes165212932fluxes
glees65027592glees
glue55628492glue_
glued75118362glued
gluer65116772gluer
gluers75011152gluers
gluey95715262gluey
glugs75214282glugs
glumes94516812glumes
glums84621422glums
glutes74517672glutes
gluts66120132gluts
grues65721962grues
gules64831042gules
hues75235232_hues
ileus54616892ileus
kluges11389562kluges
kues86426772_kues
lees45455882_lees
les35663072_l_es
lies46454192_lies
lubes74727992_lubes
luces75528432_luces
ludes65728852_ludes
luges65928752_luges
lugs55233522_lugs
lums65734242_lums
lunes55337772_lunes
lures56138532_lures
lutes55836662_lutes
luvs75818502_luvs
luxes124921502_luxes
lyes75530832_lyes
moues75732842moues
mules75034292mules
oles46453472ol_es
plies74526512plies
plugs85213492plugs
plumes104318132plumes
plums94619952plums
plus66324832plu_s
pluses83618072pluses
pules74538812pules
roues56039352roues
rues46044482_rues
rules55234252rules
sloes54728872sloes
slubs74719532slubs
slue45332192slue_
slued64220512slued
slugs64618562slugs
slums74623432slums
slurs54123372slurs
sluts54523982sluts
spues75025382spues
sues46247652_sues
trues54925322trues
tules54532792tules
ulus45622562ulu_s
values94314942values
yules84521582yules

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 Limit538002181.45337026.8
3Display Results2182180.0633460.3
 (SQL Overall)1786912181.609111057.2
 
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.