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

327 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
wontons10331053(None) 
pontons93315551pontons
wantons103713011wantons
wonton93410961wonton_
bonbons1139332bonbons
bostons9312902bostons
boutons9310782boutons
cantons95221202cantons
contos84923232conto_s
cottons9312192cottons
donjons1536732donjons
frontons1136502frontons
moutons9410312moutons
onions64016432_onions
ponton83217642ponton_
pontoons10279312pontoons
ronions73313342ronions
ronyons10258432ronyons
wanions104011372wanions
wanton94413812wanton_
wonting113214102wonting
wonts87621542wont__s
amnions93710913amnions
anions64123033_anions
anyons94513503_anyons
batons85519423_batons
benthons1337973benthons
bentos86218303bento_s
betons84919553_betons
bolsons969483bolsons
bonbon10310073bonbon_
bongoes104314113bongoes
bongos95316653bongo_s
bonitoes1038153bonitoes
bonitos939733bonito_s
boons75031913bo__ons
borons85520543bo_rons
bosons85016653bo_sons
boston8513043boston_
bottoms1136993bottoms
bouton8311533bouton_
bunions92210473bunions
burtons9310853burtons
buttons9310333buttons
cannons94412883cannons
canons85522063can_ons
canton85722993canton_
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
cartons94122473cartons
centones10313663centones
centos85920463cento_s
chitons122611913chitons
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
coitions10312853coitions
colons86028683co_lons
commons13311043commons
conations111318903conations
condoes104319203condoes
condoms124214083condoms
condone102616293condone
condones112817393condones
condors104018573condors
condos94322333condo_s
congoes103617303congoes
congos94219883congo_s
congous103615083congous
conins84327233con_ins
conjoins1738133conjoins
conns75024233con__ns
consols92914073consols
contains10316533contains
contemns1237403contemns
contend103511893contend
contends112810573contends
content94326153content
contents104018213contents
contes84432913cont_es
conto76027173conto__
contort91422343contort
contorts101112643contorts
contour939973contour
contours1039653contours
contras93015623contras
controls10311393controls
convoys15267023convoys
coons76737283co__ons
cordons104415763cordons
cortins92421333cortins
cotans81317923co_tans
cotton8312993cotton_
cottony1237253cottony
coupons112710563coupons
cratons94316033cratons
crotons93714373crotons
croutons1036753croutons
cytons111710183_cytons
daltons8310403daltons
dentins83419223dentins
doblons1037043doblons
dobsons1036203dobsons
doctors1039993doctors
donations101112353donations
donators9310403donators
donjon1436463donjon_
donors75115793don_ors
downtowns1642933downtowns
fanions103713073fanions
fanons96115213fan_ons
fantods11177623fantods
fantoms12189153fantoms
foetors1039763foetors
foisons1047613foisons
fontina1038633fontina
fontinas1136853fontinas
fonts86124753font__s
fronton1037203fronton_
futons93911513_futons
gentoos838633gentoos
gnomons1035753gnomons
godsons966663godsons
gonion73612833gonion_
gonofs10459863gon_ofs
goons65326773go__ons
gorgons938853gorgons
honans94814503hon_ans
honors94816793hon_ors
inions64417003_inions
intone61115433_intone
intones7816543_intones
introns73515023_introns
ionone6313443ion_one
ionones7313883ion_ones
jetons134512613_jetons
jettons1437273jettons
johnsons1842383johnsons
juntos134110843junto_s
kotos95717703ko_to_s
kotows13446523ko_tows
kowtows1742763kowtows
lentos65317403lento_s
leptons91910433leptons
lintols7339553lintols
logions86211293logions
logons79818173lo_gons
longans84510813longans
loons55731723lo__ons
lotions74614763lotions
lotos54724633lo_to_s
lottos64613103lotto_s
meltons9410923meltons
mentions10312893mentions
mentors9314993mentors
minions93314623minions
monaxons1744813monaxons
mondos95217333mondo_s
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monitions11310883monitions
monitors10310823monitors
monos75930863mon_o_s
monotone10310153monotone
monotones11410553monotones
monotony1347073monotony
monsoons1047343monsoons
montane91313623montane
montanes101114523montanes
montes84226933mont_es
months113812933mont_hs
monurons1037093monurons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
motions94215003motions
motors84616603mo_tors
mottoes93412193mottoes
mottos84615243motto_s
mouton8410853mouton_
muntins92715133muntins
mutons84314363_mutons
muttons949283muttons
nektons1136393nektons
neons55818683__neons
newtons1036813newtons
ninons64913773nin_ons
nitons64614903_nitons
nonagons947223nonagons
noncoms1139203noncoms
nonfans1037533nonfans
nonstops10116883nonstops
nontonal849743nontonal
nontonic10410153nontonic
noons54125283__noons
nostocs947553nostocs
notions74014483notions
octans81411143_octans
odeons739023_odeons
onion54320973_onion_
oniony9369703_oniony
onos46229003_on_o_s
onto46127663_onto__
options93810603_options
orlons6411013_orlons
ottos54714323_otto_s
pantos85222743panto_s
partons94620513partons
pennons939713pennons
phonons123310253phon_ons
photons123814433photons
phytons15319063phytons
pinions93413603pinions
pinons86019943pin_ons
pintoes95117713pintoes
pintos86021293pinto_s
pinyons12299003pinyons
pistons93016373pistons
pitons85319043_pitons
plutons938343plutons
poisons9310353poisons
pompons1338553pompons
pontes83627853pont_es
pontils9312213pontils
pontine92419053pontine
pontoon93010703pontoon
poons75430973po__ons
portions10514413portions
postins93721203postins
postops11311713postops
potions93417423potions
pottos84615873potto_s
protons93118003protons
puntos85915793punto_s
putons83515153_putons
rattons73815323rattons
rhytons13295883rhytons
rondos74616733rondo_s
ronion63315643ronion_
rontgens944683rontgens
ronyon9309133ronyon_
rotors64917953ro_tors
rotos56027883ro_to_s
santols73513323santols
santos64421833santo_s
setons64620173_setons
sextons143710413sextons
softens10347623softens
solions7513753solions
solitons849593solitons
solons65120023so_lons
sotols63714473so_tols
sponsons1045813sponsons
spontoons1153403spontoons
suntans72111733suntans
swoons94511143swo__ons
syntony1344523syntony
tendons8311473tendons
tenons62916603ten_ons
testons7313563testons
tondos75115923tondo_s
tons46553053___tons
tontine72316143tontine
tontines82114733tontines
toons55027533to__ons
tortoni738033tortoni
tortonis848743tortonis
toyons95512133to_yons
tritons73814883tritons
unions64216753_unions
voudons1135323voudons
waggons1235503waggons
wagons103911213w_agons
waitrons1136643waitrons
wangans1149503wangans
wanguns1135023wanguns
wanion93213063wanion_
wanters104420093wanters
wanting114220173wanting
wantoned12117223wantoned
wantoner1187563wantoner
wantoners12116683wantoners
wantonly1443063wantonly
wants87932213want__s
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
whitens13428733whitens
wigeons1136983wigeons
windows1447743windows
winnows1334533winnows
winoes94317013win_oes
winos84625043win_o_s
winters103720483winters
wintles103414983wintles
witans93412933w_itans
wittols1035733wittols
womans114613653wo_mans
wonders113315993wonders
wondrous1246823wondrous
wonks124818343won__ks
wonners104312813wonners
wonning113210793wonning
wons74942043w___ons
wont75842503wont___
wonted103213283wont_ed
woods95723033wo__ods
woodtone1245153woodtone
woodtones1345123woodtones
woofs114918003wo__ofs
woolens10398843woolens
wools84421463wo__ols
woops104917523wo__ops
woos76238803wo__o_s
worsens104610263worsens
worths127812893wort_hs
worts88631183wort__s
wots76342893wo_t__s
wotting112913843wotting
wovens12449833wo_vens
wynns11517473wyn__ns
xenons132710483xen_ons
youpons12265983youpons
zonations18139313zonations
zoons144919693zo__ons

Search took 8 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.423422437.4
2DLD Change Limit1340273276.98619185.1
3Display Results3273270.1063084.9
 (SQL Overall)1786913277.51523777.9
 
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.