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

248 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
supes7562830(None) 
dupes86425931dupes
jupes145218551jupes
sipes76036951sipes
spues75025381spues
stupes84116951stupes
sues46247651su_es
supe65932761supe_
super74924481super
supers84622401supers
sups64834431sup_s
apes66047432_apes
aures55137092aures
bupkes144811482bupkes
buses75936012buses
butes714535872butes
capes95441922capes
cepes94424462cepes
copes97747102copes
coupes105022522coupes
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cupel9514302cupel
cupels10310202cupels
cups85430822cup_s
cures75645432cures
cutes79438312cutes
dopes84935042dopes
drupes94912652drupes
duces86327472duces
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunes65332172dunes
dupe76630602dupe_
duped95118322duped
duper85519002duper
dupers94615602dupers
dups75929512dup_s
dures65635922dures
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
gapes86030822gapes
gudes74520812gudes
gules64831042gules
hopes105835642hopes
hues75235232hu_es
hypes135818672hypes
japes146322822japes
jubes145420742jubes
jukes165319102jukes
jupe134921002jupe_
jutes125125132jutes
kues86426772ku_es
lopes76437342lopes
loupes84918052loupes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lupus74512522lupus
lures56138532lures
lutes55836662lutes
luxes124921502luxes
mopes95134982mopes
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
napes74828462napes
nudes64723292nudes
nukes95418122nukes
opes65942612_opes
ouphes113614632ouphes
ouphs104311272ouphs
pes57259782__pes
pipes96030142pipes
popes95933812popes
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pupas95219282pupas
pups86032232pup_s
pupus94614042pupus
puses75532202puses
rapes75740722rapes
ripes75435772ripes
ropes75940062ropes
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
rupee7321282rupee
rupees8312572rupees
ruses56136582ruses
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
saps65346372sap_s
sates54949322sates
sauces84919502sauces
sautes63924912sautes
saves85838632saves
saxes125229342saxes
scapes105122262scapes
scopes104719592scopes
scups95316652scup_s
scutes85219192scutes
seeps74828752seeps
sees45361052s_ees
semes75731582semes
sepses84515882sepses
septs75420602septs
seres55448892seres
sexes126126222sexes
shapes115124942shapes
shes75734352s_hes
shies86136552shies
shoes85429652shoes
shutes93518212shutes
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipe67341042sipe_
siped84927682siped
sips65740102sip_s
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skeps115614252skeps
skies95026832skies
slipes84921412slipes
sloes54728872sloes
slopes84820452slopes
slues54527172slues
slypes114410482slypes
snipes83917392snipes
snyes85012752snyes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
souped95017672souped
soups75322942soup_s
souses64229242souses
spaes76029972spaes
spas67036722s_pas
spec85821972s_pec
specs96916672s_pecs
sped76031492s_ped
spew95421872s_pew
spews105015922s_pews
spies76037622spies
spuds85113672spuds
spue66025522spue_
spued84918472spued
spumes1021314882spumes
spurs74621522spurs
stapes85028732stapes
steps76619882steps
sties55132982sties
stipes84524052stipes
stopes84525892stopes
stupas83910882stupas
stupe75217752stupe_
styes86316522styes
subas74724072subas
suber74924502suber
subers85722642subers
subs66037122su_bs
sucks114523072sucks
sucres84218892sucres
sudds75513592sudds
suds56135292su_ds
sudses74114502sudses
sue35651462su_e_
sued56537932su_ed
suedes73918112suedes
suer45334032su_er
suers55128482suers
suet46754822su_et
suets55126102suets
sughs95313322sughs
suites63727402suites
suits55028052suits
suks85927122su_ks
sulks94818462sulks
sulus54821882sulus
sumos75720092sumos
sumps95023432sumps
sums65837582su_ms
sunns55017352sunns
suns45841902su_ns
sup57041942sup__
superb104410992superb
supines94216382supines
supped114415702supped
supper104115432supper
suppers113314692suppers
supples11511282supples
supra73614252supra
suqs134319652su_qs
suras55336322suras
surds65624662surds
sure45447412sure_
surer54833092surer
surest65026762surest
surfs85022542surfs
surges73924592surges
suss45229302su_ss
susses64221052susses
swipes114114332swipes
syces106416462syces
sykes124816862sykes
syphs13519452syphs
tapes75838602tapes
taupes8212672taupes
topes76941762topes
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tups65628762tup_s
tuxes124316042tuxes
types105721062types
ukes86122812_ukes
upas68322382_upas
ups55629052_up_s
uses44931112_uses
utes45930882_utes
wipes104827082wipes
yipes106017842yipes
yules84521582yules
yups96121602yup_s

Search took 4 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.1731032896.0
2DLD Change Limit538002483.40615795.7
3Display Results2482480.1401771.4
 (SQL Overall)1786912483.71948048.1
 
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.