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

219 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
dupes8642593(None) 
dopes84935041dopes
drupes94912651drupes
duces86327471duces
dudes75424371dudes
dues56045501du_es
dukes105023471dukes
dunes65332171dunes
dupe76630601dupe_
duped95118321duped
duper85519001duper
dupers94615601dupers
dups75929511dup_s
dures65635921dures
jupes145218551jupes
supes75628301supes
apes66047432_apes
aures55137092aures
bupkes144811482bupkes
buses75936012buses
butes714535872butes
capes95441922capes
cepes94424462cepes
copes97747102copes
coupes105022522coupes
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cupel9514302cupel
cupels10310202cupels
cups85430822cup_s
cures75645432cures
cutes79438322cutes
daces85030682daces
dales66439742dales
dames85435852dames
daps77239162dap_s
dares66146702dares
dates65639152dates
daubes94913702daubes
dazes155024142dazes
deeps84921772deeps
dees56356632d_ees
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
deuces94015512deuces
dexes135224512dexes
dices86434242dices
dies55653532d_ies
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dips75536922dip_s
dites66339152dites
dives95832402dives
does56554472d_oes
doges75630162doges
doles67843752doles
domes85735562domes
dopas85019062dopas
dope76038892dope_
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
doses65938502doses
dotes65836692dotes
douses74928932douses
doves94728152doves
dozes155226302dozes
drapes95419652drapes
drees65628522drees
dries64733672dries
drupe85012992drupe_
druses75517252druses
duads76515342duads
duals65620082duals
dubs78432192du_bs
duce76933502duce_
ducks124823212ducks
ducts85319892ducts
dude65629672dude_
duded84417132duded
duds65530152du_ds
due45249862du_e_
duel56729702du_el
duels65619232duels
duet56446262du_et
duets65323882duets
duffs125216622duffs
dufus94010812dufus
dugs614832282du_gs
duits65021882duits
duke95628102duke_
duked115218462duked
dulls64523742dulls
dulse65415042dulse
dulses73913652dulses
dumas85420432dumas
dumbs105915752dumbs
dumped123814492dumped
dumper114615212dumper
dumpers123412662dumpers
dumps105220102dumps
dunces95215752dunces
dune56137582dune_
dungs75821972dungs
dunks105621192dunks
duns55140432du_ns
dunts65828412dunts
duos56728132du_os
dup67637882dup__
dupery12378742dupery
duple85315862duple
duplex16386972duplex
dupped124411642dupped
duras65727732duras
dure56341812dure_
dured75025402dured
duress74712062duress
durns64819872durns
duros65422692duros
durrs65519992durrs
dusks105317252dusks
dusts65923562dusts
duties74921902duties
duvet9321872duvet
duvets1039222duvets
dyes85331892d_yes
dykes135215572dykes
dynes95917582dynes
educes94011952educes
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
gapes86030822gapes
gudes74520812gudes
gules64831042gules
hopes105835642hopes
hues75235232hu_es
hypes135818672hypes
japes146322822japes
jubes145420742jubes
jukes165319102jukes
jupe134921002jupe_
jutes125125132jutes
kues86426782ku_es
lopes76437342lopes
loupes84918052loupes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lupus74512522lupus
lures56138532lures
lutes55836662lutes
luxes124921502luxes
mopes95134982mopes
mules75034292mules
mures75937222mures
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
sipes76036952sipes
spues75025382spues
stupes84116952stupes
sues46247652su_es
supe65932762supe_
super74924482super
supers84622402supers
sups64834432sup_s
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 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.326548131.9
2DLD Change Limit538002191.67332157.8
3Display Results2192190.0633476.2
 (SQL Overall)1786912192.06286659.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.