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

260 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
bund7553066(None) 
band76740901band
bend76435261bend
bind76234501bind
bond75334361bond
bound84819581bound
bud67041271bu_d
bun56348141bun_
buna64730721buna
bunds85523541bunds
bundt85824851bundt
bung75730631bung
bunk105731351bunk
bunn65023651bunn
buns66243721buns
bunt65850851bunt
burd75534261burd
fund85624981fund
abound9239862abound
and47244162_and
auld54125362auld
aunt46553652aunt
bad67763152b_ad
bald76432902bald
ban58366832ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250422bane
baned85436352baned
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bead75937922bead
bed67950622b_ed
ben56554922ben_
bends85628972bends
bendy115017252bendy
bene66439492bene
bens65945702bens
bent67759912bent
bid67751782b_id
bin56658632bin_
bindi85617012bindi
binds86627472binds
bine66650852bine
bins66548242bins
bint67355032bint
bird76128312bird
bland85320452bland
bled75729312bled
blend85317452blend
blind86319322blind
blond85618372blond
blued84520322blued
blunt75525022blunt
bod67055542b_od
bold75432812bold
bonds86126842bonds
bone65949322bone
boned85133242boned
bong75633412bong
bonk105531712bonk
bony96732082bony
bounds94415802bounds
brad75234342brad
brand85124492brand
bred75130972bred
brung84613912brung
brunt75728752brunt
bub76343972bu_b
bubo85621902bubo
bubs86235492bubs
bubu85022662bubu
buck125129902buck
buddy124812632buddy
buds75235172buds
buff125229852buff
bug65340742bu_g
bugs76035912bugs
buhl95518222buhl
buhr95315382buhr
build84413352build
bulb85626692bulb
bulk105426152bulk
bull65634872bull
bum75342692bu_m
bumf116126502bumf
bump106228242bump
bums85934592bums
bunas75126572bunas
bunch125118602bunch
bunco94616082bunco
bundle94315572bundle
bundts95010842bundts
bunged105218792bunged
bungs85323862bungs
bunked135118372bunked
bunko115514512bunko
bunks115125082bunks
bunns74718292bunns
bunny104715802bunny
bunted95219182bunted
bunts75729802bunts
bunya103810092bunya
buoy95921782buoy
bur55744692bu_r
bura66139532bura
burb85334672burb
burds84626062burds
burg74930362burg
burl64937182burl
burn65636422burn
burned95818962burned
burns74926772burns
burnt75230322burnt
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
bus56950972bu_s
bused85624492bused
bush96630712bush
busk105429222busk
buss65134912buss
bust65947782bust
busy94727172busy
but55963022bu_t
bute66739672bute
buts67247692buts
butt65143742butt
buy86436542bu_y
buys95726792buys
buzz146617802buzz
cud67937452cu_d
cued76329562cued
cunt66243672cunt
curd77634982curd
duad66521412duad
dud56737592du_d
dun46545582dun_
dune56137582dune
dung66328432dung
dunk96228572dunk
duns55140432duns
dunt55746872dunt
end46834352_end
fend84832972fend
find87532602find
fond86330952fond
found94917842found
fud76335152fu_d
fun66841142fun_
fundi96814912fundi
funds94119252funds
funk115825622funk
funs75235732funs
guid66022822guid
gun47240802gun_
gunk95423572gunk
guns55533482guns
hand86833702hand
hind85529752hind
hound95016482hound
hued86925852hued
hun65844712hun_
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
jun105932062jun_
junk155121032junk
kind96128552kind
kuna85120702kuna
kune85424572kune
land56337302land
lend56233672lend
luna46229852luna
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
maund85515442maund
mend75334022mend
mind75434362mind
mound83918312mound
mud67336862mu_d
mun56143852mun_
muni65824402muni
muns65535912muns
nun35537742nun_
nuns45228232nuns
nurd56224342nurd
obtund945582obtund
oud47439072ou_d
pend75934532pend
pond75530492pond
pound84417862pound
pud65836652pu_d
pun58846512pun_
puna65331652puna
pung75429632pung
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
quad144618702quad
quid144922352quid
quod145413622quod
rand55839562rand
rend56136572rend
rind56535602rind
round64318432round
rudd65917472rudd
rued55729792rued
run36244982run_
rune45236292rune
rung56429972rung
runs46438072runs
runt46647982runt
rynd86414102rynd
sand55338462sand
send55237292send
sound64420022sound
sudd64719772sudd
sued56537932sued
sun37149032sun_
sung55832172sung
sunk85031812sunk
sunn45423592sunn
suns45841902suns
surd56433812surd
tend56433772tend
tun35845192tun_
tuna45127842tuna
tune45635862tune
tuned64622312tuned
tung55328162tung
tuns45138662tuns
turd56027622turd
un28341132_un_
unde55825482_unde
undo55620152_undo
undy85015162_undy
uns35936752_uns
urd46427042_urd
vend86626422vend
wand85833872wand
wend85330452wend
wind85533852wind
wound94414212wound
wud76227152wu_d
wynd116114462wynd
yond86122312yond

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.0802233637.5
2DLD Change Limit298722600.92032469.6
3Display Results2602600.0634127.0
 (SQL Overall)1786912601.063168100.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.