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

247 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
bung7573063(None) 
bang74836991bang
bong75633411bong
brung84613911brung
bug65340741bu_g
bun56348141bun_
buna64730721buna
bund75530661bund
bungs85323861bungs
bunk105731351bunk
bunn65023651bunn
buns66243721buns
bunt65850851bunt
burg74930361burg
dung66328431dung
hung86126351hung
lung55732491lung
pung75429631pung
rung56429971rung
sung55832171sung
tung55328161tung
aunt46553652aunt
bag67059222b_ag
ban58366832ban_
band76740902band
bane65250422bane
bangs85627772bangs
bani65334952bani
bank105835742bank
bans66555132bans
beg65944132b_eg
being84920502being
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bent67759912bent
berg75425542berg
bhang115512922bhang
big67345712b_ig
bin56658632bin_
bind76234502bind
bine66650852bine
binge85125512binge
bingo86020092bingo
bins66548242bins
bint67355032bint
biog76122312biog
blog75723822blog
bluing94914482bluing
blunge94311482blunge
blunt75525022blunt
bog67852412b_og
boing84725552boing
bond75334362bond
bone65949322bone
bongo85720942bongo
bongs87828422bongs
bonk105531712bonk
bony96732082bony
bound84819582bound
bourg84113842bourg
brag75229722brag
brig76528032brig
bring85528502bring
brunt75728752brunt
bub76343972bu_b
bubo85621902bubo
bubs86235492bubs
bubu85022662bubu
buck125129902buck
bud67041272bu_d
budge94619872budge
buds75235172buds
buff125229852buff
buggy124613482buggy
bugs76035912bugs
buhl95518222buhl
buhr95315382buhr
bulb85626692bulb
bulge86419872bulge
bulgy115214102bulgy
bulk105426152bulk
bull65634872bull
bum75342692bu_m
bumf116126502bumf
bump106228242bump
bums85934592bums
bunas75126572bunas
bunch125118602bunch
bunco94616082bunco
bunds85523542bunds
bundt85824852bundt
bunged105218792bunged
bungee96319772bungee
bungle97116112bungle
bunko115514512bunko
bunks115125082bunks
bunns74718292bunns
bunny104715802bunny
bunts75729802bunts
bunya103810092bunya
buoy95921782buoy
bur55744692bu_r
bura66139532bura
burb85334672burb
burd75534262burd
burgh115216032burgh
burgs84924092burgs
burl64937182burl
burn65636422burn
burns74926772burns
burnt75230322burnt
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
bus56950972bu_s
bush96630712bush
busing96420592busing
busk105429222busk
buss65134912buss
bust65947782bust
busy94727172busy
but55963022bu_t
bute66739672bute
buts67247692buts
butt65143742butt
buy86436542bu_y
buying124213832buying
buys95726792buys
buzz146617802buzz
clung86013602clung
cuing85420192cuing
cunt66243672cunt
dang65131532dang
ding66940952ding
dong66031652dong
dug58138692du_g
dun46545582dun_
dune56137582dune
dungs75821972dungs
dungy104713642dungy
dunk96228572dunk
duns55140432duns
dunt55746872dunt
eng46726782_eng
fang85432542fang
flung95114582flung
fug76234512fu_g
fun66841142fun_
fund85624982fund
fungi95014132fungi
fungo94413132fungo
funk115825622funk
funs75235732funs
gang66031962gang
gong66827192gong
gun47240802gun_
gunk95423572gunk
guns55533482guns
hang85535542hang
hong85833952hong
hug76037362hu_g
hun65844712hun_
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
jug115529542ju_g
jun105932062jun_
junk155121032junk
king95933652king
kuna85120702kuna
kune85424572kune
lang56637372lang
ling57447962ling
long56933342long
lug46138062lu_g
luna46229852luna
lune47140492lune
lunge65323802lunge
lungi65516052lungi
lungs65223882lungs
lunk86030722lunk
lunt46148842lunt
luny77324132luny
mug65837692mu_g
mugg86316012mugg
mun56143852mun_
mungo84916052mungo
muni65824402muni
muns65535912muns
nun35537742nun_
nuns45228232nuns
pang75336282pang
ping75943592ping
pong76231142pong
pug65337182pu_g
pun58846512pun_
puna65331652puna
pungs85422222pungs
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
quag144815942quag
rang56939152rang
ring56541152ring
rug46039152ru_g
ruing67221052ruing
run36244982run_
rune45236292rune
rungs611819402rungs
runs46438072runs
runt46647982runt
sang55441222sang
sing57544172sing
slung65117832slung
snug55218692snug
song55133672song
stung65417152stung
suing65026362suing
sun37149032sun_
sunk85031812sunk
sunn45423592sunn
suns45841902suns
swung95610562swung
tang56138662tang
ting56139892ting
tong56434352tong
tug45937402tu_g
tun35845192tun_
tuna45127842tuna
tune45635862tune
tungs65520622tungs
tuns45138662tuns
un28341132_un_
uns35936752_uns
vang84926032vang
vug76127412vu_g
vugg95612712vugg
wing86339222wing
wrung9549802wrung
yang85626062yang
young977742young
zing145728612zing

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 Filter178691298720.1231452772.4
2DLD Change Limit298722470.98630296.1
3Display Results2472470.0932655.9
 (SQL Overall)1786912471.202148661.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.