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

202 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
punas7482675(None) 
bunas75126571bunas
lunas55025011lunas
pinas75434451pinas
pujas145513321pujas
pumas95121561pumas
puna65331651puna_
pungs85422221pungs
punkas123410671punkas
punks114822681punks
puns66641481pun_s
punts75828001punts
pupas95219281pupas
tunas54224121tunas
anas46649862_anas
annas55824882annas
aunts55227632aunts
auras55932552auras
buna64730722buna_
bunds85523542bunds
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
bunyas11359432bunyas
buras74736292buras
cunts76125122cunts
donas65926472donas
dumas85420432dumas
dunam8313732dunam
dunams937832dunams
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunts65828412dunts
duras65727722duras
etnas54713932etnas
faunas94013632faunas
funds94119252funds
funks125318912funks
funs75235732fun_s
guans64419442guans
gunks104517722gunks
guns55533482gun_s
hulas84920882hulas
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
jubas144614222jubas
judas134911882judas
junks164815972junks
juntas134210502juntas
kanas95326912kanas
kinas95626912kinas
kuna85120702kuna_
lumas75622912lumas
luna46229852luna_
lunar57017312lunar
lunars65012812lunars
lunes55337772lunes
lungs65223882lungs
lunks94822452lunks
lunts55826902lunts
manas76240422manas
minas75434112minas
monas74732152monas
munis75022002munis
muns65535912mun_s
muras75329562muras
mynas105815232mynas
nanas55928632nanas
nonas55126652nonas
nuns45228232nun_s
pacas96029402pacas
pandas95521962pandas
panes76148692panes
pangas99921102pangas
pangs84628662pangs
pans65855722pan_s
pants76536922pants
papas94927492papas
paras76143042paras
pas58775742p__as
peans75437642peans
peas65755062p_eas
penal75228372penal
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
pians75126962pians
pias66542552p_ias
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pina65842632pina_
pines76048862pines
pings85830882pings
pinks115729382pinks
pinnas85315512pinnas
pins65558452pin_s
pintas85021392pintas
pints75936222pints
pitas77427672pitas
plans75731272plans
pleas75627032pleas
plunks124711162plunks
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
pounds93714382pounds
proas75028802proas
prunes83419062prunes
prunus8399362prunus
psoas75012982psoas
pubes94423402pubes
pubis94616472pubis
pubs85029212pu_bs
puces94924632puces
pucks134322102pucks
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
puja135714922puja_
pujah17478542pujah
pujahs18404942pujahs
pukes114523022pukes
pula65129372pula_
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
puma85424122puma_
pumps115520602pumps
pun58846512pun__
punch125118422punch
pung75429632pun_g
punish111411502punish
punji1438202punji
punjis1536692punjis
punk105729972pun_k
punka114515482punka
punkah15347092punkah
punkahs16284782punkahs
punky144419392punky
punny104217712punny
punt65747202pun_t
punto75121322punto
puntos85915792puntos
punty106021612punty
puny95526992pun_y
pupa85422812pupa_
pupae96515642pupae
pupal97616872pupal
pups86032232pu_ps
pupus94614042pupus
puranas9712642puranas
purdas92612262purdas
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
pus55547842pu__s
puses75532202puses
puss64830132pu_ss
puts65641752pu_ts
putts75719272putts
pyas96225702p_yas
ruanas6311262ruanas
runes55530222runes
rungs611819402rungs
runs46438072run_s
runts55927632runts
saunas63915432saunas
spunks12349332spunks
subas74724072subas
sunnas63914562sunnas
sunns55017352sunns
suns45841902sun_s
suras55336322suras
tubas75119572tubas
tufas85314382tufas
tuna45127842tuna_
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
ulnas55716532ulnas
unai44824782_unai
unais53420772_unais
unau43924152_unau
unaus53216572_unaus
uns35936752_un_s
upas68322382_upas
utas45924952_utas
vinas85126342vinas
yuans84613322yuans
yucas106013912yucas
yugas95012062yugas

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.0931921408.6
2DLD Change Limit538002021.76630464.3
3Display Results2022020.0633206.3
 (SQL Overall)1786912021.92292971.4
 
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.