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

230 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
punks11482268(None) 
bunks115125081bunks
dunks105621191dunks
funks125318911funks
gunks104517721gunks
hunks125321451hunks
junks164815971junks
lunks94822451lunks
pinks115729381pinks
plunks124711161plunks
pucks134322101pucks
punas74826751punas
pungs85422221pungs
punk105729971punk_
punka114515481punka
punkas123410671punkas
punky144419391punky
puns66641481pun_s
punts75828001punts
spunks12349331spunks
auks85525262au_ks
aunts55227632aunts
banks115527902banks
bonks116326462bonks
bucks134824292bucks
bulks115920612bulks
bunas75126572bunas
bunds85523542bunds
bungs85323862bungs
bunk105731352bunk_
bunko115514512bunko
bunkos124210322bunkos
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
busks115521372busks
chunks154210332chunks
clunks124811012clunks
conks115525702conks
cunts76125122cunts
cusks114916052cusks
dinks105927952dinks
drunks11427512drunks
ducks124823212ducks
dunes65332172dunes
dungs75821972dungs
dunk96228572dunk_
duns55140432dun_s
dunts65828412dunts
dusks105317252dusks
finks125424222finks
flunks13469862flunks
fucks144419252fucks
funds94119252funds
funk115825622funk_
funky154315132funky
funs75235732fun_s
ginks104319562ginks
gucks123917302gucks
gunk95423572gunk_
gunky135514112gunky
guns55533482gun_s
hanks126226862hanks
honks125124522honks
hucks144322172hucks
hulks125715482hulks
hunk116029542hunk_
hunky155417732hunky
huns76136932hun_s
hunts86826172hunts
husks125015452husks
inks86926502_inks
jinks165019332jinks
junk155121032junk_
junky194513232junky
kinks84926082kinks
konks84917112konks
links96430192links
lucks115723562lucks
lunas55025012lunas
lunes55337772lunes
lungs65223882lungs
lunk86030722lunk_
lunts55826902lunts
lurks95218742lurks
minks115829272minks
monks116123392monks
mucks134622642mucks
munis75022002munis
muns65535922mun_s
murks114821732murks
musks116119642musks
nuns45228232nun_s
oinks94819912oinks
packs135528932packs
paiks114719852paiks
panes76148692panes
pangs84628662pangs
pans65855732pan_s
pants76536922pants
parks116134462parks
peaks114825622peaks
pecks135724432pecks
peeks115021112peeks
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
perks115325802perks
picks135226142picks
pinas75434452pinas
pines76048862pines
pings85830882pings
pink107039382pink_
pinko115618252pinko
pinkos125313872pinkos
pinky145823402pinky
pins65558452pin_s
pints75936222pints
planks124116752planks
plinks124913262plinks
plonks124210422plonks
plucks14379732plucks
plunk114514402plunk_
plunky15377952plunky
pocks135022962pocks
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
porks115124142porks
pounds93714382pounds
pranks124814722pranks
prinks124315382prinks
prunes83419062prunes
prunus8399362prunus
pubes94423402pubes
pubis94616472pubis
pubs85029212pu_bs
puces94924632puces
puck124927942puck_
pucka133412802pucka
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
puke105025462pu_ke
pukes114523022pukes
pukka10457132pukka
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
pumas95121562pumas
pumps115520602pumps
pun58846512pun__
puna65331652pun_a
punch125118422punch
pung75429632pun_g
punish111411502punish
punji1438202punji
punjis1536692punjis
punkah15347092punkah
punkahs16284782punkahs
punker123718822punker
punkers133714852punkers
punkest132611692punkest
punkey154011172punkey
punkeys16366492punkeys
punkie123513612punkie
punkies134216802punkies
punkin123611522punkin
punkins133111112punkins
punkish16257692punkish
punny104217712punny
punt65747202pun_t
punto75121322punto
puntos85915792puntos
punty106021612punty
puny95526992pun_y
pupas95219282pupas
pups86032232pu_ps
pupus94614042pupus
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
pus55547842pu__s
puses75532202puses
puss64830132pu_ss
puts65641752pu_ts
putts75719272putts
ranks95225732ranks
rinks94827102rinks
rucks114422052rucks
runes55530222runes
rungs611819402rungs
runs46438082run_s
runts55927632runts
rusks95816192rusks
sinks95529182sinks
skunks9468162skunks
spanks124514122spanks
spunk114513402spunk_
spunky15427162spunky
sucks114523072sucks
suks85927122su_ks
sulks94818462sulks
sunk85031812sunk_
sunns55017352sunns
suns45841902sun_s
tanks94624732tanks
thunks13459032thunks
trunks10429752trunks
tucks114721122tucks
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
turks95320822turks
tusks94915532tusks
uns35936762_un_s
wanks126124482wanks
winks125325432winks
wonks124818342wonks
yanks125316572yanks
yucks144717192yucks
yuks116418022yu_ks
zonks184815172zonks

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.313570897.8
2DLD Change Limit538002301.48336277.8
3Display Results2302300.0633650.8
 (SQL Overall)1786912301.85996122.1
 
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.