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

232 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
buna6473072(None) 
bun56348141bun_
bunas75126571bunas
bund75530661bund
bung75730631bung
bunk105731351bunk
bunn65023651bunn
buns66243721buns
bunt65850851bunt
bunya103810091bunya
bura66139531bura
kuna85120701kuna
luna46229851luna
puna65331651puna
tuna45127841tuna
ana39559822_ana
anna45529012anna
aunt46553652aunt
aura45836252aura
ba49962342b__a
baa510650422b_aa
baba88828352baba
ban58366832ban_
banal75925992banal
band76740902band
banda85223102banda
bane65250422bane
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bean66443862bean
bema85825252bema
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bent67759912bent
beta66234132beta
bima86723832bima
bin56658642bin_
binal75323822binal
bind76234512bind
bine66650862bine
bins66548252bins
bint67355042bint
blunt75525022blunt
boa56954032b_oa
bola66035562bola
bond75334362bond
bone65949322bone
bong75633412bong
bonk105531712bonk
bony96732082bony
bora66141632bora
bota66236502bota
bound84819582bound
bra56339462b_ra
bran65740382bran
brung84613912brung
brunt75728752brunt
bub76343982bu_b
bubal94218212bubal
bubba84311802bubba
bubo85621912bubo
bubs86235502bubs
bubu85022672bubu
buck125129902buck
bud67041272bu_d
buds75235172buds
buff125229862buff
bug65340742bu_g
bugs76035912bugs
buhl95518222buhl
buhr95315382buhr
bulb85626692bulb
bulk105426152bulk
bull65634872bull
bulla74620562bulla
bum75342692bu_m
bumf116126512bumf
bump106228242bump
bums85934592bums
bunch125118602bunch
bunco94616082bunco
bunds85523542bunds
bundt85824852bundt
bungs85323862bungs
bunko115514512bunko
bunks115125082bunks
bunns74718292bunns
bunny104715802bunny
bunts75729802bunts
bunyas11359432bunyas
buoy95921782buoy
bur55744692bu_r
buran75225302buran
buras74736292buras
burb85334672burb
burd75534262burd
burg74930362burg
burka114617692burka
burl64937182burl
burn65636422burn
burns74926772burns
burnt75230322burnt
burp85028882burp
burqa165013092burqa
burr65631232burr
burs65847422burs
bursa74921522bursa
bury95633592bury
bus56950972bu_s
bush96630712bush
busk105429222busk
buss65134912buss
bust65947782bust
busy94727172busy
but55963022bu_t
bute66739672bute
buts67247692buts
butt65143742butt
buy86436542bu_y
buys95726792buys
buzz146617802buzz
bwana10310242bwana
cunt66243672cunt
dona55529632dona
duma75524452duma
dun46545582dun_
dunam8313732dunam
dune56137582dune
dung66328432dung
dunk96228572dunk
duns55140432duns
dunt55746872dunt
dura55232112dura
etna46415262etna
fauna84816512fauna
fun66841142fun_
fund85624982fund
funk115825622funk
funs75235732funs
guan55325582guan
gun47240802gun_
gunk95423572gunk
guns55533482guns
hula74923752hula
hun65844712hun_
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
juba134916982juba
juga126417322juga
jun105932062jun_
junk155121032junk
junta123713672junta
jura116024892jura
kana85928522kana
kina85631992kina
kune85424572kune
luma65527522luma
lunar57017312lunar
lunas55025012lunas
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
mana65341942mana
mina65136912mina
mun56143852mun_
muni65824402muni
muns65535912muns
mura65633292mura
myna95815292myna
na28652482__na
nana46632892nana
nona46929062nona
nun35537742nun_
nuns45228232nuns
pina65842632pina
puja135714922puja
pula65129372pula
puma85424122puma
pun58846512pun_
punas74826752punas
pung75429632pung
punk105729972punk
punka114515482punka
puns66641482puns
punt65747202punt
puny95526992puny
pupa85422812pupa
qua124821972qu_a
ruana5312422ruana
ruga56121232ruga
run36244982run_
rune45236292rune
rung56429972rung
runs46438072runs
runt46647982runt
sauna54117552sauna
suba64926602suba
sun37149032sun_
sung55832172sung
sunk85031812sunk
sunn45423592sunn
sunna55016062sunna
suns45841902suns
sura45740292sura
tuba65422362tuba
tufa75016612tufa
tun35845192tun_
tunas54224122tunas
tune45635862tune
tung55328162tung
tuns45138662tuns
ulna46317322ulna
un28341132_un_
unai44824782_unai
unau43924152_unau
uns35936752_uns
uta37425582_uta
vena76126292vena
vina76331802vina
yuan76120012yuan
yuca95716722yuca
yuga85615422yuga
zona136321962zona

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.0602978183.3
2DLD Change Limit298722320.97030795.9
3Display Results2322320.0465043.5
 (SQL Overall)1786912321.076166069.7
 
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.