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

289 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
bonds8612684(None) 
bands85233421bands
bends85628971bends
binds86627471binds
blonds95213341blonds
bods76244711bo_ds
bolds85825281bolds
bond75334361bond_
bones76446531bones
bongs87828421bongs
bonks116326461bonks
bonus75324321bonus
bounds94415801bounds
bunds85523541bunds
fonds95824821fonds
ponds85323401ponds
abounds10217082abounds
ands57833612_ands
bads77048862b_ads
balds85524642balds
band76740912band_
banda85223102banda
bandas95120542bandas
bandy114824182bandy
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555142ban_s
bards87139642bards
bauds85821042bauds
bawds116115492bawds
beads85429502beads
beds75937782b_eds
bend76435262bend_
bendy115017252bendy
bendys12518382bendys
benes75536232benes
bens65945702ben_s
bents76033692bents
beyonds1335062beyonds
bids75838452b_ids
bind76234512bind_
bindi85617012bindi
bindis94614582bindis
bines76946792bines
bins66548252bin_s
bints76130182bints
bionts8612392bionts
birds85421332birds
blends96012882blends
blinds95111612blinds
blond85618372blond_
blonde94813292blonde
blondes104213162blondes
bloods94614842bloods
boards94616932boards
boars75229602boars
boas66150832bo_as
boats75635152boats
bobs86340652bo_bs
bocks134526572bocks
bod67055542bo_d_
bode75838752bo_de
bodes84935102bodes
body107425672bo_dy
boffs134915502boffs
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boils75427192boils
boings96416872boings
boinks125211272boinks
bolas74733762bolas
bold75432812bold_
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bombs115818822bombs
bonded104719952bonded
bonder95324782bonder
bonders104120662bonders
bonduc1136602bonduc
bonducs1235552bonducs
bone65949322bon_e
boned85133242boned
boner75133082boner
boners84825432boners
boney105227312boney
bong75633412bon_g
bongo85720942bongo
bongos95316652bongos
bonk105531712bon_k
bonne75124712bonne
bonnes85621452bonnes
bonny105816622bonny
bony96732082bon_y
bonze165119352bonze
bonzes175116102bonzes
boobs96221992boobs
boody115420402boody
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
bops86037982bo_ps
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
botas75328782botas
bots66453952bo_ts
botts75224862botts
bound84819582bound_
bouts75131312bouts
bovids1287972bovids
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brads85528292brads
brands95118942brands
broads94515152broads
broncs101611152broncs
broods95416382broods
buds75235172b_uds
bunas75126572bunas
bund75530662bund_
bundt85824852bundt
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
burds84626062burds
cods76848102co_ds
coeds85920162coeds
colds85726972colds
condo85322592condo
condos94322332condos
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692con_s
conus76726532conus
cords86030622cords
donas65926472donas
dongs76525812dongs
dons56048702don_s
ebons74316092ebon_s
ends56528522_ends
eons46638712eon_s
fends96324972fends
finds95424822finds
folds95221692folds
fond86330952fond_
fondu96013972fondu
fondus105210942fondus
fons76943892fon_s
fonts86124752fonts
foods95924162foods
fords95328182fords
founds104814192founds
fronds106412342fronds
funds94119252funds
goads77022852goads
gods65438042go_ds
golds75421312golds
gonads84511732gonads
gongs74921612gongs
goods75124482goods
gowds105814042gowds
hands95327382hands
hinds96721472hinds
hods87239862ho_ds
holds94623242holds
honda9414982honda
hondas10313352hondas
hones88144492hones
hongs95126202hongs
honks125124522honks
hons77350782hon_s
hoods95124082hoods
hounds104413132hounds
ions46737852ion_s
jones125028182jones
kinds106221822kinds
konks84917112konks
lands65426902lands
lends65326252lends
loads65323372loads
loids66220702loids
longs65527062longs
lords64923502lords
mends84927692mends
minds85427122minds
mods77945052mo_ds
molds85324832molds
monads94515302monads
monas74732152monas
monde85723142monde
mondes94322352mondes
mondo85721232mondo
mondos95217332mondos
monks116123392monks
monos75930862monos
mons68152262mon_s
moods85224622moods
mounds93915132mounds
nods55838222no_ds
nonas55126652nonas
nones55639132nones
odds68919922_odds
ods47546212_o_ds
olds55926572_olds
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onus45826812_onus
ouds56430102_ouds
pends85527192pends
pods76540152po_ds
poinds93511142poinds
pond75530492pond_
pones74547042pones
pongs85526342pongs
pons65850602pon_s
poods85124752poods
pounds93714382pounds
rands65930452rands
rends65129952rends
rinds64826142rinds
roads66523622roads
rods56442062ro_ds
rondo65218372rondo
rondos74616732rondos
roods65125282roods
rounds73615622rounds
rynds9569972rynds
sands65228582sands
sends65528242sends
sods54940212so_ds
sonde64622832sonde
sondes74922872sondes
sones55444142sones
songs67725552songs
sons46049552son_s
sords64527802sords
sounds74616182sounds
tends65425582tends
toads65621072toads
tods56141842to_ds
tondi65716142tondi
tondo69718682tondo
tondos75115922tondos
tones56048662tones
tongs65928462tongs
tons46553052ton_s
tonus56324302tonus
vends95520892vends
voids95414672voids
wands96425482wands
wends95822812wends
winds95425602winds
woads94818442woads
wolds95420182wolds
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
woods95723032woods
words95425072words
wounds103811632wounds
wynds126310372wynds
yods86531182yo_ds
yond86122312yond_
yonis85020822yonis
zones145528042zones
zonks184815172zonks
zounds164310172zounds

Search took 3 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.296603685.8
2DLD Change Limit538002891.70331591.3
3Display Results2892890.0763802.6
 (SQL Overall)1786912892.07586116.1
 
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.