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

251 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
punts7582800(None) 
aunts55227631aunts
bunts75729801bunts
cunts76125121cunts
dunts65828411dunts
hunts86826171hunts
lunts55826901lunts
pants76536921pants
pints75936221pints
punas74826751punas
pungs85422221pungs
punks114822681punks
puns66641481pun_s
punt65747201punt_
punto75121321punto
puntos85915791puntos
punty106021611punty
puts65641751pu_ts
putts75719271putts
runts55927631runts
ants47243472_ants
aunt46553652aunt_
aunty85919812aunty
bents76033692bents
bints76130182bints
blunts84512892blunts
brunts85215452brunts
bunas75126572bunas
bunds85523542bunds
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunt65850852bunt_
busts75227692busts
buts67247692bu_ts
butts75824252butts
cants77036942cants
cents74730332cents
counts84618272counts
cults75022552cults
cunt66243672cunt_
cuts65841152cu_ts
daunts75014082daunts
dents65031802dents
dints67431312dints
ducts85319892ducts
duets65323882duets
duits65021882duits
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunt55746872dunt_
dusts65923562dusts
fonts86124752fonts
founts94313382founts
funds94119252funds
funks125318912funks
funs75235732fun_s
gents65729612gents
grunts75511852grunts
gunks104517722gunks
guns55533482gun_s
gusts65722792gusts
guts56637252gu_ts
hants86335402hants
haunts95614392haunts
hents87330742hents
hints87330622hints
hunks125321452hunks
huns76136932hun_s
hunt76445492hunt_
hurts86922822hurts
huts76737442hu_ts
jaunts137511882jaunts
junks164815972junks
junta123713672junta
juntas134210502juntas
junto125114562junto
juntos134110842juntos
justs124918262justs
juts115930162ju_ts
lints57137192lints
lunas55025012lunas
lunes55337772lunes
lunets66914762lunets
lungs65223882lungs
lunks94822452lunks
lunt46148842lunt_
lusts55022802lusts
mints76834042mints
mounts84115072mounts
munis75022002munis
muns65535922mun_s
musts75527442musts
muts64839982mu_ts
mutts75120252mutts
nuns45228232nun_s
nuts45032672nu_ts
ousts55225702ousts
outs45746962ou_ts
pacts95125802pacts
paints85921832paints
panes76148692panes
pangs84628662pangs
pans65855732pan_s
pant66061262pant_
panto76129412panto
pantos85222742pantos
panty105929302panty
parts77743372parts
pasts75936502pasts
pats66460852p_ats
peats76140192peats
pelts76128812pelts
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
pent66559072pent_
pests75933272pests
pets66248332p_ets
phots105418502phots
phuts104613502phuts
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pinots85920272pinots
pins65558452pin_s
pint66963172pint_
pinta75727052pinta
pintas85021392pintas
pinto75625752pinto
pintos86021292pintos
pits66348742p_its
plants84921802plants
plats75531372plats
plots75025672plots
plunks124711162plunks
poets76024442poets
points85618532points
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
pontes83627852pontes
ports75934592ports
posts75228782posts
pots66452362p_ots
poults84613482poults
pounds93714382pounds
pouts75530322pouts
prats76333392prats
prints84320102prints
prunes83419062prunes
prunus8399362prunus
pubes94423402pubes
pubis94616472pubis
pubs85029212pu_bs
puces94924632puces
pucks134322102pucks
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
pukes114523022pukes
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
pumas95121562pumas
pumps115520602pumps
pun58846512pun__
puna65331652pun_a
punch125118422punch
pundits10379292pundits
pung75429632pun_g
punish111411502punish
punji1438202punji
punjis1536692punjis
punk105729972pun_k
punka114515482punka
punkas123410672punkas
punky144419392punky
punnets9409262punnets
punny104217712punny
punted94618712punted
punter84320022punter
punters93617042punters
punties94520782punties
puny95526992pun_y
pupas95219282pupas
pups86032232pu_ps
pupus94614042pupus
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
purty105019402purty
pus55547842pu__s
puses75532202puses
puss64830132pu_ss
put55759072pu_t_
putt66937842pu_tt
putti76018742putti
putto75617662putto
putty104721402putty
putz158326322pu_tz
quants153614142quants
quints154316562quints
quits144122352quits
rants55935342rants
rents55935182rents
runes55530222runes
rungs611819402rungs
runs46438082run_s
runt46647992runt_
runty86119042runty
rusts55026992rusts
ruts44541492ru_ts
shunts95712022shunts
spunks12349332spunks
spurts84814972spurts
stunts65615252stunts
suets55126102suets
suints64617782suints
suits55028052suits
sunns55017352sunns
suns45841902sun_s
taunts65715662taunts
tents56434212tents
tints56030922tints
tufts85713272tufts
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
tuts45838452tu_ts
units54923432_units
uns35936762_un_s
unto45824282_unto
uts35534372_u_ts
vaunts95212622vaunts
vents86125932vents
wants87932212wants
wonts87621542wonts
yurts87216532yurts

Search took 2 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.296603685.8
2DLD Change Limit538002511.54634799.5
3Display Results2512510.0633984.1
 (SQL Overall)1786912511.90593801.0
 
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.