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 “bostons” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

397 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
bostons931290(None) 
bosons85016651bos_ons
boston8513041boston_
boutons9310781boutons
basions94213952basions
bastions10411692bastions
batons85519422b_atons
bestows1248862bestows
betons84919552b_etons
bisons83914372bis_ons
bolsons969482bolsons
bonbons1139332bonbons
boons75031912bo__ons
borons85520542bo_rons
bosoms104913052bos_oms
boson76019732bos_on_
bosuns8439382bos_uns
bottoms1136992bottoms
bouton8311532bouton_
burtons9310852burtons
buttons9310332buttons
cottons9312192cottons
moutons9410312moutons
nostocs947552nostocs
pistons93016372pistons
pontons93315552pontons
postins93721202postins
postops11311712postops
testons7313562testons
wontons103310532wontons
abortions1147783abortions
arsons63917213ars_ons
astony9510523_astony
baboons113211083baboons
bacons104917583b_acons
ballons93916963ballons
barons85025383b_arons
baryons121010473baryons
barytons1345573barytons
basins85722763bas_ins
basion84315853basion_
bassoons1036553bassoons
bassos85313703basso_s
basters94930313basters
bastes85330383bast_es
basting104227203basting
bastings114214693bastings
bastion9312473bastion_
basts75936933bast__s
baton75822423b_aton_
battens95313263battens
beacons11410733beacons
beckons15279143beckons
belons84119413b_elons
benthons1337973benthons
bentos86218303bento_s
besnows1245153besnows
besoms105712733bes_oms
besots86415453bes_ots
besting104923923besting
bestirs9311133bestirs
bestow1149463besto_w
bestrows1337043bestrows
bests75932613best__s
bestuds10326753bestuds
beton76022063b_eton_
betony114211583b_etony
bettors93312473bettors
bicrons113410473bicrons
billons93013363billons
biltong1034683biltong
biltongs1133813biltongs
biotins93114453biotins
biotrons1037243biotrons
bishops1437033bishops
bison75716983bis_on_
bisters93922613bisters
bistort91216523bistort
bistorts10118813bistorts
bistres94017213bistres
bistros92810983bistros
blazons1836163blazons
blossoms12134553blossoms
blousons1054403blousons
boasters103915663boasters
boasting113512503boasting
boasts85017923boast__s
boatels93510233boatels
boaters93419243boaters
boating103721303boating
boatings113710113boatings
boats75635153boat__s
bobbins103410343bobbins
bobstays1543343bobstays
bodkins1438313bodkins
boffins15329073boffins
boffos14568193boffo_s
bogans95714813bo_gans
bohos105618253bo_ho_s
boites84322703boit_es
bolos75531373bo_lo_s
bolson8410683bolson_
bolsters103712453bolsters
bolters94017803bolters
bolting104416763bolting
boltonia1045513boltonia
boltonias1145123boltonias
bolts76232113bolt__s
bonbon10310073bonbon_
bondstone1275523bondstone
bondstones1375543bondstones
bongoes104314113bongoes
bongos95316653bongo_s
bonitoes1038153bonitoes
bonitos939733bonito_s
booboos1138143booboos
boobs96221993bo__obs
boocoos1137753boocoos
boohoos1237993boohoos
bookoos1337503bookoos
books115729713bo__oks
booms95427123bo__oms
boomtowns1641783boomtowns
boon67142173bo__on_
boors74325013bo__ors
boos67955033bo__o_s
boosters104013453boosters
boosting113311053boosting
boosts86115013boost__s
bootees94114473bootees
booths115313793boot_hs
booties94124613booties
booting103821363booting
boots75837973bo__ots
boreens9310403boreens
boron76727143bo_ron_
borrows12349263borrows
borstals1037473borstals
borts76735453bort__s
bortzes1838223bortzes
borzois1835833borzois
boshboks1943413boshboks
boshes114721883bos_hes
boskets13409473boskets
bosks115218853bos__ks
bosom95516923bos_o_m
bosomy13509033bos_omy
bosonic1139213bos_onic
bosques18217973bosques
boss65938343bos___s
bossdoms1343733bossdoms
bosses85925403bos_ses
bossies94116833bossies
bossing103714603bossing
bosun75113593bos_un_
botany1139263bo_tany
botas75328783bo_t_as
botels84815803bo_tels
botonee9311833bo_tonee
bots66453953bo_t__s
bottles94216273bottles
bottom1048723botto_m
botts75224863bo_t_ts
boubous1138693boubous
boudins10311313boudins
bourbons1245343bourbons
bourdons1136433bourdons
bourns84114063bo_urns
bouts75131313bout__s
bowfins15267703bowfins
bowpots1446023bowpots
bowshots1645103bowshots
bowwows1454123bowwows
boxthorns2143023boxthorns
boyos105418283bo_yo_s
bozos165216863bo_zo_s
bristols1046773bristols
bunions92210473bunions
burstone1057133burstone
burstones1187153burstones
burton8311273burton_
busboys14325023busboys
buskins133310943buskins
busters94724133busters
bustics11810883bustics
busting104221793busting
bustles93816323bustles
busts75227693bust__s
button8310273button_
buttony1236173buttony
cantons95221203cantons
cartons94122473cartons
castors94919443castors
cestos84718093cesto_s
chitons122611913chitons
cistrons102710643cistrons
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
coitions10312853coitions
colons86028683co_lons
commons13311043commons
contos84923233conto_s
coons76737283co__ons
cordons104415763cordons
cortins92421333cortins
cosigns1047513cosigns
cosmos10311753cosmo_s
costars94218013costars
costers94128343costers
costing104323023costing
costs77231143cost__s
cotans81317923co_tans
cotton8312993cotton_
cottony1237253cottony
coupons112710563coupons
cratons94316033cratons
crotons93714373crotons
croutons1036753croutons
customs11348263customs
custos84014313custo_s
cytons111710183_cytons
daltons8310403daltons
doblons1037043doblons
dobsons1036203dobsons
doctors1039993doctors
donjons1536733donjons
eosins64419163eos_ins
erosions8310343erosions
estops84011223_estops
fastens105511753fastens
festoons1136443festoons
foetors1039763foetors
foisons1047613foisons
fosters104220103fosters
frontons1136503frontons
fusions1039153fusions
futons93911513_futons
gascons10289103gascons
godsons966663godsons
goons65326773go__ons
gorgons938853gorgons
gossans836783gossans
gossoons944893gossoons
gustoes879873gustoes
hastens106214813hastens
histone10312843histone
histones11312803histones
hostas94515833host_as
hostels103712323hostels
hostess103210243hostess
hosting114318383hosting
hosts85526703host__s
hysons1237633hys_ons
isogons8217613isogons
isotone7239983isotone
isotones82210433isotones
jetons134512613_jetons
jettons1437273jettons
jostles143411143jostles
kotos95717703ko_to_s
kotows13446523ko_tows
kowtows1742763kowtows
leptons91910433leptons
lesions73813873lesions
lessons73811023lessons
listens74014133listens
logions86211293logions
logons79818173lo_gons
loons55731723lo__ons
lotions74614763lotions
lotos54724633lo_to_s
lottos64613103lotto_s
mascons113411583mascons
masons83916513mas_ons
meltons9410923meltons
mesons83215843mes_ons
moistens10268773moistens
monsoons1047343monsoons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
mosts76028543most__s
motions94215003motions
motors84616603mo_tors
mottoes93412193mottoes
mottos84615243motto_s
mouton8410853mouton_
mutons84314363_mutons
muttons949283muttons
nasions73112383nasions
nektons1136393nektons
nestors73614973nestors
neustons836833neustons
newtons1036813newtons
nitons64614903_nitons
nonstops10116883nonstops
noons54125283no__ons
nostoc868193nosto_c
notions74014483notions
octans81411143_octans
odeons739023_odeons
onions64016433_onions
options93810603_options
orlons6411013_orlons
osmols8137313_osmols
osmous8138183_osmous
ostomy1137833_ostomy
ostoses71213553_ostoses
ostosis71310123_ostosis
ottos54714323_otto_s
partons94620513partons
pastors94119003pastors
pestos84719083pesto_s
photons123814433photons
phytons15319063phytons
pistols93213983pistols
piston83515923piston_
pistous92714383pistous
pitons85319043_pitons
plosions1038023plosions
plutons938343plutons
poisons9310353poisons
pompons1338553pompons
ponton83217643ponton_
pontoons10279313pontoons
poons75430973po__ons
portions10514413portions
positions11811503positions
positrons1186543positrons
postals93716383postals
postboys1585273postboys
postdocs1345273postdocs
posteens10309733posteens
posterns102713723posterns
posters93928013posters
posties93128813posties
postin83521033postin_
posting105622243posting
postings112912303postings
postop10511943posto_p
postpone1248693postpone
postpones1348833postpones
posts75228783post__s
potions93417423potions
potstone1039423potstone
potstones1149213potstones
pottos84615873potto_s
protons93118003protons
putons83515153_putons
rattons73815323rattons
rhytons13295883rhytons
ronions73313343ronions
ronyons10258433ronyons
roscoes9310923roscoes
rosins64521863ros_ins
rosters73727553rosters
rotors64917953ro_tors
rotos56027883ro_to_s
setons64620173_setons
sextons143710413sextons
softens10347623softens
solions7513753solions
solitons849593solitons
solons65120023so_lons
sons46049553__s_ons
sotols63714473so_tols
stoas55126023__stoas
stobs75718233__stobs
stone55431183__stone
stones65130033__stones
stony85818643__stony
stops74827283__stops
stoss54316343__stoss
stots54828553__stots
stows86622703__stows
stuns54719493__stuns
teston6313303teston_
testoons837323testoons
tons46553053___tons
toons55027533to__ons
topstone1046883topstone
topstones1147013topstones
torsions839183torsions
tortoni738033tortoni
tortonis848743tortonis
toyons95512133to_yons
tritons73814883tritons
unstops936993unstops
visions10311023visions
voudons1135323voudons
wantons103713013wantons
wonton93410963wonton_
xystos16356913xysto_s
youpons12265983youpons
zoons144919693zo__ons
zosters163015413zosters

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273975.93622578.7
3Display Results3973970.1432776.2
 (SQL Overall)1786913976.48527554.5
 
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.