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

333 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
pup7633988(None) 
cup76738241cup
dup67637881dup
hup86437811hup
pap76758401pap
pep76447081pep
pip78051041pip
pop76252251pop
pub76037691pub
pud65836651pud
pug65337181pug
pul56138061pul
pulp84825351pulp
pump105726851pump
pun58846511pun
pupa85422811pupa
pups86032231pups
pupu87620711pupu
pur56840551pur
pus55547841pus
put55759071put
sup57041941sup
tup56037541tup
up47832821_up
yup86031701yup
alp56641132alp
amp77541022amp
app76827602app
asp57235342asp
auk76234142auk
bap76455842bap
bop77549482bop
bub76343982bub
bud67041272bud
bug65340742bug
bum75342692bum
bump106228242bump
bun56348142bun
bur55744692bur
burp85028882burp
bus56950972bus
but55963022but
buy86436542buy
cap76758982cap
cep75736332cep
cop711162372cop
coup86729792coup
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cups85430822cups
cur56841982cur
cusp86021062cusp
cut57957662cut
dap66652452dap
dip67848982dip
dub66642202dub
dud56737592dud
due45249862due
dug58138692dug
duh77930382duh
dui46433382dui
dump95927092dump
dun46545582dun
duo48536142duo
dupe76630602dupe
dups75929512dups
fop86743702fop
fub86337392fub
fud76335152fud
fug76234512fug
fun66841142fun
fur66637322fur
gap67055612gap
gip67645362gip
gul45832792gul
gulp75521362gulp
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
gyp98319012gyp
hap87360052hap
hep86644142hep
hip86750432hip
hop87554592hop
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
hump116228722hump
hun65844712hun
hut66457292hut
hyp117822462hyp
imp76626972imp
jaup135316422jaup
jug115529542jug
jump156621722jump
jun105932062jun
jupe134921002jupe
jus106930222jus
jut105944012jut
kep96437202kep
kip97042142kip
kop97440202kop
kue76631862kue
lap58565272lap
lip514755802lip
lop58255312lop
loup66028432loup
lug46138062lug
lum55542932lum
lump86531702lump
luv67125772luv
lux106528772lux
map77255122map
mop76950822mop
mu46737482mu_
mud67336862mud
mug65837692mug
mum76643612mum
mump105425722mump
mun56143862mun
mus55946752mus
mut58357182mut
nap56753202nap
nip56945982nip
nu26331952nu_
nub56439142nub
nun35537742nun
nus37939392nus
nut36651962nut
op45850162_op
opus66420592opus
oud47439072oud
ouph95618372ouph
our36042892our
out38072152out
pa410456482p_a
pac79054082pac
pad68057322pad
pah88853592pah
pal56761672pal
palp85828572palp
pam77858392pam
pan58466452pan
papa85827142papa
paps86443452paps
par57467022par
pas58775742pas
pat58089462pat
paw87651172paw
pax127346852pax
pay88461182pay
pe47649032p_e
pea56657242pea
pec76744412pec
ped66751522ped
pee56066512pee
peep85833692peep
peg65843062peg
peh86740962peh
pen56558842pen
pepo87622152pepo
peps85134512peps
per56353092per
perp89029892perp
pes57259782pes
pet56477302pet
pew86442302pew
pfui9349792pfui
phi86524202phi
pht86030522pht
phut96925972phut
pi48145362p_i
pia56848032pia
pic76046822pic
pie55457402pie
pig65744972pig
pimp106024902pimp
pin57066722pin
pinup9612882pinup
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
plop86625742plop
plug74915992plug
plum85122102plum
plump115315262plump
plus66324832plus
ply86323552ply
pod66351482pod
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
pomp106225462pomp
poo57757112poo
poop86532812poop
pope85535612pope
pops86340952pops
pot58078432pot
pouf95732642pouf
pour611527472pour
pout65752552pout
pow87147282pow
pox126140692pox
prep86427672prep
pro55837262pro
prop85932812prop
pry85728052pry
psi56621622psi
pst57932512pst
ptui64912482ptui
pubs85029212pubs
puce85127882puce
puck124927942puck
puds75630512puds
puff125525432puff
pugh106619232pugh
pugs76332772pugs
puja135714922puja
puke105025462puke
pula65129372pula
pule65040952pule
puli65527622puli
pull64731662pull
pulps95116482pulps
pulpy124612362pulpy
puls65437562puls
puma85424122puma
pumps115520602pumps
puna65331652puna
pung75429632pung
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
pupae96515642pupae
pupal97616872pupal
pupas95219282pupas
pupil94712982pupil
puppy114912412puppy
pupus94614042pupus
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
push95526622push
puss64830132puss
puts65641752puts
putt66937842putt
putz158326322putz
pya87023752pya
pye86432502pye
pyx157817012pyx
qua124821972qua
quip154818622quip
rap56261962rap
rep55847802rep
rip56851302rip
roup66627692roup
rub56342822rub
rue35549262rue
rug46039152rug
rum56644642rum
rump86729082rump
run36244992run
rut35560522rut
sap56463232sap
scup84822382scup
sip57656012sip
sop57557862sop
soup66232912soup
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
sub55445552sub
sue35651462sue
suk75632972suk
sum56346012sum
sump86331532sump
sun37149032sun
supe65932762supe
sups64834432sups
suq126228992suq
tap57663872tap
tip56551222tip
top510560682top
tub55640032tub
tug45937402tug
tui37034022tui
tump85927032tump
tun35845192tun
tups65628762tups
tut36758092tut
tux105426572tux
uh57429852_uh
um47338832_um
ump76130442ump
un28341142_un
upo58925862upo
ups55629052ups
urp56426402urp
us26937432_us
ut28647032_ut
vug76127412vug
vum85428652vum
wap86553372wap
whup125714162whup
wop87145132wop
wud76227152wud
xu96018832xu_
yap85949822yap
yaup96618482yaup
yep86638962yep
yip87241182yip
yuk106725602yuk
yum86132822yum
yups96121602yups
zap145840692zap
zep147129142zep
zip146636222zip
zuz1110622032zuz

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 Filter178691140840.500357382.0
2DLD Change Limit140843331.03013673.8
3Display Results3333330.1262642.9
 (SQL Overall)1786913331.656107905.2
 
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.