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

228 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
clues7462303(None) 
blues75127041blues
clubs95415101clubs
clue65324531clue_
clued84917681clued
cues65438981c_ues
flues84626921flues
glues65125681glues
lues45943551_lues
slues54527171slues
agues64919052agues
ales47067102al_es
almes75126542almes
aloes54933672aloes
alums75720602alums
blubs95818152blubs
blue65328462blue_
blued84520322blued
bluer74918492bluer
bluest84016482bluest
bluesy11448982bluesy
bluet75631192bluet
bluets87215492bluets
bluey104817052bluey
blueys11419522blueys
blumes105917792blumes
blurs74619082blurs
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
calces104420052calces
calques182710192calques
calves115119282calves
calxes154113032calxes
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cases75048382cases
cates75951892cates
caules85927252caules
cauls75727772cauls
cause75225352cause
causes88026472causes
caves105639702caves
cedes84927332cedes
cees65941592c_ees
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
chubs125412622chubs
chugs115511942chugs
chums125015832chums
chutes114615772chutes
cines75239682cines
cires74932912cires
cites74435592cites
clades94920462clades
clads85722732clads
clags85621122clags
clams95127672clams
clans75031012clans
claps95626182claps
claques18279012claques
class75525482class
clause84311502clause
clauses93813322clauses
claves115020062claves
claws106020832claws
clays105521332clays
cleek115514912cleek
cleeks125010542cleeks
clef97028182cl_ef
clefs106616242clefs
clepes104214622clepes
clew95520572cl_ew
clews105516332clews
climes104720002climes
clines84926042clines
clips96018302clips
cliques18309202cliques
clods85320862clods
clogs85519552clogs
clones84526562clones
clons75228132clons
clops95924852clops
cloques18268562cloques
close76425222close
closes85425592closes
clots75627642clots
clouds94612352clouds
clours85215092clours
clouts87017202clouts
cloves114918822cloves
cloys104916942cloys
clozes174915562clozes
club85819472clu_b
cluck134914892cluck
clucks144512072clucks
clump115517452clump
clumps1215314642clumps
clumsy13326192clumsy
clung86013602clung
clunk114215082clunk
clunks124811012clunks
codes86247292codes
cokes115537192cokes
coles76055062coles
coleus86818272coleus
colies84837052colies
colures9315142colures
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coups95522472coups
coves105539172coves
coxes145430862coxes
cozes166033242cozes
cries75438402cries
cruces105117542cruces
crudes96218622crudes
cruds85815852cruds
cruel74815902cruel
cruet74831842cruet
cruets85314952cruets
crus65828482cru_s
cruse75726102cruse
cruses88127712cruses
cruxes154911562cruxes
cubes95028162cubes
cubs85832382c_ubs
cuds76730472c_uds
cue57544182c_ue_
cued76329562c_ued
cukes115422092cukes
culet76040342culet
culets85518512culets
culex144613932culex
culls75425812culls
culms95314192culms
cults75022552cults
cups85430822c_ups
cures75645432cures
curs65645542c_urs
cuss65430612c_uss
cutes79438322cutes
cuts65841152c_uts
cymes1210118922cymes
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
kluges11389572kluges
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 3 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 Limit538002281.65632487.9
3Display Results2282280.0633619.0
 (SQL Overall)1786912282.02988068.5
 
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.