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

340 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
pul5613806(None) 
gul45832791gul
pal56761671pal
pol56449381pol
pub76037691pub
pud65836651pud
pug65337181pug
pula65129371pula
pule65040951pule
puli65527621puli
pull64731661pull
pulp84825351pulp
puls65437561puls
pun58846511pun
pup76339881pup
pur56840551pur
purl65631421purl
pus55547841pus
put55759071put
aal39058672aal
ail37171042ail
al210674042_al
all36148232all
ampul91110852ampul
auk76234142auk
auld54125362auld
awl67635302awl
bal56662722bal
bel57148462bel
bub76343972bub
bud67041272bud
bug65340742bug
buhl95518222buhl
bulb85626692bulb
bulk105426152bulk
bull65634872bull
bum75342692bum
bun56348142bun
bur55744692bur
burl64937182burl
bus56950972bus
but55963022but
buy86436542buy
caul65630002caul
cel56040552cel
col59360352col
cub76940942cub
cud67937452cud
cue57544182cue
cull65929642cull
culm85822382culm
cult66541152cult
cum76440162cum
cup76738242cup
cur56841982cur
curl66035052curl
cut57957662cut
dal47554952dal
del46752752del
dol47150652dol
dual55928172dual
dub66642202dub
dud56737592dud
due45249862due
duel56729702duel
dug58138692dug
duh77930382duh
dui46433382dui
dull56430442dull
duly85323032duly
dun46545582dun
duo48536142duo
dup67637882dup
eel37946842eel
el26745292_el
ell36735682ell
fil65447142fil
flu66530212flu
foul77027582foul
fub86337392fub
fud76335152fud
fuel76824732fuel
fug76234512fug
full75229152full
fun66841142fun
fur66637322fur
furl77030882furl
gal46055512gal
gel45642432gel
gulf84929422gulf
gull54828452gull
gulp75521362gulp
guls55930852guls
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
haul75530452haul
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hula74923752hula
hulk115321612hulk
hull75428782hull
hum85542932hum
hun65844712hun
hup86437812hup
hurl76029932hurl
hut66457292hut
ill37437092ill
jug115529542jug
jun105932062jun
jus106930222jus
jut105944012jut
kue76631862kue
lug46138062lug
lull44225762lull
lulu44122882lulu
lum55542932lum
luv67125772luv
lux106528772lux
maul64830712maul
mel56047482mel
mil55752102mil
mol56654592mol
mu46737482mu_
mud67336862mud
mug65837692mug
mule65236972mule
mull65128802mull
mum76643612mum
mun56143852mun
mus55946752mus
mut58357182mut
nil36144192nil
nu26331952nu_
nub56439142nub
null45125312null
nun35537742nun
nurl45327242nurl
nus37939392nus
nut36651962nut
oil37452052oil
opal66923522opal
opus66420592opus
oud47439072oud
our36042892our
out38072152out
owl66228972owl
pa410456482p_a
pac79054082pac
pad68057322pad
pah88853592pah
pail66141832pail
pale66055012pale
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pam77858392pam
pan58466442pan
pap76758402pap
par57467022par
pas58775742pas
pat58089462pat
paw87651172paw
pawl95123262pawl
pax127346852pax
pay88461182pay
pe47649032p_e
pea56657242pea
peal68648102peal
pec76744412pec
ped66751522ped
pee56066512pee
peel65535612peel
peg65843062peg
peh86740962peh
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pen56558842pen
pep76447082pep
per56353092per
pes57259782pes
pet56477302pet
pew86442302pew
pfui9349792pfui
phi86524202phi
pht86030522pht
phut96925972phut
pi48145362p_i
pia56848032pia
pial65636702pial
pic76046822pic
picul95015362picul
pie55457402pie
pig65744972pig
pile65649692pile
pili66130352pili
pill65339462pill
pily96132732pily
pin57066722pin
pip78051042pip
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
plug74915992plug
plum85122102plum
plus66324832plus
ply86323552ply
pod66351482pod
poh86740532poh
poi57244662poi
pole65951302pole
poll66332132poll
polo66236632polo
pols66044562pols
poly96235152poly
pom78249912pom
poo57757112poo
pool65835952pool
pop76252252pop
pot58078432pot
pouf95732642pouf
poult76928872poult
pour611527472pour
pout65752552pout
pow87147282pow
pox126140692pox
pro55837262pro
pry85728052pry
psi56621622psi
pst57932512pst
ptui64912482ptui
pubs85029212pubs
puce85127882puce
puck124927942puck
puds75630512puds
puff125525432puff
pugh106619232pugh
pugs76332772pugs
puja135714922puja
puke105025462puke
puled84926522puled
puler74826622puler
pules74538812pules
pulik113613302pulik
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
pulpy124612362pulpy
pulse74219972pulse
puma85424122puma
pump105726852pump
puna65331652puna
pung75429632pung
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
pupa85422812pupa
pupal97616872pupal
pupil94712982pupil
pups86032232pups
pupu87620712pupu
pure65543332pure
puri65931442puri
purls74723352purls
purr64925812purr
purs65641042purs
push95526622push
puss64830132puss
puts65641752puts
putt66937842putt
putz158326322putz
pya87023752pya
pye86432502pye
pyx157817012pyx
qua124821972qua
rub56342822rub
rue35549262rue
rug46039152rug
rule49938422rule
ruly76323142ruly
rum56644642rum
run36244982run
rut35560522rut
sal36462882sal
saul45836522saul
sel38253322sel
shul75823152shul
sol37256622sol
soul46435712soul
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
sub55445552sub
sue35651462sue
suk75632972suk
sulk85326652sulk
sulu45128422sulu
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
tel35647902tel
til36350262til
tub55640032tub
tug45937402tug
tui37034022tui
tule45735872tule
tun35845192tun
tup56037542tup
tut36758092tut
tux105426572tux
uh57429852_uh
ulu36028702_ulu
um47338832_um
un28341132_un
up47832822_up
upo58925862upo
ups55629052ups
us26937432_us
ut28647032_ut
vug76127412vug
vum85428652vum
waul76927312waul
wud76227152wud
xu96018832xu_
yuk106725602yuk
yule75725142yule
yum86132822yum
yup86031702yup
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.0602978183.3
2DLD Change Limit140843400.39335837.2
3Display Results3403400.0605666.7
 (SQL Overall)1786913400.513348325.5
 
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.