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

354 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
pud6583665(None) 
bud67041271bud
cud67937451cud
dud56737591dud
fud76335151fud
mud67336861mud
oud47439071oud
pad68057321pad
ped66751521ped
pod66351481pod
pub76037691pub
puds75630511puds
pug65337181pug
pul56138061pul
pun58846511pun
pup76339881pup
pur56840551pur
pus55547841pus
put55759071put
spud75818491spud
wud76227151wud
ad311975032_ad
add510132362add
aid49269072aid
and47244162and
aped78538152aped
apod78123182apod
auk76234142auk
auld54125362auld
bad67763152bad
baud74928422baud
bed67950622bed
bid67751782bid
bod67055542bod
bub76343972bub
buds75235172buds
bug65340742bug
bum75342692bum
bun56348142bun
bund75530662bund
bur55744692bur
burd75534262burd
bus56950972bus
but55963022but
buy86436542buy
cad67456362cad
cod69660122cod
crud75219612crud
cub76940942cub
cuds76730472cuds
cue57544182cue
cued76329562cued
cum76440162cum
cup76738242cup
cur56841982cur
curd77634982curd
cut57957662cut
dad58456162dad
did56850512did
duad66521412duad
dub66642202dub
dude65629662dude
duds65530142duds
due45249862due
dug58138692dug
duh77930382duh
dui46433382dui
dun46545582dun
duo48536142duo
dup67637882dup
ed38645182_ed
eld46733792eld
end46834352end
fad77452412fad
fed76548352fed
feud86523022feud
fid76847682fid
fub86337392fub
fuds86528562fuds
fug76234512fug
fun66841142fun
fund85624982fund
fur66637322fur
gad57556652gad
gaud67025432gaud
ged57044532ged
gid57047262gid
god57449792god
gude65423332gude
guid66022822guid
gul45832792gul
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
had77658762had
hid76248362hid
hod76852462hod
hub86437482hub
hue66642302hue
hued86925852hued
hug76037362hug
huh96432012huh
hum85542932hum
hun65844712hun
hup86437812hup
hut66457292hut
id38941832_id
judo125315302judo
jug115529542jug
jun105932062jun
jus106930222jus
jut105944012jut
kid86540612kid
kudo96115102kudo
kudu95815422kudu
kue76631862kue
lad48165702lad
laud56527722laud
led46254552led
leud57223422leud
lid47453512lid
loud55228042loud
lude55331642lude
lug46138062lug
lum55542932lum
luv67125772luv
lux106528772lux
mad68958702mad
maud75325392maud
med66146742med
mid67354452mid
mod69054402mod
mu46737482mu_
muds75530652muds
mug65837692mug
mum76643612mum
mun56143852mun
mus55946752mus
mut58357182mut
nod47549562nod
nu26331952nu_
nub56439142nub
nude56626272nude
nun35537742nun
nurd56224342nurd
nus37939392nus
nut36651962nut
od39255242_od
odd57725452odd
old47033462old
oped76230152oped
opus66420592opus
ouds56430102ouds
our36042892our
out38072152out
pa410456482p_a
pac79054082pac
padi76331782padi
pads76742952pads
pah88853592pah
paid75737482paid
pal56761672pal
pam77858392pam
pan58466442pan
pap76758402pap
par57467022par
pard76441322pard
pas58775742pas
pat58089462pat
paw87651172paw
pax127346852pax
pay88461182pay
pe47649032p_e
pea56657242pea
pec76744412pec
peds75835242peds
pee56066512pee
peed76239182peed
peg65843062peg
peh86740962peh
pen56558842pen
pend75934532pend
pep76447082pep
per56353092per
pes57259782pes
pet56477302pet
pew86442302pew
pfui9349792pfui
phi86524202phi
pht86030522pht
phut96925972phut
pi48145362p_i
pia56848032pia
pic76046822pic
pie55457402pie
pied75035362pied
pig65744972pig
pin57066722pin
pip78051042pip
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
pled75231432pled
plod76723272plod
plug74915992plug
plum85122102plum
plus66324832plus
ply86323552ply
pods76540152pods
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
pond75530492pond
poo57757112poo
pood75934322pood
pop76252252pop
pot58078432pot
pouf95732642pouf
pound84417862pound
pour611527472pour
pout65752552pout
pow87147282pow
pox126140692pox
pro55837262pro
prod76129502prod
proud84615482proud
prude84615972prude
pry85728052pry
pseud867042pseud
psi56621622psi
pst57932512pst
ptui64912482ptui
pubs85029212pubs
puce85127882puce
puck124927942puck
pudgy124911162pudgy
pudic104614562pudic
puff125525432puff
pugh106619232pugh
pugs76332772pugs
puja135714922puja
puke105025462puke
puked124716222puked
pula65129372pula
pule65040952pule
puled84926522puled
puli65527622puli
pull64731662pull
pulp84825352pulp
puls65437562puls
puma85424122puma
pump105726852pump
puna65331652puna
pung75429632pung
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
pupa85422812pupa
pups86032232pups
pupu87620712pupu
purda82914692purda
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
push95526622push
puss64830132puss
puts65641752puts
putt66937842putt
putz158326322putz
pya87023752pya
pye86432502pye
pyx157817012pyx
qua124821972qua
quad144618702quad
quid144922352quid
quod145413622quod
rad47662002rad
red46755802red
rid46754622rid
rod47953892rod
rub56342822rub
rudd65917472rudd
rude55632782rude
rue35549262rue
rued55729792rued
rug46039152rug
rum56644642rum
run36244982run
rut35560522rut
sad47459202sad
scud76221282scud
sod46053702sod
sped76031492sped
spuds85113672spuds
spue66025522spue
spued84918472spued
spun66221462spun
spur65321192spur
stud56220092stud
sub55445552sub
sudd64719772sudd
suds56135292suds
sue35651462sue
sued56537932sued
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
surd56433812surd
tad47959822tad
ted46446562ted
thud85613912thud
tod49457072tod
tub55640032tub
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
turd56027622turd
tut36758092tut
tux105426572tux
udo49027302_udo
uh57429852_uh
um47338832_um
un28341132_un
up47832822_up
updo76712882updo
upo58925862upo
ups55629052ups
urd46427042urd
us26937432_us
ut28647032_ut
vid77241802vid
vug76127412vug
vum85428652vum
wad77053892wad
wed75843622wed
xu96018832xu_
yaud87020082yaud
yid76640822yid
yod77545502yod
yuk106725602yuk
yum86132822yum
yup86031702yup
zed135431172zed
zuz1110622032zuz

Search took 1 second 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.0632836365.1
2DLD Change Limit140843540.43632302.8
3Display Results3543540.0764657.9
 (SQL Overall)1786913540.575310767.0
 
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.