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

344 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
gun4724080(None) 
bun56348141bun
dun46545581dun
fun66841141fun
gan48060131gan
gaun56427711gaun
gen45950511gen
gin46055751gin
gnu45522041gnu
guan55325581guan
gul45832791gul
gum67439531gum
gunk95423571gunk
guns55533481guns
gut46753851gut
guv74523171guv
guy75728941guy
hun65844711hun
jun105932061jun
mun56143861mun
nun35537741nun
pun58846511pun
run36244991run
sun37149031sun
tun35845191tun
un28341141_un
agin56132712agin
agon56531882agon
ague55725922ague
ain37579092ain
an211879082_an
auk76234142auk
aunt46553652aunt
awn68035912awn
ban58366842ban
begun85113442begun
ben56554922ben
bin56658642bin
bub76343982bub
bud67041272bud
bug65340742bug
bum75342692bum
buna64730722buna
bund75530662bund
bung75730632bung
bunk105731352bunk
bunn65023652bunn
buns66243722buns
bunt65850852bunt
bur55744692bur
burn65636432burn
bus56950972bus
but55963022but
buy86436542buy
can57760142can
con510268022con
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cunt66243672cunt
cup76738242cup
cur56841982cur
curn66731892curn
cut57957662cut
dan46859672dan
den47554342den
din46459462din
don46757652don
dub66642202dub
dud56737592dud
due45249862due
dug58138692dug
duh77930382duh
dui46433382dui
dune56137582dune
dung66328432dung
dunk96228572dunk
duns55140432duns
dunt55746872dunt
duo48536142duo
dup67637882dup
durn56127632durn
en28052392_en
eon36052082eon
ern35738362ern
fan67158862fan
faun76226622faun
fen66851352fen
fin66458032fin
fon66352272fon
fub86337392fub
fud76335152fud
fug76234512fug
fund85624982fund
funk115825622funk
funs75235732funs
fur66637322fur
gab67155992gab
gad57556652gad
gae46457702gae
gaen57329602gaen
gag57753632gag
gain56042162gain
gal46055512gal
gam67060062gam
gane55145302gane
gang66031982gang
gap67055612gap
gar47259902gar
gas48870252gas
gat46880512gat
gaud67025432gaud
gaum75726422gaum
gaunt65430402gaunt
gaur56723352gaur
gay76856492gay
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gene56237222gene
gens55740072gens
gent56954392gent
genu55929072genu
get47467462get
geum75424552geum
gey75738302gey
ghi77019882ghi
gib66443532gib
gid57047272gid
gie47149542gie
gien56330022gien
gig56040752gig
gink97129522gink
gins55543952gins
gip67645362gip
girn56026862girn
git46266052git
glen56027202glen
glue55628492glue
glug66118012glug
glum75825102glum
gluon6311222gluon
glut56331292glut
gnus56518002gnus
go38748742g_o
goa47343802goa
gob68950892gob
god57449792god
gone55639042gone
gong66827192gong
goo47754772goo
goon57236172goon
gor47848262gor
gos47155132gos
got49870442got
gout56646002gout
gown85724072gown
gox117137182gox
goy77844552goy
gran56335012gran
grin55733722grin
grub77220082grub
grue55825712grue
grum75625082grum
grunt65523542grunt
guano69213982guano
guans64419442guans
guar56923292guar
guck114922532guck
gude65423332gude
guff114624932guff
guid66022822guid
gulf84929422gulf
gull54828452gull
gulp75521362gulp
guls55930852guls
gums75030942gums
gunks104517722gunks
gunky135514112gunky
gunny94413662gunny
guru54623912guru
gush85424002gush
gust55240702gust
guts56637252guts
guvs85816812guvs
guys85019642guys
gym95719062gym
gyp98319012gyp
hen67555272hen
hin67559562hin
hon67759382hon
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
hup86437812hup
hut66457292hut
in28150862_in
inn36727432inn
ion36051022ion
jin106443932jin
jug115529542jug
junk155121032junk
jus106930222jus
jut105944012jut
ken76343982ken
kin76353972kin
kue76631862kue
kuna85120702kuna
kune85424572kune
lin37967372lin
lug46138062lug
lum55542932lum
luna46229852luna
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
luv67125772luv
lux106528772lux
man57465872man
maun65727212maun
men59252852men
mon57561582mon
mu46737482mu_
mud67336862mud
mug65837692mug
mum76643612mum
muni65824412muni
muns65535922muns
muon65722732muon
mus55946752mus
mut58357182mut
nan37854882nan
noun45724182noun
nu26331952nu_
nub56439142nub
nuns45228232nuns
nus37939392nus
nut36651962nut
on28057182_on
oud47439072oud
our36042892our
out38072152out
own66429702own
pan58466452pan
pen56558842pen
pin57066722pin
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
puna65331652puna
pung75429632pung
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
pup76339882pup
pur56840552pur
pus55547842pus
put55759072put
qua124821972qua
quin135823922quin
ran38266622ran
rin36663182rin
rub56342822rub
rue35549262rue
rug46039152rug
ruin47430512ruin
rum56644642rum
rune45236302rune
rung56429982rung
runs46438082runs
runt46647992runt
rut35560522rut
sen36058522sen
shun75122772shun
sin36265892sin
son37761952son
spun66221462spun
stun45623452stun
sub55445552sub
sue35651462sue
suk75632972suk
sum56346012sum
sung55832172sung
sunk85031812sunk
sunn45423592sunn
suns45841902suns
sup57041942sup
suq126228992suq
syn67024122syn
tan37167582tan
ten35856112ten
tin36362172tin
ton310265102ton
tub55640032tub
tug45937402tug
tui37034022tui
tuna45127842tuna
tune45635862tune
tung55328172tung
tuns45138662tuns
tup56037542tup
turn46330392turn
tut36758092tut
tux105426572tux
ugh76520682ugh
uh57429852_uh
um47338832_um
uns35936762_uns
up47832822_up
urn35731472urn
us26937432_us
ut28647032_ut
van66246332van
vug76127412vug
vum85428652vum
wan66761942wan
wen66249602wen
win66456292win
won66252062won
wud76227152wud
wyn95921442wyn
xu96018832xu_
yen66847382yen
yin67648732yin
yon67348952yon
yuan76120012yuan
yuk106725602yuk
yum86132822yum
yup86031702yup
zin125643772zin
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.250714764.0
2DLD Change Limit140843440.40334947.9
3Display Results3443440.0635460.3
 (SQL Overall)1786913440.716249568.4
 
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.